光彩斗查看:6 回复:3 评论:6 创建时间:2022-03-27T15:51:06用户:光彩斗查看:6 回复:3 评论:6 创建时间:2022-03-27T15:51:06
啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊
光彩斗
mysql -u root -p
create database vaccine_info;
create table user_info(
id varchar(20) primary key,
password varchar(20),
role varchar(1));
insert into user_info (id, password, role) values ('admin1', '123456','A');
create table commonuser_info(
id varchar(20) primary key,
name varchar(20),
family_code varchar(8),
age int(3),
sex varchar(1),
phone varchar(20),
IDCard varchar(30),
is_book varchar(1),
book_time varchar(11),
is_bad_reaction varchar(1),
what_bad_reaction varchar(60));
create table vaccines_info(
type varchar(10),
company varchar(20),
user_type varchar(20),
user_age varchar(20),
price varchar(7));
create table hospital_info(
id varchar(20) primary key,
name varchar(20),
num varchar(10),
is_book varchar(1),
time varchar(20));
create table inoculate_info(
id varchar(20) primary key,
vaccine_type varchar(200),
time varchar(200));点赞0
评论