大数据库系统原理 餐厅点菜管理系统

ll,/*数量*/constraintMenuDetailPKprimarykeyclustered(menuNo,dishesNo),constraintMenuDetailFK1foreignkey(menuNo)referencesMenu(menuNo),constraintMenuDetailFK2foreignkey(dishesNo)referencesDishes(dishesNo))gograntallonMenudetailtouser01grantdelete,insertonMenuDetailtocustomergrantselectonMenuDetailtocustomer,qiantaigoprint'createtableEvaluate'gocreatetableEvaluate(tableNochar(4)notnull,/*桌台编号*/dishesNochar(7)notnull/*菜品编号*/check(dishesNolike'[G][0-9][0-9][0-9][0-9][0-9][0-9]'),scoreintnotnull,/*分数*/constraintEvaluatePKprimarykeyclustered(tableNo,dishesNo),constraintEvaluateFK1foreignkey(tableNo)referencesTable1(tableNo),constraintEvaluateFK2foreignkey(dishesNo)referencesDishes(dishesNo))gograntallonEvaluatetouser01grantupdateonMenuDetailtocustomergrantselectonMenuDetailtocustomer,qiantaigo文档大全