CREATE TABLE doctor id int11 NOT NULL AUTO_INCREMENT COMMENT 编号 name varchar255 NOT NULL COMMENT 姓名 password varchar255 NOT NULL COMMENT 密码 image varchar255 DEFAULT NULL COMMENT 头像 host_id int11

INSERT INTO doctor (name, password, image, host_id, school, major, phone, wait_nums, department_id, role, status) VALUES ('Doctor 1', 'password1', 'image1.jpg', 1, 'School 1', 'Major 1', '1111111111', 0, 1, 'doc', '1'), ('Doctor 2', 'password2', 'image2.jpg', 1, 'School 2', 'Major 2', '2222222222', 0, 2, 'doc', '1'), ('Doctor 3', 'password3', 'image3.jpg', 2, 'School 3', 'Major 3', '3333333333', 0, 3, 'doc', '1'), ('Doctor 4', 'password4', 'image4.jpg', 2, 'School 4', 'Major 4', '4444444444', 0, 4, 'doc', '1'), ('Doctor 5', 'password5', 'image5.jpg', 3, 'School 5', 'Major 5', '5555555555', 0, 5, 'doc', '1'), ('Nurse 1', 'password6', 'image6.jpg', 1, 'School 6', 'Major 6', '6666666666', 0, 1, 'nus', '1'), ('Nurse 2', 'password7', 'image7.jpg', 1, 'School 7', 'Major 7', '7777777777', 0, 2, 'nus', '1'), ('Nurse 3', 'password8', 'image8.jpg', 2, 'School 8', 'Major 8', '8888888888', 0, 3, 'nus', '1'), ('Nurse 4', 'password9', 'image9.jpg', 2, 'School 9', 'Major 9', '9999999999', 0, 4, 'nus', '1'), ('Nurse 5', 'password10', 'image10.jpg', 3, 'School 10', 'Major 10', '1010101010', 0, 5, 'nus', '1')