數(shù)據(jù)庫原理及應(yīng)用課程設(shè)計(jì)餐飲管理系統(tǒng)(編輯修改稿)
2025-05-09 06:51 本頁面
【文章內(nèi)容簡介】 goalter table KeRen_table add constraint FK_KEREN_TA_CHIFAN_CANZHUO_ foreign key (CZ_id) references CanZhuo_table (CZ_id)Goalter table SheBei_table add constraint FK_SHEBEI_T_WEIZHI_CANZHUO_ foreign key (CZ_id) references CanZhuo_table (CZ_id)Goalter table CanJu_table add constraint FK_CANJU_TA_SUOZAICAN_CANZHUO_ foreign key (CZ_id) references CanZhuo_table (CZ_id)Goalter table CanZhuo_table add constraint FK_CANZHUO__GUANLI_YG_TABLE foreign key (YG_id) references YG_table (YG_id)Goalter table DingDan_table add constraint FK_DINGDAN__CANZHAO_CAIDAN_T foreign key (CD_id) references CaiDan_table (CD_id)GoALTER TABLE CaiDan_tableADD CHECK (CD_id like 39。[AZ][09][09][09]39。)goALTER TABLE CanZhuo_tableADD CHECK (CZ_id like 39。[AZ][09][09][09]39。)goALTER TABLE CanJu_tableADD CHECK (CJ_id like 39。[09][09][09]39。)goALTER TABLE DingDan_tableADD CHECK (DD_zhuangtai=39。已上39。 or DD_zhuangtai=39。未上39。 or DD_zhuangtai=39。做ing39。)goALTER TABLE KeRen_tableADD CHECK (KR_zhifu=39。已結(jié)賬39。 or KR_zhifu=39。未結(jié)賬39。)goALTER TABLE SheBei_tableADD CHECK (SB_id like 39。[AZ][AZ][09][09][09]39。)goALTER TABLE YG_tableADD CHECK (YG_id like 39。[AZ][AZ][09][09][09]39。) goALTER TABLE YG_tableADD CHECK (YG_Sex=39。男39。 or YG_Sex=39。女39。)goALTER TABLE YG_tableADD CHECK (YG_phone like 39。[09][09][09][09][09][09][09][09][09][09][09]39。)go CHECE約束員工信息表YG_table插入數(shù)據(jù)use 餐飲管理goINSERT INTO YG_table(YG_id,YG_Name,YG_Age,YG_Sex,YG_Zhiwei,YG_Money,YG_phone)VALUES(39。JL00139。,39。王紅39。,32,39。女39。,39?？偨?jīng)理39。,30000,39。1378476552139。),(39。YG00139。,39。張三39。,24,39。男39。,39。員工39。,2000,39。1380477125439。),(39。YG00239。,39。王偉39。,31,39。男39。,39。員工39。,2800,39。1350474125439。),(39。YG00339。,39。趙麗39。,24,39。女39。,39。員工39。,2000,39。1380670255439。),(39。YG00439。,39。李四39。,25,39。男39。,39。收銀員39。,3000,39。1580142552839。),(39。YG00539。,39。柴如珂彤39。,29,39。女39。,39。收銀員39。,3000,39。1580147252839。),(39。YG00639。,39。王晶39。,33,39。女39。,39。員工39。,2500,39。1352415589639。),(39。YG00739。,39。張華39。,25,39。男39。,39。員工39。,2500,39。1580121542839。),(39。JL00239。,39。王月倩39。,24,39。女39。,39。經(jīng)理39。,20000,39。1580147236939。),(39。JL00339。,39。李磊39。,29,39。男39。,39。經(jīng)理39。,20000,39。1525844252839。)go菜單信息表CaiDan_table插入數(shù)據(jù)INSERT INTO CaiDan_table(CD_id,CD_name,CD_price)VALUES(39。C00139。,39。松鼠魚39。,126),(39。C00239。,39。辣子雞丁39。,75),(39。C00339。,39。麻婆豆腐39。,54),(39。Y00139。,39。清蒸鱸魚39。,186),(39。Y00239。,39。石榴雞39。,76),(39。Y00339。,39。楊桃釀肉39。,92),(39。L00139。,39。醋椒丸子39。,48),(39。L00239。,39。拔絲蘋果39。,32),(39。L00339。,39。四喜丸子39。,36),(39。L00439。,39。山東風(fēng)味五香香腸39。,28)Go 餐桌信息表CanZhuo_table插入數(shù)據(jù)INSERT INTO CanZhuo_table(CZ_id,CZ_leixing,CZ_weizhi,CZ_zuowei,CZ_qingkuang,YG_id)VALUES(39。D00139。,39。12人桌39。,39。大廳39。,12,39。已使用39。,39。YG00139。),(39。D00239。,39。8人桌39。,39。大廳39。,8,39。未使用39。,39。YG00139。),(39。D00339。,39。8人桌39。,39。大廳39。,8,39。已使用39。,39。YG00239。),(39。D00439。,39。10人桌39。,39。大廳39。,8,39。未使用39。,39。YG00239。),(39。D00539。,39。10人桌39。,39。大廳39。,8,39。已使用39。,39。YG00339。),(39。D00639。,39。8人桌39。,39。大廳39。,8,39。已使用39。,39。YG00639。),(39。D00739。,39。8人桌39。,39。大廳39。,8,39。已使用39。,39。YG00739。),(39。Y00139。,39。天蝎座39。,39。雅間39。,12,39。未使用39。,39。YG00339。),(39。Y00239。,39。金牛座39。,39。雅間39。,15,39。已使用39。,39。YG00439。),(39。Y00339。,39。雙子座39。,39。雅間39。,22,39。停用39。,39。YG00539。)go餐具信息表CanJu_
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1