【正文】 K *//*==============================================================*/create index position2_FK on position (goods_id ASC)go/*==============================================================*//* Table: goods *//*==============================================================*/create table goods ( goods_id text not null, goods_name text null, goods_unit text null, constraint PK_GOODS primary key nonclustered (goods_id))go/*==============================================================*//* Table: material *//*==============================================================*/create table material ( material_id1 text not null, material_name text null, price1 money null, per_unit text null, constraint PK_MATERIAL primary key nonclustered (material_id1))go/*==============================================================*//* Table: order *//*==============================================================*/create table order ( order_id text not null, material_id1 text null, user_id text null, pany_id1 text null, purchasing_id text null, material_id text null, material_unit text null, material_num tinyint null, making_time datetime null, deadline datetime null, price1 money null, price_all money null, pany_id text null, making_person text null, check_person text null, checked bit null, sended bit null, constraint PK_ORDER primary key nonclustered (order_id))go/*==============================================================*//* Index: Relationship_1_FK *//*==============================================================*/create index Relationship_1_FK on order (user_id ASC)go/*==============================================================*//* Index: generate_FK *//*==============================================================*/create index generate_FK on order (purchasing_id ASC)go/*==============================================================*//* Index: destination_FK *//*==============================================================*/create index destination_FK on order (pany_id1 ASC)go/*==============================================================*//* Index: content_FK *//*==============================================================*/create index content_FK on order (material_id1 ASC)go/*==============================================================*//* Table: purchasing *//*==============================================================*/create table purchasing ( purchasing_id text not null, warehouse_id text null, managername text null, telephone text null, constraint PK_PURCHASING primary key nonclustered (purchasing_id))go/*==============================================================*//* Index: stockout2_FK *//*==============================================================*/create index stockout2_FK on purchasing (warehouse_id ASC)go/*=================