物业管理系统-数据库设计
create table house (楼盘编号varchar(20)primary key, 楼盘名称varchar(20)not null, 楼层数smallint, 面积float(20), 户型varchar(40), 地址varchar(40), ); create table people (业主编号varchar(20) primary key, 姓名varchar(30), 性别varchar(10), 电话varchar(20), 楼盘编号varchar(20), 门牌号varchar(20), 身份证varchar(20), constraint empfkey foreign key (楼盘编号)references house(楼盘编号), constraint c1 check(性别in ('男','女')), ); create procedure re as select * from repair go exec re create procedure com as select * from complain go exec com
0
635
409KB
2013-07-07
50