- 博客(0)
- 资源 (2)
空空如也
物业管理系统-数据库设计
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
2013-07-07
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人