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.
22 lines
1.5 KiB
SQL
22 lines
1.5 KiB
SQL
create table hospitals
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
name varchar(50) not null,
|
|
code varchar(50) not null,
|
|
address varchar(100) not null,
|
|
longitude decimal(10, 6) not null,
|
|
latitude decimal(10, 6) not null,
|
|
logo varchar(100) not null,
|
|
dev tinyint not null comment '1:测试机构, 2:正式机构',
|
|
phone varchar(20) not null,
|
|
status tinyint not null,
|
|
del tinyint default 2 not null,
|
|
created_at timestamp null,
|
|
updated_at timestamp null
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
INSERT INTO lkpe.hospitals (id, name, code, address, longitude, latitude, logo, dev, phone, status, del, created_at, updated_at) VALUES (1, '测试医院机构', '130302999999', '测试医院机构测试医院机构测试医院机构测试医院机构', 119.514637, 39.903517, '/storage/assets/upload/image/2023/06/995ed894-39aa-4c62-a8a3-8183d7424ec9.png', 1, '03358888887', 1, 2, '2023-04-07 23:11:35', '2023-06-10 00:03:30');
|
|
INSERT INTO lkpe.hospitals (id, name, code, address, longitude, latitude, logo, dev, phone, status, del, created_at, updated_at) VALUES (2, '普通医院机构', '130302999999', '普通医院机构234', 119.600492, 39.935385, '/storage/assets/upload/image/2023/04/98e615fb-a73f-49cb-9aa2-95751bd82df4.jpeg', 2, '03357777777', 1, 2, '2023-04-07 23:18:13', '2023-04-10 23:16:28');
|