mysql练习sql命令

CREATE SCHEMA medical_system DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
CREATE TABLE medical_system.t_user (
id INT NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
account VARCHAR(32) NULL COMMENT ‘帐号’,
password VARCHAR(32) NULL COMMENT ‘密码’,
name VARCHAR(50) NULL COMMENT ‘姓名’,
sex TINYINT(4) NULL COMMENT ‘性别（1男0女）’,
user_type TINYINT(4) NULL COMMENT ‘用户类别(0管理员1医生2病人)’,
relation INT(11) NULL,
PRIMARY KEY (id))
COMMENT = ‘用户表’;

CREATE TABLE medical_system.t_doctor (
id INT NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
name VARCHAR(45) NULL,
sex TINYINT(4) NULL COMMENT ‘性别（1男0女）’,
department TINYINT(4) NULL COMMENT ‘科室’,
introduction VARCHAR(1000) NULL COMMENT ‘介绍’,
PRIMARY KEY (id))
COMMENT = ‘医生表’;
CREATE TABLE medical_system.t_patient (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(45) NULL,
sex TINYINT(4) NULL,
birthday DATETIME NULL,
id_num VARCHAR(20) NULL,
phone VARCHAR(11) NULL,
PRIMARY KEY (id))
COMMENT = ‘病人表’;
CREATE TABLE medical_system.t_relation_patient (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(45) NULL,
sex TINYINT(4) NULL,
birthday DATETIME NULL,
id_num VARCHAR(20) NULL,
patient_id INT NULL,
phone VARCHAR(11) NULL,
PRIMARY KEY (id))
COMMENT = ‘病人家属表’;
CREATE TABLE medical_system.t_appointment (
id INT NOT NULL AUTO_INCREMENT,
patient_id INT NULL,
is_self TINYINT NULL,
real_patient_id INT NULL,
real_patient_name VARCHAR(45) NULL,
date DATETIME NULL,
department TINYINT NULL,
doctor_id INT NULL,
doctor_name VARCHAR(45) NULL,
status TINYINT NULL,
time_enum INT NULL,
PRIMARY KEY (id))
COMMENT = ‘预约表’;
CREATE TABLE medical_system.t_case (
id INT NOT NULL AUTO_INCREMENT,
patient_id INT NULL,
is_self TINYINT NULL,
real_patient_id INT NULL,
real_patient_name VARCHAR(45) NULL,
department TINYINT NULL,
doctor_id INT NULL,
doctor_name VARCHAR(45) NULL,
date DATETIME NULL,
PRIMARY KEY (id))
COMMENT = ‘就诊表’;