一个典型的数据库设计实例2资料.docVIP

Spbh char P Spmc varchar 2t1 Sslb char 8 Jg money 8 sI url 4 bmhh char 4 xfzje money 8 kcxxbh char k cl int Xsrq t1 tctimc 8? Zje Money 6 Hybh C’har 8 $yyhh char P create database gl xt ( name os dat, fil ename=D:\pos dat.andf, size-5, maxsize-20, fiiegrowth- 1) LOG on ( narne=pos log, filenarne=D:\pos log.ldf, size-5, create table bin (bmbh char(8) not null constraint PK biro primary key, bmmc char(4) not null ) g° create table sp (spbh char(8) riot null constraint PK cno primary key, apmc varchar(20) not null , sslb char(8) not null, st int riot null, jg money not null ) 4. create table gys (gysbh chart8) not null constraint BK dno primary gysmc chait8) not null, dz varc h art20) riot null, yzbm char( P) net null, dhhm varchar( 15) not null, sh varchar(3) riot null, yhzh varchaq20) not null,  key, khyh char(8?) not null , lxr chart 8) not null, bei zhu text null create table hy (hybh cha58) riot nut I constrai nt PK eno Ji rimory key. hyname char( 6)not rim I , sex chur(2) check CK hy sex i n ( ’ ’ , ’ V ’) n or nul I , sfzh v arch a520) ncit null, xfzje money not null, j I int not null create table yg (ygbh chart 8) not nu I I constraint PK fire primary key, ygnamc char(8) not iiul I, sex ch or(2 ) check CK yg sex in ( ’ ’, k ’) not null, zvv cha rfP) not rim I, k I v arch ar(20) riot null, q xjb charl 4) not ml I, sfzh v archa518) not riu II, ss1?mbh chai(8) not inn I const rai nt FK ano foreign key references bin( bmhh) create table rk (rkbh c ha r(8) not nul I const rai nt PK quo primary key, xsjg m oiicy not n uI I, rkrq datetimc not nut I, spbh chart 8) not null constraint FK bno foreign key references sp(spbh), ywybh charf 8) not null constraint FK cue foreign key references yg(ygbh J, j I tl w ch an 2) not null, rkjg money not null, w bh chart 8) not nut I constraint FK duo foreign key references gyst gysbh), zje mtiiicy not nuI I, sl iii t not null create table zhuxx (xsrq datetime not ml I, zje money not null, constr