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.
18 lines
1.5 KiB
SQL
18 lines
1.5 KiB
SQL
create table hospital_question_logs
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
user bigint not null,
|
|
type tinyint default 1 null,
|
|
content longtext not null,
|
|
created_at timestamp null,
|
|
updated_at timestamp null
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
create index hospital_question_logs_user_index
|
|
on hospital_question_logs (user);
|
|
|
|
INSERT INTO lkpe.hospital_question_logs (id, user, type, content, created_at, updated_at) VALUES (1, 1, 1, '[{"question":"请输入您的姓名","answer":"陆予三三","more":""},{"question":"请选择您的性别","answer":["男"],"more":["",""]},{"question":"测试多选","answer":["A. YOOOOO","C. LAAAAA"],"more":["","","AAAAAA",""]},{"question":"测试图片","answer":"/storage/assets/upload/image/2023/06/995cc039-b723-4e37-8dd0-731b30495665.jpeg","more":""}]', '2023-06-08 23:00:11', '2023-06-08 23:00:11');
|
|
INSERT INTO lkpe.hospital_question_logs (id, user, type, content, created_at, updated_at) VALUES (2, 1, 1, '[{"question":"请输入您的姓名","answer":"陆予三三","more":""},{"question":"请选择您的性别","answer":["女"],"more":["","AAAAAAAA"]},{"question":"测试多选","answer":["A. YOOOOO","C. LAAAAA","D. SAAAAAA"],"more":["","","ASDASD","SDFDSFDSF"]},{"question":"测试图片","answer":"/storage/assets/upload/image/2023/06/995cc343-a5ce-4b12-92d5-b4e8c8ccf2ec.jpeg","more":""}]', '2023-06-08 23:08:41', '2023-06-08 23:08:41');
|