【正文】 =============================*//* Table: Relationship_6 *//*==============================================================*/create table Relationship_6 ( jhh int not null, xsj int not null, constraint PK_RELATIONSHIP_6 primary key (jhh, xsj))godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。go/*==============================================================*//* Index: Relationship_7_FK *//*==============================================================*/create index Relationship_7_FK on Relationship_4 (sph ASC)go/*==============================================================*//* Index: Relationship_8_FK *//*==============================================================*/create index Relationship_8_FK on Relationship_4 (thh ASC)go/*==============================================================*//* Table: Relationship_5 *//*==============================================================*/create table Relationship_5 ( bh int not null, sph int not null, constraint PK_RELATIONSHIP_5 primary key (bh, sph))godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。go/*==============================================================*//* Index: Relationship_5_FK *//*==============================================================*/create index Relationship_5_FK on Relationship_3 (bh ASC)go/*==============================================================*//* Index: Relationship_6_FK *//*==============================================================*/create index Relationship_6_FK on Relationship_3 (xsj ASC)go/*==============================================================*//* Table: Relationship_4 *//*==============================================================*/create table Relationship_4 ( sph int not null, thh int not null, constraint PK_RELATIONSHIP_4 primary key (sph, thh))godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。go/*==============================================================*//* Index: Relationship_3_FK *//*==============================================================*/create index Relationship_3_FK on Relationship_2 (sph ASC)go/*==============================================================*//* Index: Relationship_4_FK *//*==============================================================*/create index Relationship_4_FK on Relationship_2 (jhh ASC)go/*==============================================================*//* Table: Relationship_3 *//*==============================================================*/create table Relationship_3 ( bh int not null, xsj int not null, constraint PK_RELATIONSHIP_3 primary key (bh, xsj))godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。go/*==============================================================*//* Index: Relationship_1_FK *//*==============================================================*/create index Relationship_1_FK on Relationship_1 (jhh ASC)go/*==============================================================*//* Index: Relationship_2_FK *//*==============================================================*/create index Relationship_2_FK on Relationship_1 (ghsh ASC)go/*==============================================================*//* Table: Relationship_2 *//*==============================================================*/create table Relationship_2 ( sph int not null, jhh int not null, constraint PK_RELATIONSHIP_2 primary key (sph, jhh))godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。, 39。, 39。) drop table ygxxgo/*==============================================================*//* Table: Relationship_1 *//*==============================================================*/create table Relationship_1 ( jhh int not null, ghsh int not null, constraint PK_RELATIONSHIP_1 primary key (jhh, ghsh))godeclare CurrentUser sysnameselect CurrentUser = user_name()execute sp_addextendedproperty 39。) drop table xsxxgoif exists (select 1 from sysobjects where id = object_id(39。) drop table thxxgoif exists (select 1 from sysobjects where id = object_id(39。) drop table kcxxgoif exists (select 1 from sysobjects where id = object_id(39。) drop table jhxxgoif exists (select 1 from sysobjects where id = object_id(39。) drop table ghsxxgoif exists (select 1 from sysobjects where id = object_id(39。) drop table Relationship_6goif exists (select 1 from sysobjects where id = object_id(39。 and indid 0 and indid 25