《面向对象软件工程与UML 教学课件 ppt 作者 张京 租赁房的代码预览》由会员分享,可在线阅读,更多相关《面向对象软件工程与UML 教学课件 ppt 作者 张京 租赁房的代码预览(3页珍藏版)》请在金锄头文库上搜索。
1、(5)租赁房的代码预览。alter table TenancyBargin drop constraint FK_TENANCYB_C_TENANCY_TENANCYHgoif exists (select 1 from sysindexes where id = object_id(TenancyHouse) and name = C_Tenancy_FK and indid 0 and indid 0 and indid 0 and indid 255) drop index TenancyBargin.HouseHost_Contract_FKgoif exists (select 1
2、from sysobjects where id = object_id(TenancyBargin) and type = U) drop table TenancyBargingo/*=*/* Table: TenancyBargin */*=*/create table TenancyBargin ( BarginID char(10) not null, yid char(18) not null, TenancyID char(10) not null, jID char(10) not null, BarginMoney numeric(10,2) null, StartTime
3、datetime null, StopTime datetime null, constraint PK_TENANCYBARGIN primary key (BarginID)go/*=*/* Index: Person_Contract_FK */*=*/create index Person_Contract_FK on TenancyBargin (yid)go/*=*/* Index: HouseHost_Contract_FK */*=*/create index HouseHost_Contract_FK on TenancyBargin (jID)goalter table T
4、enancyBargin add constraint FK_TENANCYB_PERSON_CO_PERMSG foreign key (yid) references PerMsg (yid)goalter table TenancyBargin add constraint FK_TENANCYB_HOUSEHOST_HOUSEHOS foreign key (jID) references HouseHost (jID)goalter table TenancyBargin add constraint FK_TENANCYB_C_TENANCY_TENANCYH foreign key (TenancyID) references TenancyHouse (TenancyID)go