where id = object_id('Relationship_7') and type = 'U') drop table Relationship_7 go
if exists (select 1
from sysobjects
where id = object_id('Relationship_8') and type = 'U') drop table Relationship_8 go
if exists (select 1
from sysobjects
where id = object_id('业务部门') and type = 'U') drop table 业务部门 go
if exists (select 1
from sysobjects
where id = object_id('供货商') and type = 'U') drop table 供货商 go
if exists (select 1
from sysobjects
where id = object_id('供货表') and type = 'U') drop table 供货表 go
if exists (select 1
from sysobjects
where id = object_id('客户') and type = 'U') drop table 客户 go
if exists (select 1
from sysobjects
where id = object_id('库存管理员') and type = 'U')
drop table 库存管理员 go
if exists (select 1
from sysobjects
where id = object_id('库存表') and type = 'U') drop table 库存表 go
if exists (select 1
from sysobjects
where id = object_id('统计报表') and type = 'U') drop table 统计报表 go
if exists (select 1
from sysobjects
where id = object_id('订单表') and type = 'U') drop table 订单表 go
if exists (select 1
from sysobjects
where id = object_id('财会部门') and type = 'U') drop table 财会部门 go
if exists (select 1
from sysobjects
where id = object_id('财务结算表') and type = 'U') drop table 财务结算表 go
if exists (select 1
from sysobjects
where id = object_id('采购员') and type = 'U') drop table 采购员 go
if exists (select 1
from sysobjects
where id = object_id('采购表') and type = 'U') drop table 采购表 go
if exists (select 1
from sysobjects
where id = object_id('销售部门') and type = 'U') drop table 销售部门 go
/*==============================================================*/ /* Table: Relationship_18 */
/*==============================================================*/ create table Relationship_18 (
供货商编号 int not null, 结算表编号 int not null,
constraint PK_RELATIONSHIP_18 primary key (供货商编号, 结算表编号) ) go
/*==============================================================*/ /* Index: Relationship_22_FK */
/*==============================================================*/ create index Relationship_22_FK on Relationship_18 ( 供货商编号 ASC ) go
/*==============================================================*/ /* Index: Relationship_23_FK */
/*==============================================================*/ create index Relationship_23_FK on Relationship_18 ( 结算表编号 ASC ) go
/*==============================================================*/ /* Table: Relationship_19 */
/*==============================================================*/
create table Relationship_19 (
客户编号 int not null, 结算表编号 int not null,
constraint PK_RELATIONSHIP_19 primary key (客户编号, 结算表编号) ) go
/*==============================================================*/ /* Index: Relationship_24_FK */
/*==============================================================*/ create index Relationship_24_FK on Relationship_19 ( 客户编号 ASC ) go
/*==============================================================*/ /* Index: Relationship_25_FK */
/*==============================================================*/ create index Relationship_25_FK on Relationship_19 ( 结算表编号 ASC ) go
/*==============================================================*/ /* Table: Relationship_5 */
/*==============================================================*/ create table Relationship_5 (
部门编号1 int not null, 采购员编号 int not null,
constraint PK_RELATIONSHIP_5 primary key (部门编号1, 采购员编号) ) go
/*==============================================================*/ /* Index: Relationship_5_FK */
/*==============================================================*/ create index Relationship_5_FK on Relationship_5 ( 部门编号1 ASC ) go
/*==============================================================*/ /* Index: Relationship_6_FK */
/*==============================================================*/
create index Relationship_6_FK on Relationship_5 ( 采购员编号 ASC ) go
/*==============================================================*/ /* Table: Relationship_6 */
/*==============================================================*/ create table Relationship_6 (
采购员编号 int not null, 采购表编号 int not null,
constraint PK_RELATIONSHIP_6 primary key (采购员编号, 采购表编号) ) go
/*==============================================================*/ /* Index: Relationship_7_FK */
/*==============================================================*/ create index Relationship_7_FK on Relationship_6 ( 采购员编号 ASC ) go
/*==============================================================*/ /* Index: Relationship_8_FK */
/*==============================================================*/ create index Relationship_8_FK on Relationship_6 ( 采购表编号 ASC ) go
/*==============================================================*/ /* Table: Relationship_7 */
/*==============================================================*/ create table Relationship_7 (
采购表编号 int not null, 供货商编号 int not null,
constraint PK_RELATIONSHIP_7 primary key (采购表编号, 供货商编号) ) go
/*==============================================================*/ /* Index: Relationship_9_FK */
/*==============================================================*/