【正文】 *//*==============================================================*/create table supply ( material_id1 text not null, pany_id1 text not null, constraint PK_SUPPLY primary key (material_id1, pany_id1))go/*==============================================================*//* Index: supply_FK *//*==============================================================*/create index supply_FK on supply (material_id1 ASC)go/*==============================================================*//* Index: supply2_FK *//*==============================================================*/create index supply2_FK on supply (pany_id1 ASC)go/*==============================================================*//* Table: user *//*==============================================================*/create table user ( user_id text not null, purchasing_id text null, user_name text null, user_password bigint null, constraint PK_USER primary key nonclustered (user_id))go/*==============================================================*//* Index: managment_FK *//*==============================================================*/create index managment_FK on user (purchasing_id ASC)go/*==============================================================*//* Table: warehouse *//*==============================================================*/create table warehouse ( warehouse_id text not null, purchasing_id text null, warehouse_name text null, warehouse_telephone text null, warehouse_administrator text null, constraint PK_WAREHOUSE primary key nonclustered (warehouse_id))go/*==============================================================*//* Index: stockout_FK *//*==============================================================*/create index stockout_FK on warehouse (purchasing_id ASC)goalter table position add constraint FK_COMPOSIT_COMPOSITI_MATERIAL foreign key (material_id1) references material (material_id1)goalter table position add constraint FK_COMPOSIT_COMPOSITI_GOODS foreign key (goods_id) references goods (goods_id)goalter table order add constraint FK_ORDER_RELATIONS_USER foreign key (user_id) references user (user_id)goalter table order add constraint FK_ORDER_CONTENT_MATERIAL foreign key (material_id1) references material (material_id1)goalter table order add constraint FK_ORDER_DESTINATI_COMPANY foreign key (pany_id1) references pany (pany_id1)goalter table order add constraint FK_ORDER_GENERATE_PURCHASI foreign key (purchasing_id) references purchasing (purchasing_id)goalter table purchasing add constraint FK_PURCHASI_STOCKOUT2_WAREHOUS foreign key (warehouse_id) references warehouse (warehouse_id)goalter table supply add constraint FK_SUPPLY_SUPPLY_MATERIAL foreign key (material_id1) references material (material_id1)goalter table supply add constraint FK_SUPPLY_SUPPLY2_COMPANY foreign key (pany_id1) references pany (pany_id1)goalter table user add constraint FK_USER_MANAGMENT_PURCHASI foreign key (purchasing_id) references purchasing (purchasing_id)goalter table warehouse add constraint FK_WAREHOUS_STOCKOUT_PURCHASI foreign key (purchasing_id) references purchasing (purchasing_id)go通過本次課程設(shè)計，使我對數(shù)據(jù)庫有了個整體的了解和深入的理解，以前很多不懂得，甚至沒有接觸到過的步驟和方法，現(xiàn)在都牢牢掌握。課程設(shè)計是個很鍛煉人整體思維的方法，它使得我們把在學(xué)校所學(xué)的東西一點一點的整合起來，增加學(xué)生對這個專業(yè)的理解和喜歡程度。這次數(shù)據(jù)庫的課程設(shè)計，我也發(fā)現(xiàn)了自己有很多不足的地方，主要是基礎(chǔ)知識部分不夠牢靠，還需要抓緊時間鞏固，同時也要多吸收點新的知識，讓自己大腦豐富起來，也使自己的設(shè)計更加完善。第 30 頁 共 30 頁