/*5.权限类型表*/
create table type(
	tp_id varchar(40) primary key,
	tp_name varchar(100) not null
);
/*1.权限*/
create table privilege(
	pid varchar(40) primary key,
	pname varchar(50) not null unique,
	pdescription varchar(100),
	type_name varchar(40) not null,
	resourcename varchar(100) not null unique,
	foreign key(type_name) references type(tp_name)
);
/*2.角色*/
create table role(
	roleid varchar(40) primary key,
	rolename varchar(50) not null unique
);
/*3.权限-角色（多对多）*/
create table privilege_role(
	pid varchar(40) not null,
	roleid varchar(40) not null,
	foreign key(pid) references privilege(pid),
	foreign key(roleid) references role(roleid)
);
/*4.角色-用户（多对多）*/
create table role_outpatient_docter(
	roleid varchar(40) not null,
	outpatient_docter_id varchar(40) not null,
	foreign key(roleid) references role(roleid),
	foreign key(outpatient_docter_id) references outpatient_docter(doctor_id)
);

++++++++用户角色++++


++++++++医生时间安排表++++++++
CREATE TABLE schedule(
  id INT AUTO_INCREMENT NOT NULL PRIMARY KEY ,
  doctor_id VARCHAR(40) NOT NULL ,
  time INT NOT NULL ,
  week INT NOT NULL ,
  sum INT NOT NULL ,
  left_sum INT NOT NULL

);
++++++++挂号表+++++
create TABLE appointment (
    id INT not null,
    patient_id VARCHAR(40) not null default '',
    doctor_id VARCHAR(40) not null default '',
    appoint_time DATE not null default '',
    "time" INT not null,
    week INT not null,
    priority INT not null,
    status INT default 0,
    create_time TIMESTAMP not null default CURRENT_TIMESTAMP,
    PRIMARY KEY (id)
);

/***  药  ****/
CREATE TABLE drug
(
  id int AUTO_INCREMENT PRIMARY KEY ,
  drug_name VARCHAR(40) DEFAULT '' NOT NULL,
  drug_price REAL NOT NULL,
  drug_type VARCHAR(40),
  drug_comment LONGTEXT,
  product_time DATETIME
);