酒店订餐系统数据库设计和实现1.doc

酒店订餐管理系统源代码 create database 酒店订餐系统 on ( name=酒店订餐, filename=D:\酒店订餐.mdf, size=10, maxsize=50, filegrowth=5 ) log on ( name =酒店订餐_log, filename=D:\酒店订餐.ldf, size=5, maxsize=25, filegrowth=5 ) create table cookbook ( Cooknumber char (9) primary key, /*菜单编号*/ name char (20) unique, /*菜单名*/ Member_price float (6), /*会员价格*/ constraint price_chk check (Member_price=0) ) Create table order_list (Lnumber char (9) primary key , /*订单编号*/ Chinastyle_food char (20), /*中餐*/ Westernstyle_food char (20), /*西餐*/ medical_food char(20), /*药膳菜品*/ snack char (20) /*小吃*/ ) Create table listorder (Lnumber char (9) primary key , /*订单编号*/ Delivery_order char (20), /*顶单状态*/ Unumber char (20), /*订餐者编号*/ 时间 datetime, alllist decimal (6,2), /*合计*/ Cnumber char (20) /*管理员编号*/ ) Create table 用户 ( Unumber char (9) primary key, /*会员帐号*/ Uname char (20), /*姓名*/ Usex char (4) default男, /*性别*/ Ucode char (9), /*密码*/ Telephone char(12), /*常用电话*/ Address char(40) /*收货具体地点*/ ) Create table controller (Cnumber char (9) primary key, /*管理员编号*/ Cname char (20), /*管理员姓名*/ Csex char (4), /*管理员性别*/ Cage smallint, /*管理员年龄*/ Cdepartment char (20) /*管理员部门*/