數(shù)據(jù)庫原理課程設(shè)計——倉庫管理系統(tǒng)-全文預覽
【正文】 exvarcharnot null表 4 3 system_customers領(lǐng)設(shè)備人員信息表格說明列名類型可否為空領(lǐng)設(shè)備人員號Cus_idvarcharnot null(主碼)領(lǐng)設(shè)備人員姓名Cus_namevarcharnot null設(shè)備號Equ_idvarcharnot null(外碼)領(lǐng)取數(shù)量Cus_numvarcharnot null領(lǐng)取日期Receive_datevarchar歸還日期Return_datevarchar表 4 4 system_equipment設(shè)備信息表格說明列名類型可否為空設(shè)備號Equ_idvarcharnot null(主碼)設(shè)備名稱Equ_namevarcharnot null設(shè)備狀態(tài)Equ_statevarcharnot null采購員號Age_idvarcharnot null(外碼)供貨單位Sup_appartmentvarcharnot null領(lǐng)設(shè)備人員號Cus_idvarcharnot null(外碼)庫存量Stock_numvarcharnot null表 4 5 system_order采購訂單信息表格說明列名類型可否為空訂單號Order_idvarcharnot null(主碼)采購員號Age_idvarcharnot null(外碼)管理員號Adm_idvarcharnot null(外碼)訂購日期Order_datevarcharnot null設(shè)備號Equ_idvarcharnot null(外碼)設(shè)備名稱Equ_namevarcharnot null價格Oreder_pricevarcharnot null數(shù)量Order_numvarcharnot null表 4 6 system_supply供貨單信息表格說明列名類型可否為空訂單號Order_idvarcharnot null(外碼)供貨日期Sup_datevarcharnot null供貨地址Sup_addvarcharnot null供貨人身份證號Sup_idvarcharnot null(主碼)供貨人姓名Sup_namevarcharnot null供貨單位Sup_appartmentvarcharnot null 數(shù)據(jù)庫的實現(xiàn) （1） 管理員表的建立create table system_administrator( Adm_id varchar primary key not null, Adm_name varchar not null, )（2） 采購員表的建立create table system_purchasing_agent( Age_id varchar primary key not null, Age_name varchar not null, Age_sex varchar not null, )（3） 領(lǐng)設(shè)備人員表的建立create table system_customers(Cus_id varchar primary key not null,Cus_name varchar not null,Equ_id varchar not null,Cus_num varchar not null,Receive_date varchar,Return_date varchar,foreign key (Equ_id) references system_equipment(Equ_id),)（4） 設(shè)備表的建立create table system_equipment( Equ_id varchar primary key not null,Equ_name varchar not null,Equ_state varchar not null,Age_id varchar not null,Sup_appartment varchar not null,Cus_id varchar not null,Stock_num varchar not null,foreign key (Age_id) references system_purchasing_agent (Age_id),)（5） 采購訂單表的建立create table system_order(Order_id varchar primary key not null,Age_id varchar not null,Adm_id varchar not null,Order_date varchar not null,Equ_id varchar not null,Equ_name varchar not null,Oreder_price varchar not null,Order_num varchar not null,foreign key (Age_id) references system_purchasing_agent (Age_id),foreign key (Adm_id) references system_administrator (Adm_id),foreign key (Equ_id) references system_equipment (Equ_id),)（6） 供貨單表的建立create table system_supply(Order_id varchar not null,Sup_date varchar not null,Sup_add varchar no
法律信息相關(guān)推薦
鄂ICP備17016276號-1