数据库之建表--“天然气传送”

/*
* 小组成员须知：
* mysql版本：mysql-5.7.17-winx64
*/
CREATE DATABASE gas DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
use gas;  
create table customer(  
	C_id int primary key AUTO_INCREMENT,  
	C_name varchar(20) NOT NULL,
	C_phone int(11) NOT NULL,
	C_adress varchar(50) NOT NULL,
	C_remarks varchar(50) COMMENT '备注'
)COMMENT='客户';
create table orderform(  
	O_id int primary key AUTO_INCREMENT,  
	O_adress varchar(50) NOT NULL,
	O_customer varchar(20) NOT NULL,
	O_time datetime NOT NULL,
	O_state1 char(4) NOT NULL COMMENT '派送员状态',
	O_state2 char(4) NOT NULL COMMENT '客户状态'
)COMMENT='订单';
create table orderdetails(  
	OTC_id int COMMENT '外键订单id', 
	OTO_id int COMMENT '客户订单id',	
	OT_name varchar(20) NOT NULL,
	OT_number int NOT NULL,
	OT_price decimal(10,2) NOT NULL,
	primary key(OTC_id,OTO_id),
	foreign key(OTC_id) references customer(C_id),
	foreign key(OTO_id) references orderform(O_id)
)COMMENT='订单明细';
create table product(  
	P_id int primary key AUTO_INCREMENT,  
	P_name varchar(20) NOT NULL,
	P_money decimal(10,2) NOT NULL,
	P_spec varchar(20) NOT NULL COMMENT '库存',
	P_stock int
)COMMENT='产品';
create table staff(  
	S_id int primary key AUTO_INCREMENT,  
	S_name varchar(20) NOT NULL,
	S_phone int(11) NOT NULL,
	S_level varchar(20) NOT NULL COMMENT '职员等级',
	S_time datetime NOT NULL COMMENT '入职时间',
	S_remarks varchar(50) COMMENT '备注'
)COMMENT='职员表';
create table signin(  
	SI_id int primary key AUTO_INCREMENT,
	SIS_id int COMMENT '外键职员id',
	SI_timein datetime NOT NULL COMMENT '签到',
	SI_timeout datetime NOT NULL COMMENT '签退',
	foreign key(SIS_id) references staff(S_id)
)COMMENT='签到表';
create table courier(  
	CR_id int primary key AUTO_INCREMENT,  
	CR_name varchar(20) NOT NULL,
	CR_phone int(11) NOT NULL,
	CR_STATE varchar(4) COMMENT '派送员状态'
)COMMENT='派送员';