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.
19 lines
931 B
SQL
19 lines
931 B
SQL
create table hospital_activity_packages
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
hospital bigint not null,
|
|
name varchar(20) not null,
|
|
content text not null,
|
|
status tinyint not null comment '1:工作日, 2:节假日',
|
|
created_at timestamp null,
|
|
updated_at timestamp null
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
create index hospital_activity_packages_hospital_index
|
|
on hospital_activity_packages (hospital);
|
|
|
|
INSERT INTO lkpe.hospital_activity_packages (id, hospital, name, content, status, created_at, updated_at) VALUES (1, 1, '测试活动', '["1875","2355","2354","2353","2352"]', 1, '2023-05-24 20:49:57', '2023-05-24 20:49:57');
|
|
INSERT INTO lkpe.hospital_activity_packages (id, hospital, name, content, status, created_at, updated_at) VALUES (2, 1, '测试123', '["2348","2349","2350"]', 1, '2023-05-24 20:51:01', '2023-05-24 20:51:01');
|