数据库原理代码.doc

USE 13计科班GO/* 对象: Table U20132064.ManagerInfor 脚本日期: 12/03/2015 11:43:21 */SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE U20132064.ManagerInfor(Eid char(10) COLLATE Chinese_PRC_CI_AS NOT NULL,Ename varchar(20) COLLATE Chinese_PRC_CI_AS NOT NULL,Eage char(10) COLLATE Chinese_PRC_CI_AS NULL,Egender char(10) COLLATE Chinese_PRC_CI_AS NULL,EPnumber varchar(50) COLLATE Chinese_PRC_CI_AS NULL,Epassword varchar(10) COLLATE Chinese_PRC_CI_AS NOT NULL,Duty char(40) COLLATE Chinese_PRC_CI_AS NOT NULL,PCid char(10) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT Eidkey PRIMARY KEY CLUSTERED (Eid ASC) ON PRIMARY) ON PRIMARYGOSET ANSI_PADDING OFFGOALTER TABLE U20132064.ManagerInfor WITH NOCHECK ADD CONSTRAINT PCidFkey FOREIGN KEY(PCid)REFERENCES U20132064.PetCenterInfor (PCid)ON UPDATE CASCADEON DELETE CASCADEGOALTER TABLE U20132064.ManagerInfor CHECK CONSTRAINT PCidFkeyUSE 13计科班GO/* 对象: Table U20132064.MasterInfor 脚本日期: 12/03/2015 11:44:40 */SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE U20132064.MasterInfor(Mid char(10) COLLATE Chinese_PRC_CI_AS NOT NULL,Mname char(20) COLLATE Chinese_PRC_CI_AS NOT NULL,Mgender char(4) COLLATE Chinese_PRC_CI_AS NULL,Maddress char(30) COLLATE Chinese_PRC_CI_AS NULL,MPnumber varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,Mpassword char(10) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT Midkey PRIMARY KEY CLUSTERED (Mid ASC) ON PRIMARY) ON PRIMARYGOSET ANSI_PADDING OFFGOALTER TABLE U20132064.MasterInfor WITH NOCHECK ADD CONSTRAINT MgenderChk CHECK (Mgender = 男 or Mgender = 女)GOALTER TABLE U20132064.MasterInfor CHECK CONSTRAINT MgenderChkUSE 13计科班GO/* 对象: Table U20132064.PetCenterInfor 脚本日期: 12/03/2015 11:45:01 */SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE U20132064.PetCenterInfor(PCid char(10) COLLATE Chinese_PRC_CI_AS NOT NULL,PCname char(20) COLLATE Chinese_PRC_CI_AS NOT NULL,PCaddress char(10) COLLATE Chinese_PRC_CI_AS NULL,PCPnumber char(20) COLLATE Chinese_PRC_CI_AS NULL,SOid nchar(10) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT PCidkey PRIMARY KEY CLUSTERED (PCid ASC) ON PRIMARY) ON PRIMARYGOSET ANSI_PADDING OFFGOALTER TABLE U20132064.PetCenterInfor WITH NOCHECK ADD CONSTRAINT SOidFkey FOREIGN KEY(SOid)REFERENCES U20132064.ShopOwnerInfor (SOid)ON UPDATE CASCADEON DELETE CASCADEGOALTER TABLE U20132064.PetCenterInfor CHECK CONSTRAINT SOidFkeyUSE 13计科班GO/* 对象: Table U20132064.PetInfor 脚本日期: 12/03/2015 11:45:33 */SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE U20132064.PetInfor(Petid char(10) COLLATE Chinese_PRC_CI_AS NOT NULL,Petkind varchar(20) COLLATE Chinese_PRC_CI_AS NOT NULL,Petage int NOT NULL,Petgender varchar(4) COLLATE Chinese_PRC_CI_AS NOT NULL,Petname varchar(20) COLLATE Chinese_PRC_CI_AS NULL,Health varchar(20) COLLATE Chinese_PRC_CI_AS NULL,State char(10) COLLATE Chinese_PRC_CI_AS NOT NULL,Food varchar(10) COLLATE Chinese_PRC_CI_AS NULL,Cleanday datetime NULL,Mid char(10) COLLATE Chinese_PRC_CI_AS NOT NULL,Eid char(10) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT Petidkey PRIMARY KEY CLUSTERED (Petid ASC) ON PRIMARY) ON PRIMARYGOSET ANSI_PADDING OFFGOALTER TABLE U20132064.PetInfor WITH NOCHECK ADD CONSTRAINT EidFkey FOREIGN KEY(Eid)REFERENCES U20132064.ManagerInfor (Eid)ON UPDATE CASCADEON DELETE CASCADEGOALTER TABLE U20132064.PetInfor CHECK CONSTRAINT EidFkeyGOALTER TABLE U20132064.PetInfor WITH NOCHECK ADD CONSTRAINT MidFkey FOREIGN KEY(Mid)REFERENCES U20132064.MasterInfor (Mid)ON UPDATE CASCADEON DELETE CASCADEGOALTER TABLE U20132064.PetInfor CHECK CONSTRAINT MidFkeyGOALTER TABLE U20132064.PetInfor WITH NOCHECK ADD CONSTRAINT PetgenderChk CHECK (Petgender = 公 or Petgender = 母)GOALTER TABLE U20132064.PetInfor CHECK CONSTRAINT PetgenderChkGOALTER TABLE U20132064.PetInfor WITH NOCHECK ADD CONSTRAINT StateChk CHECK (State = IN or State = OUT)GOALTER TABLE U20132064.PetInfor CHECK CONSTRAINT StateChkUSE 13计科班GO/* 对象: Table U20132064.ShopOwnerInfor 脚本日期: 12/03/2015 11:46:10 */SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE U20132064.ShopOwnerInfor(SOid nchar(10) COLLATE Chinese_PRC_CI_AS NOT NULL,SOname char(20) COLLATE Chinese_PRC_CI_AS NOT NULL,SOPnumber char(20) COLLATE Chin