freepeople性欧美熟妇, 色戒完整版无删减158分钟hd, 无码精品国产vα在线观看DVD, 丰满少妇伦精品无码专区在线观看,艾栗栗与纹身男宾馆3p50分钟,国产AV片在线观看,黑人与美女高潮,18岁女RAPPERDISSSUBS,国产手机在机看影片

正文內(nèi)容

數(shù)據(jù)庫原理及應(yīng)用課程設(shè)計餐飲管理系統(tǒng)-在線瀏覽

2025-05-30 06:51本頁面
　　

【正文】 G_id)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。)goALTER TABLE CanZhuo_tableADD CHECK (CZ_id like 39。)goALTER TABLE CanJu_tableADD CHECK (CJ_id like 39。)goALTER TABLE DingDan_tableADD CHECK (DD_zhuangtai=39。 or DD_zhuangtai=39。 or DD_zhuangtai=39。)goALTER TABLE KeRen_tableADD CHECK (KR_zhifu=39。 or KR_zhifu=39。)goALTER TABLE SheBei_tableADD CHECK (SB_id like 39。)goALTER TABLE YG_tableADD CHECK (YG_id like 39。) goALTER TABLE YG_tableADD CHECK (YG_Sex=39。 or YG_Sex=39。)goALTER TABLE YG_tableADD CHECK (YG_phone like 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。,39。,32,39。,39。,30000,39。),(39。,39。,24,39。,39。,2000,39。),(39。,39。,31,39。,39。,2800,39。),(39。,39。,24,39。,39。,2000,39。),(39。,39。,25,39。,39。,3000,39。),(39。,39。,29,39。,39。,3000,39。),(39。,39。,33,39。,39。,2500,39。),(39。,39。,25,39。,39。,2500,39。),(39。,39。,24,39。,39。,20000,39。),(39。,39。,29,39。,39。,20000,39。)go菜單信息表CaiDan_table插入數(shù)據(jù)INSERT INTO CaiDan_table(CD_id,CD_name,CD_price)VALUES(39。,39。,126),(39。,39。,75),(39。,39。,54),(39。,39。,186),(39。,39。,76),(39。,39。,92),(39。,39。,48),(39。,39。,32),(39。,39。,36),(39。,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。,39。,39。,12,39。,39。),(39。,39。,39。,8,39。,39。),(39。,39。,39。,8,39。,39。),(39。,39。,39。,8,39。,39。),(39。,39。,39。,8,39。,39。),(39。,39。,39。,8,39。,39。),(39。,39。,39。,8,39。,39。),(39。,39。,39。,12,39。,39。),(39。,39。,39。,15,39。,39。),(39。,39。,39。,22,39。,39。)go餐具信息表CanJu_table插入數(shù)據(jù)INSERT INTO CanJu_table(CJ_id,CJ_name,CJ_shuliang,CZ_id)VALUES(39。,39。,30,39。),(39。,39。,10,39。),(39。,39。,12,39。),(39。,39。,5,39。),(39。,39。,10,39。),(39。,39。,8,39。),(39。,39。,50,39。),(39。,39。,20,39。),(39。,39。,18,39。),(39。,39。,48,39。),(39。,39。,12,39。),(39。,39。,15,39。)Go 設(shè)備信息表SheBei_table插入數(shù)據(jù)INSERT INTO SheBei_table(SB_id,SB_name,SB_cctime,SB_jxtime,CZ_id)VALUES(39。,39。,39。,39。,39。),(39。,39。,39。,39。,39。),(39。,39。,39。,39。,39。),(39。,39。,39。,39。,39。),(39。,39。,39。,39。,39。),(39。,39。,39。,39。,39。),(39。,39。,39。,39。,39。),(39。,39。,39。,39。,39。),(39。,39。,39。,39。,39。),(39。,39。,39。,39。,39。)Go客人信息表KeRen_table插入數(shù)據(jù)INSERT INTO KeRen_table(CZ_id,KR_renshu,KR_zhifu)VALUES(39。,11,39。),(39。,8,39。),(39。,10,39。),(39。,9,39。),(39。,8,39。),(39。,14,39。)go 訂單信息表YG_table插入數(shù)據(jù)INSERT INTO DingDan_table(DD_xuhao,DD_id,CD_id,CZ_id,YG_id,DD_time,DD_zhuangtai)VALUES(1,39。,39。,39。,39。,39。,39。),(2,39。,39。,39。,39。,39。,39。),(3,39。,39。,39。,39。
點擊復(fù)制文檔內(nèi)容
公司管理相關(guān)推薦
文庫吧　www.dybbs8.com
備案圖鄂ICP備17016276號-1