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
1.2 KiB
SQL
19 lines
1.2 KiB
SQL
create table hospital_additionals
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
hospital bigint not null,
|
|
combo_order text not null,
|
|
combo_count text not null,
|
|
created_at timestamp null,
|
|
updated_at timestamp null
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
create index hospital_additionals_hospital_index
|
|
on hospital_additionals (hospital);
|
|
|
|
INSERT INTO lkpe.hospital_additionals (id, hospital, combo_order, combo_count, created_at, updated_at) VALUES (1, 2, '["1943","1944","1945","3344"]', '[{"id":"1944","count":111},{"id":"1943","count":0},{"id":"3333","count":234}]', '2023-04-11 16:24:20', '2023-04-11 17:10:10');
|
|
INSERT INTO lkpe.hospital_additionals (id, hospital, combo_order, combo_count, created_at, updated_at) VALUES (2, 0, '["112233"]', '[{"id":"11111","count":4}]', '2023-04-11 16:54:50', '2023-05-24 09:38:49');
|
|
INSERT INTO lkpe.hospital_additionals (id, hospital, combo_order, combo_count, created_at, updated_at) VALUES (3, 1, '["1959","1958"]', '[{"id":"2348","count":110},{"id":"2349","count":104},{"id":"2350","count":103},{"id":"2352","count":102},{"id":"2353","count":101}]', '2023-04-11 17:16:04', '2023-06-10 00:40:47');
|