物資采購(gòu)課程設(shè)計(jì)論文-資料下載頁(yè)
2025-01-17 03:56本頁(yè)面
【正文】 *//*==============================================================*/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通過(guò)本次課程設(shè)計(jì)，使我對(duì)數(shù)據(jù)庫(kù)有了個(gè)整體的了解和深入的理解，以前很多不懂得，甚至沒(méi)有接觸到過(guò)的步驟和方法，現(xiàn)在都牢牢掌握。課程設(shè)計(jì)是個(gè)很鍛煉人整體思維的方法，它使得我們把在學(xué)校所學(xué)的東西一點(diǎn)一點(diǎn)的整合起來(lái)，增加學(xué)生對(duì)這個(gè)專(zhuān)業(yè)的理解和喜歡程度。這次數(shù)據(jù)庫(kù)的課程設(shè)計(jì)，我也發(fā)現(xiàn)了自己有很多不足的地方，主要是基礎(chǔ)知識(shí)部分不夠牢靠，還需要抓緊時(shí)間鞏固，同時(shí)也要多吸收點(diǎn)新的知識(shí)，讓自己大腦豐富起來(lái)，也使自己的設(shè)計(jì)更加完善。第 30 頁(yè) 共 30 頁(yè)
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1