【文章內(nèi)容簡介】 9。column39。, 39。jhh39。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。MS_Description39。, 39。員工編號39。, 39。user39。, @CurrentUser, 39。table39。, 39。Relationship_339。, 39。column39。, 39。bh39。godeclare @CurrentUser sysnameselect @CurrentUser = user_name()execute sp_addextendedproperty 39。MS_Description39。, 39。銷售號39。, 39。user39。, @CurrentUser, 39。table39。, 39。Relationship_339。, 39。column39。, 39。xsj39。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。MS_Description39。, 39。商品號39。, 39。user39。, @CurrentUser, 39。table39。, 39。Relationship_439。, 39。column39。, 39。sph39。godeclare @CurrentUser sysnameselect @CurrentUser = user_name()execute sp_addextendedproperty 39。MS_Description39。, 39。退貨號39。, 39。user39。, @CurrentUser, 39。table39。, 39。Relationship_439。, 39。column39。, 39。thh39。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。MS_Description39。, 39。員工編號39。, 39。user39。, @CurrentUser, 39。table39。, 39。Relationship_539。, 39。column39。, 39。bh39。godeclare @CurrentUser sysnameselect @CurrentUser = user_name()execute sp_addextendedproperty 39。MS_Description39。, 39。商品號39。, 39。user39。, @CurrentUser, 39。table39。, 39。Relationship_539。, 39。column39。, 39。sph39。go/*==============================================================*//* Index: Relationship_9_FK *//*==============================================================*/create index Relationship_9_FK on Relationship_5 (bh ASC)go/*==============================================================*//* Index: Relationship_10_FK *//*==============================================================*/create index Relationship_10_FK on Relationship_5 (sph ASC)go/*==============================================================*//* 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。MS_Description39。, 39。進貨號39。, 39。user39。, @CurrentUser, 39。table39。, 39。Relationship_639。, 39。column39。, 39。jhh39。godeclare @CurrentUser sysnameselect @CurrentUser = user_name()execute sp_addextendedproperty 39。MS_Description39。, 39。銷售號39。, 39。user39。, @CurrentUser, 39。table39。, 39。Relationship_639。, 39。column39。, 39。xsj39。go/*==============================================================*//* Index: Relationship_11_FK *//*==============================================================*/create index Relationship_11_FK on Relationship_6 (jhh ASC)go/*==============================================================*//* Index: Relationship_12_FK *//*==============================================================*/create index Relationship_12_FK on Relationship_6 (xsj ASC)go/*==============================================================*//