You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
25 lines
1.8 KiB
SQL
25 lines
1.8 KiB
SQL
create table hospital_questions
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
hospital bigint not null,
|
|
question varchar(200) not null,
|
|
type tinyint not null comment '1-填空 2-单选 3-多选 4-图片',
|
|
content text not null,
|
|
mark varchar(20) not null,
|
|
`order` int default 1 null,
|
|
status tinyint not null,
|
|
del tinyint default 2 not null,
|
|
created_at timestamp null,
|
|
updated_at timestamp null
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
create index hospital_questions_type_index
|
|
on hospital_questions (type);
|
|
|
|
INSERT INTO lkpe.hospital_questions (id, hospital, question, type, content, mark, `order`, status, del, created_at, updated_at) VALUES (1, 0, '请输入您的姓名', 1, '{"placeholder":"请输入"}', 'NAME', 1, 1, 2, '2023-06-08 18:44:10', '2023-06-08 18:44:34');
|
|
INSERT INTO lkpe.hospital_questions (id, hospital, question, type, content, mark, `order`, status, del, created_at, updated_at) VALUES (2, 0, '请选择您的性别', 2, '{"item":["男","女{{MORE}}为什么选这个选项"]}', 'SEX', 2, 1, 2, '2023-06-08 19:09:08', '2023-06-08 21:32:39');
|
|
INSERT INTO lkpe.hospital_questions (id, hospital, question, type, content, mark, `order`, status, del, created_at, updated_at) VALUES (3, 0, '测试多选', 3, '{"item":["A. YOOOOO","B. HAAAAA","C. LAAAAA{{MORE}}为什么选这个选项","D. SAAAAAA{{MORE}}为什么选这个选项"]}', '', 3, 1, 2, '2023-06-08 19:16:53', '2023-06-08 21:32:33');
|
|
INSERT INTO lkpe.hospital_questions (id, hospital, question, type, content, mark, `order`, status, del, created_at, updated_at) VALUES (4, 0, '测试图片', 4, '{"placeholder":"请上传图片"}', '', 4, 1, 2, '2023-06-08 19:17:56', '2023-06-08 19:17:56');
|