房地产销售管理系统

order_id char(6) not null,

foreign key (remand_id) references remand_customer(remand_id), foreign key (order_id) references order_customer(order_id) )

4.1.6预订客户表：

create table order_customer (

order_id char(6) not null primary key, order_name int not null, order _sex char(2) not null, order _age int not null,

order _job char(10) not null, order _ident char(18) not null, order_phone char(12) not null, order_addr char(25) not null, order_pay char(10) not null )

4.1.7预订房屋表：

create table order_room (

contract_id char(6) not null primary key, build_id int not null, unit_id int not null, room_id char(4) not null,

room_type char(10) not null, area float not null, price float not null,

total_price float not null, order_date date not null, yifu_money float,

weifu_money float not null )

4.1.8预订表：

create table oder (

contract_id char(6) not null, order_id char(6) not null,

foreign key (contract_id) references order_room(contract_id), foreign key (order_id) references order_customer(order_id) )

4.1.9需求客户表：

create table remand_customer (

remand_id char(6) not null primary key, remand_name char(15) not null, remand_sex char(2), remand_ident char(18),

remand_phone char(12), remand_addr char(25) )

4.1.10需求房屋表：

create table remand_build (

remand_buildid char(6) not null primary key, build_id int not null, unit_id int not null, room_id char(4) not null, room_type char(10) not null, area float not null, price float not null,

total_price float not null )

4.1.11购买需求表：

create table remand_buy (

remand_id char(6) not null,

remand_buildid char(6) not null,

foreign key (remand_id) references remand_customer(remand_id),

foreign key (remand_buildid) references remand_build(remand_buildid) )

4.1.12收款表：

create table collection (

contract_id char(6) not null, order_id char(6) not null,

foreign key (contract_id) references order_room(contract_id), foreign key (order_id) references order_customer(order_id) )

4．2 序列的设计

4.2.1创建一个名为“build_seq”的序列，用于产生楼房编号，起始值为1，步长为1，不

缓存，不循环。

4.2.2创建一个名为“unit_seq”的序列，用于产生单元编号，起始值为1，步长为1，最

大值为9999，不缓存，不循环。