数据库表格设计及语句.docx

表名英文名CClassification字段名汉字描述类型(长度)空/非空默认值主键外键备注Id标识UniqueIdentifierCode编码VARCHAR2(20)CName名称VARCHAR2(20)PK：IdFK：;Create table CClassification(Id) UniqueIdentifier,Code VARCHAR2(20),CName VARCHAR2(20)表名英文名Catering 字段名汉字描述类型(长度)非空默认值主键外键备注Id标识UniqueIdentifierYCode编码VARCHAR2(20)YYCName名称VARCHAR2(50)YLocation企业位置VARCHAR2(20)YTheme主题VARCHAR2(100)Representative负责人VARCHAR2(50)Phone电话号码VARCHAR2(15)PostCode邮编VARCHAR2(10)CClassificationId供应商类别VARCHAR2(16)PK：IdFK：CClassificationId;Create table Catering(Id UniqueIdentifierCode char (20),CName char(50),Location char(20),Theme char(20),Representative char(20),Phone VARCHAR2(10)PostCode(10),CClassificationId,foreign key （CClassificationId ）references CClassification（Id），)表名英文名Customer字段名汉字描述类型(长度)空/非空默认值主键外键备注Id标识UniqueIdentifierCode编码VARCHAR2(20)YCName姓名VARCHAR2(20)Phone电话VARCHAR2(15)Sex性别tinyintEmail电子邮箱VARCHAR2(20)PK：IdFK：;Create table Customer（Id char(20 ) UniqueIdentifier Code char (20),CName char(50),Phone VARCHAR2(15),Sex tinyint,Email VARCHAR2(20),）表名英文名FClassification字段名汉字描述类型(长度)空/非空默认值主键外键备注Id标识UniqueIdentifierCode编码VARCHAR2(20)CName名称VARCHAR2(20)PK：IdFK：;Create table FClassification(Id char(20) UniqueIdentifier,Code VARCHAR2(20),CName VARCHAR2(20)表名英文名Food字段名汉字描述类型(长度)空/非空默认值主键外键备注Id标识UniqueIdentifierNCode编码VARCHAR2(20)NYFName食品名称VARCHAR2(20)NPrice食品价格FloatFClassificationId食品类别VARCHAR2(20)PK：IdFK：FClassification;Create table Food(Id char(20 ) UniqueIdentifierCode char (20),FName char(50),Price Float,foreign key FClassificationId (16) references FClassification（Id），)表名英文名Supply字段名汉字描述类型(长度)空/非空默认值主键外键备注Id标识UniqueIdentifierNCode编码VARCHAR2(20)NYFoodId食品IdVARCHAR2(20)NCateringId供应商IdVARCHAR2(20)PK：IdFK：FoodCodeCateringCodeCreate table Supply(Id char(20 ) UniqueIdentifierCode char (20),foreign key FoodId (20) references Food（Id），foreign key CateringId (20) references Catering（Id）,)表名英文名Complaint字段名汉字描述类型(长度)空/非空默认值主键外键备注Id标识UniqueIdentifierNComplaintCode编码VARCHAR2(20)NYCustomerId客户IdVARCHAR2(20)N梯形结构，索引CateringId企业IdVARCHAR2(20)Contentrs投诉内容VARCHAR2(200)Feedback投诉反馈VARCHAR2(200)PK：IdFK：CateringId CustomerIdCreate table Complaint(Id char(20) UniqueIdentifierCode char (20),Contentrs VARCHAR2(200),Feedback VARCHAR2(200),foreign key CustomerId (20) references Customer（Id），foreign key CateringId (20) references Catering（Id）,)表名英文名Reservation字段名汉字描述类型(长度)空/非空默认值主键外键备注Id标识UniqueIdentifierNReservationCode编码VARCHAR2(20)NYCustomerId客户IdVARCHAR2(20)N梯形结构，索引CateringId供应商IdVARCHAR2(20)FoodId食品IdVARCHAR2(20)ReTime预定时间timeUseTime消费时间timePK：IdFK：FoodIdCateringId CustomerIdCreate table Reservation(Id char(20) UniqueIdentifierCode char (20),foreign key CustomerId (20) references Customer（Id），foreign key CateringId (20) references Catering（Id）,foreign key FoodId (20) references Food（Id）,ReTime time,UseTime time,)表名英文名Evaluation字段名汉字描述类型(长度)空/非空默认值主键外键备注Id标识UniqueIdentifierNCustomerId客户IdVARCHAR2(20)CateringId供应商IdVARCHAR2(20)Contentrs评价内容VARCHAR2(200)Feedback评价反馈VARCHAR2(200)PK：IdFK：CateringIdCustomerId;Create table Evaluation(Id char(20) UniqueIdentifierCode char (20),Contentrs VARCHAR2(200),Feedback VARCHAR2(200),foreign key CustomerId (20) references Customer（Id），foreign key CateringId (20) references Catering（Id）,)表名英文名Recommend字段名汉字描述类型(长度)空/非空默认值主键外键备注Id标识UniqueIdentifierNCode编码VARCHAR2(20)FoodId食品IdVARCHAR2(20)CateringId供应商IdVARCHAR2(20)CustomerId客户IdVARCHAR2(20)PK：IdFK：CustomerIdCateringIdFoodIdCreate table Recommend(Id char(20)