|
|
create table admin_accounts
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
admin_id bigint not null,
|
|
|
account varchar(50) not null,
|
|
|
secret varchar(80) not null,
|
|
|
type tinyint not null comment '1-账号密码',
|
|
|
del tinyint default 2 not null comment '1-删除 2-正常',
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create index admin_accounts_account_index
|
|
|
on admin_accounts (account);
|
|
|
|
|
|
create index admin_accounts_admin_id_index
|
|
|
on admin_accounts (admin_id);
|
|
|
|
|
|
INSERT INTO lkpe.admin_accounts (id, admin_id, account, secret, type, del, created_at, updated_at) VALUES (1, 1, 'admin', '$2y$10$RrkVbwgR7plyKBJA.82onul9Sv9iyLKqmJDN7bRmFY4b6.45C5Qsi', 1, 2, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
|
INSERT INTO lkpe.admin_accounts (id, admin_id, account, secret, type, del, created_at, updated_at) VALUES (2, 2, 'TEST_ADMIN_01', '$2y$10$KOdF2w9ebVB2QaKVjBaTcO53kbslyoGYysOvmHNHq.30ezd1t8z6q', 1, 2, '2023-06-09 15:31:02', '2023-06-09 15:31:02');
|
|
|
|
|
|
create table admin_auths
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
name varchar(20) not null comment '名称',
|
|
|
auth_ids varchar(1000) not null comment '权限IDS JSON',
|
|
|
remark varchar(100) not null comment '备注',
|
|
|
del tinyint default 2 not null comment '1-删除 2-正常',
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
INSERT INTO lkpe.admin_auths (id, name, auth_ids, remark, del, created_at, updated_at) VALUES (1, '医院最高权限', '["22","23","24","25","26","27","28"]', '', 2, '2023-06-09 15:56:40', '2023-06-09 22:13:43');
|
|
|
|
|
|
create table admin_tokens
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
admin_id bigint not null comment '账号ID',
|
|
|
token varchar(50) not null comment 'TOKEN',
|
|
|
type tinyint not null comment '1-后台',
|
|
|
del tinyint default 2 not null comment '1-删除 2-正常',
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create index admin_tokens_admin_id_index
|
|
|
on admin_tokens (admin_id);
|
|
|
|
|
|
create index admin_tokens_token_index
|
|
|
on admin_tokens (token);
|
|
|
create table admins
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
nickname varchar(30) not null comment '名称',
|
|
|
admin_auth_id int not null comment '权限ID',
|
|
|
status tinyint default 1 not null comment '1-正常 2-禁用',
|
|
|
del tinyint default 2 not null comment '1-删除 2-正常',
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null,
|
|
|
hospital bigint not null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create index admins_hospital_index
|
|
|
on admins (hospital);
|
|
|
|
|
|
INSERT INTO lkpe.admins (id, nickname, admin_auth_id, status, del, created_at, updated_at, hospital) VALUES (1, '超级管理员', -1, 1, 2, '2023-04-06 23:01:36', '2023-04-06 23:01:36', 0);
|
|
|
INSERT INTO lkpe.admins (id, nickname, admin_auth_id, status, del, created_at, updated_at, hospital) VALUES (2, '测试医院管理员', 1, 1, 2, '2023-06-09 15:31:02', '2023-06-09 22:15:44', 1);
|
|
|
|
|
|
create table analysis_types
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
hospital bigint not null,
|
|
|
name varchar(50) not null,
|
|
|
`range` varchar(200) default '["min","max"]' not null,
|
|
|
`desc` varchar(50) not null,
|
|
|
color varchar(8) not null,
|
|
|
mark varchar(50) not null,
|
|
|
content varchar(2000) not null,
|
|
|
type tinyint not null comment '1-临床生化 2-临床免疫 3-常规',
|
|
|
status tinyint default 1 not null,
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create index analysis_types_hospital_index
|
|
|
on analysis_types (hospital);
|
|
|
|
|
|
INSERT INTO lkpe.analysis_types (id, hospital, name, `range`, `desc`, color, mark, content, type, status, created_at, updated_at) VALUES (1, 0, '空腹血糖分析', '{"s":"1","r":["0","min","max","10"],"l":["偏低","正常","偏高"]}', '空腹血糖变化趋势分析', '#78A155', 'KFPTT', '空腹血糖分析
|
|
|
临床上所称的血糖专指血液中的葡萄糖而言。每个个体全天血糖含量随进食、活动等情况会有波动。一般在空腹时的血糖水平为恒定。临床检测时采用葡萄糖氧化酶的方法，可以特异的测出真实的血糖浓度。血糖浓度受神经系统和激素的调节而保持相对稳定。当这些调节失去原有的相对平衡时，则出现高血糖或低血糖。因此，对空腹血糖值进行测定能够反映机体的血糖代谢情况。', 1, 1, '2023-03-20 14:42:43', '2023-06-03 00:45:11');
|
|
|
INSERT INTO lkpe.analysis_types (id, hospital, name, `range`, `desc`, color, mark, content, type, status, created_at, updated_at) VALUES (2, 0, '甘油三酯分析', '{"s":"0.2","r":["min","max","2"],"l":["正常","偏高"]}', '甘油三酯变化趋势分析', '#58D818', 'GYSZ', '甘油三酯分析
|
|
|
1.增高：甘油三酯为心血管疾病的危险因素。血清甘油三酯水平受年龄、性别和饮食的影响。血清甘油三酯增高可见于家族性高甘油三酯血症，饮食大量甘油三酯和继发于某些疾病如糖尿病、甲状腺功能减退、肾病综合征和胰腺炎、动脉粥样硬化、糖原贮积病等。
|
|
|
2.降低：见于甲状腺功能亢进症、肾上腺皮质功能降低、肝功能严重低下、慢性阻塞性肺疾患、脑梗塞、营养不良、先天性α-β脂蛋白血症等。', 1, 1, '2023-03-20 14:42:43', '2023-03-29 11:30:21');
|
|
|
INSERT INTO lkpe.analysis_types (id, hospital, name, `range`, `desc`, color, mark, content, type, status, created_at, updated_at) VALUES (3, 0, '总胆固醇分析', '{"s":"1","r":["min","max","10"],"l":["正常","偏高"]}', '总胆固醇变化趋势分析', '#CA6D6A', 'ZDGC', '总胆固醇分析
|
|
|
1，病理性升高。高脂蛋白血症、动脉粥样硬化、糖尿病、甲状腺功能低下、阻塞性黄疸、肾病综合征。
|
|
|
2，病理性降低。甲亢、严重贫血、急性感染、消耗性疾病、肝病。', 1, 1, '2023-03-20 14:42:43', '2023-03-29 12:25:33');
|
|
|
INSERT INTO lkpe.analysis_types (id, hospital, name, `range`, `desc`, color, mark, content, type, status, created_at, updated_at) VALUES (4, 0, '高密度总胆固醇', '{"s":"0.2","r":["0","min","max","2"],"l":["偏低","正常","偏高"]}', '高密度总胆固醇变化趋势分析', '#C45E16', 'GMDZDBDGC', '高密度总胆固醇
|
|
|
高密度脂蛋白胆固醇增高最主要的临床价值是能够将动脉粥样硬化斑块的泡沫细胞转移至肝脏排出体外，可见于原发性高HDL血症，并发现此群家族中长寿者多。接受雌激素、胰岛素或某些药物（如烟酸、维生素E、肝素等）治疗者，亦可增高。
|
|
|
高密度脂蛋白胆固醇降低常见于脑血管病冠心病、高甘油三酯血症、肝功能损害如急慢性肝炎、肝硬化、肝癌、糖尿病、吸烟、缺少运动等，其减低可作为冠心病的危险指标。
|
|
|
含量升高
|
|
|
生理性升高：运动（如运动员一般HDL-C较高）、饮酒、妇女服用避孕药、一些降胆固醇药物（如诺衡）等。
|
|
|
病理性升高：慢性肝病、慢性中毒性疾病、遗传性高HDL血症。
|
|
|
含量降低
|
|
|
生理性降低：少运动的人，应激反应后。
|
|
|
病理性降低冠心病、高甘油三酯血症患者、肝硬化、糖尿病、慢性肾功能不全、营养不良。', 1, 1, '2023-03-20 14:42:43', '2023-03-27 15:33:45');
|
|
|
INSERT INTO lkpe.analysis_types (id, hospital, name, `range`, `desc`, color, mark, content, type, status, created_at, updated_at) VALUES (5, 0, '低密度总胆固醇', '{"s":"0.5","r":["min","max","5"],"l":["正常","偏高"]}', '低密度总胆固醇变化趋势分析', '#DFC039', 'DMDZDBDGC', '低密度总胆固醇
|
|
|
低密度脂蛋白是由中间密度脂蛋白在肝脏内转化而来的，肝脏也可直接合成、分泌少量低密度胆固醇。它的主要功能是将胆固醇转运到肝外组织细胞，满足它们对胆固醇的需要。低密度脂蛋白是所有血清脂蛋白中首要的致动脉粥样化性脂蛋白。', 1, 1, '2023-03-20 14:42:43', '2023-03-29 12:28:09');
|
|
|
INSERT INTO lkpe.analysis_types (id, hospital, name, `range`, `desc`, color, mark, content, type, status, created_at, updated_at) VALUES (6, 0, 'Y-谷氨酰基转肽酶（GGT）', '{"s":"10","r":["0","min","max","80"],"l":["偏低","正常","偏高"]}', 'Y-谷氨酰基转肽酶（GGT）趋势分析', '#D38014', 'QDYE4000HzZ', 'Y-谷氨酰基转肽酶（GGT）
|
|
|
1.γ-谷氨酰转肽酶分布于肾、肝、胰腺等实质性脏器，肝脏中γ-GT主要局限于毛细胆管和肝细胞的微粒体中，可用于对占位性肝病、肝实质损伤（慢性肝炎和肝硬化）的诊断。
|
|
|
2.轻度和中度增高者主要见于病毒性肝炎、肝硬化、胰腺炎等。
|
|
|
3.酒精中毒者γ-GT也明显升高，也可用于诊断酒精性肝病。
|
|
|
4.明显增高者见于原发或继发性肝癌、肝阻塞性黄疸、胆汁性肝硬化、胆管炎、胰头癌、肝外胆道癌等。在判断恶性肿瘤患者有无肝转移和肝癌术后有无复发的依据中有重要的诊断意义。
|
|
|
5.在急性肝炎时，γ-GT下降至正常较氨基转移酶为迟，如γ-GT持续偏高，提示转位慢性肝病；慢性肝病尤其是肝硬化时，γ-GT持续偏低，提示预后不良。
|
|
|
6.γ-谷氨酰转肽酶作为肝癌标志物的特异性低，急性肝炎、慢性肝炎活动期及阻塞性黄疸、胆道感染、胆石症、急性胰腺炎时都可以增高。', 1, 1, '2023-03-20 14:42:43', '2023-03-29 12:33:52');
|
|
|
INSERT INTO lkpe.analysis_types (id, hospital, name, `range`, `desc`, color, mark, content, type, status, created_at, updated_at) VALUES (7, 0, '丙氨酸氨基转移酶', '{"s":"10","r":["0","min","max","80"],"l":["偏低","正常","偏高"]}', '丙氨酸氨基转移酶趋势分析', '#C25202', 'BASAJZYM', '丙氨酸氨基转移酶
|
|
|
增高：见于肝脏疾病（传染性肝炎、肝癌、肝硬化活动期、中毒性肝炎、药物中毒性肝炎、脂肪肝、阻塞性黄疸）、胆道疾病（胆管炎、胆囊炎）、心血管疾病（心肌梗死。心力衰竭时的肝脏淤血）、内分泌疾病、胰腺疾患、重症糖尿病、甲状腺功能亢进、传染性单核细胞增多症、疟疾、流行性感冒、外伤、严重烧伤、休克、药物中毒，以及早期妊娠和剧烈运动。', 1, 1, '2023-03-20 14:42:43', '2023-03-29 12:32:40');
|
|
|
INSERT INTO lkpe.analysis_types (id, hospital, name, `range`, `desc`, color, mark, content, type, status, created_at, updated_at) VALUES (8, 0, '天门冬氨酸氨基转移酶', '{"s":"10","r":["0","min","max","80"],"l":["偏低","正常","偏高"]}', '天门冬氨酸氨基转移酶变化趋势分析', '#01739A', 'TMDASAJZYM', '天门冬氨酸氨基转移酶
|
|
|
异常结果： 增高：见于心肌梗死、肝脏疾患(肝癌、肝硬化、慢性肝炎、药物中毒性肝炎、肝细胞坏死)、胆道疾患、内分泌疾病、急性胰腺炎、肺梗死、溶血性疾病、药物中毒、白血病。 减低：见于中枢神经系统疾病等。临床一般常作为心肌梗塞和心肌炎的辅助检查。 当谷丙转氨酶(ALT)明显升高，谷草(AST)/谷丙(ALT)比值>1时，就提示有肝实质的损害。这是引起谷酸丙氨酸转氨酶，简称谷丙转氨酶增高最常见的原因。各型急、慢性病毒性肝炎患者，谷草转氨酶均可增高，但升高幅度与肝脏损伤程度不成正比，绝不能以谷草转氨酶数值的高低来判断病情的轻重。中毒性肝炎 多种药物和化学制剂，如红霉素、异烟肼、保泰松等都可引起门冬氨酸氨基转移酶升高，停药以后，谷草转氨酶很快恢复正常。 需要检查人群：心肺功能障碍患者。', 1, 1, '2023-03-20 14:42:43', '2023-03-29 12:34:48');
|
|
|
INSERT INTO lkpe.analysis_types (id, hospital, name, `range`, `desc`, color, mark, content, type, status, created_at, updated_at) VALUES (9, 0, '尿酸', '{"s":"50","r":["0","min","max","500"],"l":["偏低","正常","偏高"]}', '尿酸趋势分析', '#DFC039', 'NS', '尿酸
|
|
|
血尿酸增高
|
|
|
1）血尿酸增高主要见于痛风，但少数痛风患者在痛风发作时血尿酸测定正常。血尿酸增高无痛风发作者为高尿酸血症。
|
|
|
2）在细胞增殖周期快、核酸分解代谢增加时，如白血病及其他恶性肿瘤、多发性骨髓瘤、真性红细胞增多症等血清尿酸值常见增高。肿瘤化疗后血尿酸升高更明显。
|
|
|
3）在肾功能减退时，常伴有血清尿酸增高。可见于肾脏疾病如急慢性肾炎，其他肾脏疾病的晚期如肾结核，肾盂肾炎，肾盂积水等。
|
|
|
4）在氯仿中毒、四氯化碳中毒及铅中毒、子痈、妊娠反应及食用富含核酸的食物等，均可引起血中尿酸含量增高。
|
|
|
血尿酸降低
|
|
|
恶性贫血，范科尼综合征血尿酸降低。', 1, 1, '2023-03-20 14:42:43', '2023-03-29 12:36:19');
|
|
|
INSERT INTO lkpe.analysis_types (id, hospital, name, `range`, `desc`, color, mark, content, type, status, created_at, updated_at) VALUES (10, 0, '甲胎蛋白', '{"s":"0.2","r":["0","min","max","8"],"l":["偏低","正常","偏高"]}', '甲胎蛋白变化趋势分析', '#A3433F', 'KFPTT', '甲胎蛋白
|
|
|
1.儿童期血清AFP含量检测：肝癌，肝母细胞瘤，性腺畸胎母细胞瘤，肝炎等AFP含量增高。
|
|
|
2.成人血清AFP含量检测：60%～70%原发性肝癌患者AFP含量增高，睾丸癌，卵巢肿瘤，恶性畸胎瘤，胰腺癌，胃癌，肠癌，肺癌等患者AFP含量也增高。
|
|
|
3.急慢性肝炎、肝硬化等良性肝病患者血清AFP水平有不同程度升高，但大多低于1000ug/L，其升高与肝细胞坏死和再生程度有关。
|
|
|
4.一般良性肝病AFP含量增多是一过性的，一般持续2-3周。而恶性肿瘤则持续性升高。因此，动态观察血清AFP含量既可鉴别良性和恶性肝病，又可早期诊断肝癌。
|
|
|
5.生理情况下，甲胎蛋白由新生的幼稚肝细胞分泌，胎儿的肝细胞没有发育（分化）完全，分泌的甲胎蛋白量很大，可通过脐带血进入母体血液中，所以妊娠期孕妇的甲胎蛋白会呈阳性。', 2, 1, '2023-03-20 14:42:43', '2023-03-29 12:38:55');
|
|
|
INSERT INTO lkpe.analysis_types (id, hospital, name, `range`, `desc`, color, mark, content, type, status, created_at, updated_at) VALUES (11, 0, '体重分析', '{"s":"5","r":["0","min","max","40"],"l":["偏低","正常","偏高"]}', '分析体重BMI指数', '#DC7948', 'TZZS', '体重分析
|
|
|
体重指数简称BMI，这是一个用身高和体重来估算是否肥胖的指标。肥胖可以导致人体代谢异常，增加心、肝、肺等重要脏器的负担，是高血压、冠心病、脑卒中、糖尿病的重要危险因素，还会增加肿瘤的发生几率。', 3, 1, '2023-03-27 11:18:20', '2023-03-29 10:59:52');
|
|
|
INSERT INTO lkpe.analysis_types (id, hospital, name, `range`, `desc`, color, mark, content, type, status, created_at, updated_at) VALUES (12, 0, '舒张压', '{"s":"30","r":["0","min","max","120"],"l":["偏低","正常","偏高"]}', '血压低趋势分析', '#ECC266', 'SZY', '血压
|
|
|
1.血压是指血液在血管内流动时作用于单位面积血管壁的侧压力，它是推动血液在血管内流动的动力。在不同血管内被分别称为动脉血压、毛细血管压和静脉血压，通常所说的血压是指体循环的动脉血压。
|
|
|
2.血压可以判断心脏功能与外周血管阻力。
|
|
|
3.血压也是诊断疾病、观察病情变化与判断治疗效果的一项重要内容。', 3, 1, '2023-03-27 11:19:52', '2023-04-03 14:22:07');
|
|
|
INSERT INTO lkpe.analysis_types (id, hospital, name, `range`, `desc`, color, mark, content, type, status, created_at, updated_at) VALUES (13, 0, '癌胚抗原', '{"s":"2","r":["min","max","10"],"l":["正常","偏高"]}', '癌胚抗原变化趋势分析', '#C7F070', 'APKY', '癌胚抗原
|
|
|
CEA升高常见于大肠癌、胰腺癌、胃癌、乳腺癌、甲状腺髓样癌、肝癌、肺癌、卵巢癌、泌尿系肿瘤等。但吸烟、妊娠期和心血管疾病、糖尿病、肠道憩室炎、直肠息肉、结肠炎、胰腺炎、肝硬化、肝炎、肺部疾病等，15%～53%的患者血清CEA也会升高，所以CEA不是恶性肿瘤的特异性标志，在诊断上只有辅助价值。
|
|
|
此外，癌胚抗原的水平与下列因素有关：①与癌症的早、中、晚期有关，越到晚期癌胚抗原值越升高，但阳性率不是很高。②与肿瘤转移有关，当转移后，癌胚抗原的浓度也升高。③与癌症的组织类型有关，腺癌最敏感，其次是鳞癌和低分化癌，这说明癌胚抗原是一种分化性抗原，分化程度越高阳性率也越高。④与病情好转有关，病情好转时血清癌胚抗原浓度下降，病情恶化时升高。癌胚抗原连续随访检测，可用于恶性肿瘤手术后的疗效观察及预后判断，也可用于对化疗患者的疗效观察。', 2, 1, '2023-03-27 11:22:23', '2023-03-29 12:40:12');
|
|
|
INSERT INTO lkpe.analysis_types (id, hospital, name, `range`, `desc`, color, mark, content, type, status, created_at, updated_at) VALUES (14, 0, '收缩压', '{"s":"30","r":["50","min","max","180"],"l":["偏低","正常","偏高"]}', '收缩压趋势分析', '#DD6565', 'SSY', '血压
|
|
|
1.血压是指血液在血管内流动时作用于单位面积血管壁的侧压力，它是推动血液在血管内流动的动力。在不同血管内被分别称为动脉血压、毛细血管压和静脉血压，通常所说的血压是指体循环的动脉血压。
|
|
|
2.血压可以判断心脏功能与外周血管阻力。
|
|
|
3.血压也是诊断疾病、观察病情变化与判断治疗效果的一项重要内容。', 3, 1, '2023-04-03 14:13:46', '2023-04-03 14:23:27');
|
|
|
|
|
|
|
|
|
create table appointment_holidays
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
year year not null,
|
|
|
date date not null,
|
|
|
type tinyint not null comment '1:工作日, 2:节假日',
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create index appointment_holidays_date_index
|
|
|
on appointment_holidays (date);
|
|
|
|
|
|
create index appointment_holidays_year_index
|
|
|
on appointment_holidays (year);
|
|
|
|
|
|
INSERT INTO lkpe.appointment_holidays (id, year, date, type, created_at, updated_at) VALUES (1, 2023, '2023-04-29', 1, '2023-04-08 22:18:16', '2023-04-08 22:18:16');
|
|
|
INSERT INTO lkpe.appointment_holidays (id, year, date, type, created_at, updated_at) VALUES (2, 2023, '2023-04-30', 1, '2023-04-08 22:18:18', '2023-04-08 22:18:18');
|
|
|
INSERT INTO lkpe.appointment_holidays (id, year, date, type, created_at, updated_at) VALUES (3, 2023, '2023-05-01', 1, '2023-04-08 22:18:25', '2023-04-08 22:18:25');
|
|
|
INSERT INTO lkpe.appointment_holidays (id, year, date, type, created_at, updated_at) VALUES (4, 2023, '2023-05-02', 1, '2023-04-08 22:18:27', '2023-04-08 22:18:27');
|
|
|
INSERT INTO lkpe.appointment_holidays (id, year, date, type, created_at, updated_at) VALUES (5, 2023, '2023-05-03', 1, '2023-04-08 22:18:30', '2023-04-08 22:18:30');
|
|
|
INSERT INTO lkpe.appointment_holidays (id, year, date, type, created_at, updated_at) VALUES (6, 2023, '2023-04-23', 2, '2023-04-08 22:22:06', '2023-04-08 22:22:06');
|
|
|
INSERT INTO lkpe.appointment_holidays (id, year, date, type, created_at, updated_at) VALUES (7, 2023, '2023-05-06', 2, '2023-04-08 22:23:28', '2023-04-08 22:23:28');
|
|
|
INSERT INTO lkpe.appointment_holidays (id, year, date, type, created_at, updated_at) VALUES (8, 2023, '2023-04-05', 1, '2023-04-08 22:23:35', '2023-04-08 22:23:35');
|
|
|
INSERT INTO lkpe.appointment_holidays (id, year, date, type, created_at, updated_at) VALUES (9, 2023, '2023-06-22', 1, '2023-04-08 22:23:55', '2023-04-08 22:23:55');
|
|
|
INSERT INTO lkpe.appointment_holidays (id, year, date, type, created_at, updated_at) VALUES (10, 2023, '2023-06-23', 1, '2023-04-08 22:23:57', '2023-04-08 22:23:57');
|
|
|
INSERT INTO lkpe.appointment_holidays (id, year, date, type, created_at, updated_at) VALUES (11, 2023, '2023-06-24', 1, '2023-04-08 22:24:01', '2023-04-08 22:24:01');
|
|
|
INSERT INTO lkpe.appointment_holidays (id, year, date, type, created_at, updated_at) VALUES (12, 2023, '2023-06-25', 2, '2023-04-08 22:24:02', '2023-04-08 22:24:02');
|
|
|
|
|
|
|
|
|
create table appointment_templates
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
name varchar(50) not null,
|
|
|
weeks varchar(50) not null,
|
|
|
weekday tinyint not null,
|
|
|
holidays tinyint not null,
|
|
|
start_time time not null,
|
|
|
end_time time not null,
|
|
|
stop_time time not null,
|
|
|
max_count bigint not null,
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null,
|
|
|
hospital bigint default 0 not null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create index appointment_templates_hospital_index
|
|
|
on appointment_templates (hospital);
|
|
|
|
|
|
INSERT INTO lkpe.appointment_templates (id, name, weeks, weekday, holidays, start_time, end_time, stop_time, max_count, created_at, updated_at, hospital) VALUES (1, '计划模板', '["1","2","3","4","5"]', 1, 2, '08:00:00', '13:00:00', '07:00:00', 30, '2023-04-08 02:06:07', '2023-04-10 10:52:06', 0);
|
|
|
INSERT INTO lkpe.appointment_templates (id, name, weeks, weekday, holidays, start_time, end_time, stop_time, max_count, created_at, updated_at, hospital) VALUES (2, '下午', '["1","2","3","4","5"]', 1, 2, '14:00:00', '17:00:00', '13:00:00', 20, '2023-04-09 00:59:02', '2023-04-09 00:59:02', 0);
|
|
|
INSERT INTO lkpe.appointment_templates (id, name, weeks, weekday, holidays, start_time, end_time, stop_time, max_count, created_at, updated_at, hospital) VALUES (3, '晚上', '["1","4","2","5","3"]', 1, 2, '18:00:00', '20:00:00', '19:00:00', 30, '2023-04-10 10:51:57', '2023-04-10 10:51:57', 0);
|
|
|
INSERT INTO lkpe.appointment_templates (id, name, weeks, weekday, holidays, start_time, end_time, stop_time, max_count, created_at, updated_at, hospital) VALUES (4, '测试医院机构模板', '["1","2","3","5","4","6","7"]', 1, 2, '05:00:00', '18:00:00', '17:00:00', 30, '2023-06-10 11:03:52', '2023-06-10 11:03:52', 1);
|
|
|
|
|
|
|
|
|
create table appointments
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
date date not null,
|
|
|
week tinyint not null,
|
|
|
start_time time not null,
|
|
|
end_time time not null,
|
|
|
stop_time time not null,
|
|
|
max_count bigint not null,
|
|
|
used_count bigint not null,
|
|
|
hospital bigint not 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 appointments_date_index
|
|
|
on appointments (date);
|
|
|
|
|
|
create table auths
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
name varchar(50) not null comment '项目名称',
|
|
|
title varchar(20) not null comment '显示标题',
|
|
|
icon varchar(100) default '' not null comment '显示图标',
|
|
|
pid int not null comment '上级ID',
|
|
|
type tinyint not null comment '1-分组 2-页面/接口',
|
|
|
check_type tinyint not null comment '1-不需要验证 2-需要验证 3-特殊验证规则',
|
|
|
`show` tinyint default 1 not null comment '1-显示 2-不显示',
|
|
|
status tinyint default 1 not null comment '1-正常 2-禁用',
|
|
|
del tinyint default 2 not null comment '1-删除 2-正常',
|
|
|
`order` int default 0 not null comment '排序',
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (1, 'admin_basics', '后台基础接口', '', 0, 1, 1, 2, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (2, 'admin_basics_login', '后台登录', '', 1, 2, 1, 2, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (3, 'admin', '管理员设置', 'every-user', 0, 1, 1, 1, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (4, 'admin-info', '个人设置', 'user', 3, 2, 1, 1, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (5, 'admin-auth', '权限管理', 'personal-privacy', 3, 2, 2, 1, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (6, 'admin-list', '管理员列表', 'every-user', 3, 2, 2, 1, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (7, 'settings', '后台管理', 'setting', 0, 1, 1, 1, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (8, 'settings-config', '后台配置', 'setting-config', 7, 2, 2, 1, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (9, 'settings-router', '路由配置', 'left-and-right-branch', 7, 2, 2, 1, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (10, 'config', '基础设置', 'config', 0, 1, 1, 1, 1, 2, 0, '2023-04-07 14:41:39', '2023-04-07 14:41:39');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (11, 'config-hospital', '医院管理', 'hospital', 10, 2, 2, 1, 1, 2, 0, '2023-04-07 14:43:14', '2023-04-07 14:43:14');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (12, 'appointment', '预约管理', 'plan', 0, 1, 1, 1, 1, 2, 0, '2023-04-07 23:52:36', '2023-04-07 23:52:36');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (13, 'appointment-template', '计划模板', 'add-mode', 12, 2, 2, 1, 1, 2, 0, '2023-04-07 23:59:18', '2023-04-07 23:59:18');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (14, 'appointment-holidays', '节假日', 'beach-umbrella', 12, 2, 2, 1, 1, 2, 0, '2023-04-08 14:08:10', '2023-04-08 14:08:10');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (15, 'appointment-list', '预约计划', 'plan', 12, 2, 2, 1, 1, 2, 0, '2023-04-10 11:08:18', '2023-04-10 11:08:18');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (17, 'config-additional', '医院额外配置', 'tips-one', 10, 2, 2, 1, 1, 2, 0, '2023-04-11 09:31:54', '2023-04-11 09:31:54');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (18, 'user', '用户管理', 'user', 0, 1, 1, 1, 1, 2, 0, '2023-04-12 11:55:39', '2023-04-12 11:55:39');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (19, 'user-list', '用户列表', 'user', 18, 2, 2, 1, 1, 2, 0, '2023-04-12 11:55:58', '2023-04-12 11:55:58');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (20, 'user-person', '体检人列表', 'peoples', 18, 2, 2, 1, 1, 2, 0, '2023-04-13 09:24:52', '2023-04-13 09:24:52');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (21, 'hospital', '医院&小程序管理', 'plus-cross', 0, 1, 1, 1, 1, 2, 0, '2023-06-09 22:00:36', '2023-06-10 14:27:48');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (22, 'hospital-info', '基础信息', 'info', 21, 2, 2, 1, 1, 2, 0, '2023-06-09 22:02:15', '2023-06-09 22:02:15');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (23, 'hospital-home', '首页管理', 'home', 21, 2, 2, 1, 1, 2, 0, '2023-06-09 22:04:02', '2023-06-09 22:04:02');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (24, 'hospital-combo', '套餐管理', 'graphic-stitching-three', 21, 2, 2, 1, 1, 2, 0, '2023-06-09 22:05:09', '2023-06-09 22:05:09');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (25, 'hospital-additional', '额外配置', 'setting-two', 21, 2, 2, 1, 1, 2, 0, '2023-06-09 22:06:09', '2023-06-09 22:06:09');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (26, 'order-order', '订单管理', 'order', 29, 2, 2, 1, 1, 2, 0, '2023-06-09 22:06:55', '2023-06-10 14:25:09');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (27, 'order-template', '计划模板', 'plan', 29, 2, 2, 1, 1, 2, 0, '2023-06-09 22:08:32', '2023-06-10 14:25:15');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (28, 'order-appointment', '计划管理', 'plan', 29, 2, 2, 1, 1, 2, 0, '2023-06-09 22:09:15', '2023-06-10 14:25:22');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (29, 'order', '计划&订单', 'order', 0, 1, 1, 1, 1, 2, 0, '2023-06-10 14:24:29', '2023-06-10 14:24:29');
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (30, 'order-super_order', '超级订单管理', 'text-wrap-overflow', 29, 2, 2, 1, 1, 2, 0, '2023-06-10 14:44:41', '2023-06-10 14:44:41');
|
|
|
|
|
|
create table carousels
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
name varchar(20) not null,
|
|
|
image varchar(200) not null,
|
|
|
`desc` varchar(50) default '' null,
|
|
|
hospital bigint not null,
|
|
|
type tinyint not null comment '1-轮播图 2-广告',
|
|
|
jump_type tinyint not null comment '1-无跳转 2-小程序跳转 3-H5跳转',
|
|
|
jump_path varchar(200) not null,
|
|
|
login_type tinyint not null comment '1-需要 2-不需要',
|
|
|
start_time datetime not null,
|
|
|
end_time datetime not null,
|
|
|
status tinyint not null,
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create index carousels_hospital_index
|
|
|
on carousels (hospital);
|
|
|
|
|
|
create index carousels_type_index
|
|
|
on carousels (type);
|
|
|
|
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (1, '测试轮播图', '/storage/assets/upload/image/2023/04/98e750cd-17c5-4f07-aadb-f1880b081cd4.png', null, 0, 1, 1, '/aaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 13:56:47', '2023-04-11 23:44:11');
|
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (3, '测试2', '/storage/assets/upload/image/2023/04/98e75454-60a9-48d5-9ae7-70f9e222007b.jpeg', null, 0, 1, 1, '', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 14:06:38', '2023-04-11 23:44:20');
|
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (4, '套餐测试', '/storage/assets/upload/image/2023/04/98e75485-3cac-4ebc-aa89-f918401a4b2f.png', '套餐测试', 0, 2, 4, 'activity_package;2', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 14:07:12', '2023-05-24 20:59:15');
|
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (5, '测试2', '/storage/assets/upload/image/2023/04/98e75497-ea0d-476a-9c56-c475030ca832.jpeg', null, 0, 2, 4, 'combo_item_open;2349;1,2,3;{"id":0,"date":null}', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 14:07:22', '2023-05-27 10:51:40');
|
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (6, '个检预约', '/storage/assets/upload/image/2023/04/98e85460-2128-4135-86cc-297dd9e748e8.png', '点击预约个检', 0, 3, 4, 'order_choose_type', 1, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 14:15:13', '2023-04-12 02:18:57');
|
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (7, '团检预约', '/storage/assets/upload/image/2023/04/98e85748-2963-4635-8654-d5a2776c1668.png', '点击预约团检', 0, 3, 2, '/pages/buy/person/person?type=group', 1, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 14:15:26', '2023-05-26 16:20:48');
|
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (8, '健康问卷', '/storage/assets/upload/image/2023/04/98e85af6-8a22-4ff0-a831-7f7bdd50ef0d.png', '填写问卷', 0, 4, 2, '/pages/buy/person/person?type=question', 1, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 14:15:13', '2023-06-09 04:50:35');
|
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (9, '满意度调查', '/storage/assets/upload/image/2023/04/98e85b8c-71f8-419d-8326-b691fbd9d1fd.png', '意见和建议', 0, 4, 3, 'http://192.168.31.84:5173/h5/#/pages/main/login/login?page=question&token=[TOKEN]¶m=&hospital=[HOSPITAL]', 1, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 14:15:26', '2023-06-09 02:16:04');
|
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (10, '健康宣传', '/storage/assets/upload/image/2023/04/98e85b97-468b-4a1d-b55c-d72ed8076a21.png', '健康科普', 0, 4, 3, 'http://192.168.31.84:5173/h5/#/pages/main/posts/posts?type=1&hospital=[HOSPITAL]', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-12 01:25:21', '2023-06-09 02:16:10');
|
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (11, '常见问题', '/storage/assets/upload/image/2023/04/98e85be6-c467-42ff-b62f-95fc274e8939.png', '问题解答', 0, 4, 3, 'http://192.168.31.84:5173/h5/#/pages/main/posts/posts?type=2&hospital=[HOSPITAL]', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-12 01:26:35', '2023-06-09 02:16:16');
|
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (13, '体检引导', '/storage/assets/upload/image/2023/04/98e855dc-2df4-478f-9ac8-934deec649fc.png', '点击扫码排队', 0, 3, 2, '/pages/order/choose_person/choose_person', 1, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 2, '2023-04-12 02:10:35', '2023-06-09 02:03:08');
|
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (14, '报告查询', '/storage/assets/upload/image/2023/04/98e857d9-e99a-4146-bcc0-3dc6f220af0e.png', '点击查看报告', 0, 3, 2, '/pages/buy/person/person?type=report', 1, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-12 02:13:46', '2023-06-03 01:16:05');
|
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (15, '测试', '/storage/assets/upload/image/2023/06/995ee267-7d9f-4df7-ad45-410bddde770d.png', 'AAAAAAAAA', 1, 1, 1, '', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-06-10 00:27:30', '2023-06-10 00:27:30');
|
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (16, 'ASDASDSAD', '/storage/assets/upload/image/2023/06/995ee441-6862-4d35-a3d7-e995464298e4.png', 'ASDASDASD', 1, 2, 1, '', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-06-10 00:32:37', '2023-06-10 00:32:37');
|
|
|
|
|
|
|
|
|
create table configs
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
label varchar(50) not null,
|
|
|
value varchar(1000) not null,
|
|
|
type tinyint not null comment '1-文字 2-图片 3-文字数组 4-图片数组 5-Key_Value',
|
|
|
remark varchar(100) not null,
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create index configs_type_index
|
|
|
on configs (type);
|
|
|
|
|
|
INSERT INTO lkpe.configs (id, label, value, type, remark, created_at, updated_at) VALUES (1, 'Logo', '/storage/assets/logo.png', 2, '', '2023-04-06 23:01:37', '2023-04-06 23:01:37');
|
|
|
INSERT INTO lkpe.configs (id, label, value, type, remark, created_at, updated_at) VALUES (2, 'Favicon', '/storage/assets/favicon.png', 2, '', '2023-04-06 23:01:37', '2023-04-06 23:01:37');
|
|
|
INSERT INTO lkpe.configs (id, label, value, type, remark, created_at, updated_at) VALUES (3, 'Login欢迎图片', '/storage/assets/login_image.jpg', 2, '', '2023-04-06 23:01:37', '2023-04-06 23:01:37');
|
|
|
INSERT INTO lkpe.configs (id, label, value, type, remark, created_at, updated_at) VALUES (4, '网站名称', '岚科体检预约', 1, '', '2023-04-06 23:01:37', '2023-04-06 23:01:37');
|
|
|
INSERT INTO lkpe.configs (id, label, value, type, remark, created_at, updated_at) VALUES (5, '客服电话', '13333333333', 1, '', '2023-04-10 23:22:21', '2023-04-11 23:17:51');
|
|
|
INSERT INTO lkpe.configs (id, label, value, type, remark, created_at, updated_at) VALUES (6, '小程序默认封面图', '/storage/assets/mp/home/cover.png', 2, '', '2023-04-11 09:23:34', '2023-04-11 09:23:34');
|
|
|
INSERT INTO lkpe.configs (id, label, value, type, remark, created_at, updated_at) VALUES (7, '会员卡配置', '{"open":0}', 5, '', '2023-04-11 09:29:24', '2023-04-11 09:29:24');
|
|
|
|
|
|
|
|
|
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');
|
|
|
|
|
|
|
|
|
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');
|
|
|
|
|
|
|
|
|
create table hospital_extras
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
hospital bigint not null,
|
|
|
mark varchar(20) not null,
|
|
|
content longtext not null,
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create index hospital_extras_hospital_index
|
|
|
on hospital_extras (hospital);
|
|
|
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (1, 0, 'pay', '{"wxp":{"open":1,"id":"1638739772","number":"3CE37188EBCFBBEB800B0E1C69B360F05A3E80CD","v3":"AVPV7NxK8cC2RvRrrwdTqUG9YbQXQe3w","key":"/storage/app/forbidden/2023/05/9943b647-1143-40c6-be2c-8844919ee1ff.pem","crt":"/storage/app/forbidden/2023/05/9943b64e-32f6-4eb1-b218-df86353965de.pem"}}', '2023-05-24 13:10:48', '2023-05-27 12:16:49');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (2, 0, 'order_type', '{"combo_add_item":2,"item":1}', '2023-05-24 13:10:48', '2023-06-09 10:06:24');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (3, 0, 'card_pay', '{"open":2}', '2023-05-24 14:29:59', '2023-05-24 14:35:50');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (4, 1, 'pay', '{"wxp":{"open":0,"id":"","number":"","v3":"","key":"","crt":""}}', '2023-05-25 21:31:04', '2023-05-25 21:31:04');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (5, 1, 'order_type', '{"combo_add_item":0,"item":0}', '2023-05-25 21:31:04', '2023-05-25 21:31:04');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (6, 1, 'card_pay', '{"open":0}', '2023-05-25 21:31:04', '2023-05-25 21:31:04');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (7, 0, 'readme', '{"open":1,"content":"1、体检前三天不应参加聚餐，太甜、太咸、太油腻的食物应避免，禁酒，尽量以素食\\n为主。晚上八点钟后一般要求禁食，并应早睡。<br/>\\n2、体检当日不吃早餐，空腹进行抽血及腹部B超检查等体检项目。<br/>\\n3、进行女性妇科B超、男性前列腺B超时，需要憋尿。<br/>\\n4、女性在作妇科检查时,需要排尽小便。<br/>\\n5、女性月经期间不宜做妇科检查及化验室小便检查;孕妇不应做X线检查。<br/>\\n6、静脉抽血后用棉球压住针头的穿刺点两分钟，不能按揉，防止形成血肿。<br/>\\n7、接受体检时，应自然放松，心态平和，为医生提供真实的病历资料及自我身体状况\\n或感觉。","time":5}', '2023-05-26 11:50:02', '2023-05-27 12:20:08');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (8, 1, 'readme', '{"open":1,"content":"AAAAAAAAAAAAA","time":5}', '2023-05-26 12:50:40', '2023-06-10 00:51:02');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (9, 2, 'pay', '{"wxp":{"open":0,"id":"","number":"","v3":"","key":"","crt":""}}', '2023-05-26 12:51:54', '2023-05-26 12:51:54');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (10, 2, 'order_type', '{"combo_add_item":0,"item":0}', '2023-05-26 12:51:54', '2023-05-26 12:51:54');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (11, 2, 'card_pay', '{"open":0}', '2023-05-26 12:51:54', '2023-05-26 12:51:54');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (12, 2, 'readme', '{"open":0,"content":"","time":5}', '2023-05-26 12:51:54', '2023-05-26 12:51:54');
|
|
|
|
|
|
|
|
|
create table hospital_posts
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
hospital bigint not null,
|
|
|
title varchar(100) not null,
|
|
|
author varchar(20) not null,
|
|
|
date date not null,
|
|
|
`desc` varchar(200) not null,
|
|
|
content longtext not null,
|
|
|
cover varchar(200) not null,
|
|
|
type tinyint not null comment '1-健康宣传 2-常见问题',
|
|
|
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_posts_type_index
|
|
|
on hospital_posts (type);
|
|
|
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (1, 0, '《用户服务协议》及《隐私政策》', '体检中心', '2023-06-05', '《用户服务协议》及《隐私政策》', '<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">本应用非常重视用户隐私政策并严格遵守相关的法律规定。请您仔细阅读《隐私政策》后再继续使用。如果您继续使用我们的服务，表示您已经充分阅读和理解我们协议的全部内容。</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">本小程序尊重并保护所有使用服务用户的个人隐私权。为了给您提供更准确、更优质的服务，本应用会按照本隐私权政策的规定使用和披露您的个人信息。除本隐私权政策另有规定外，在未征得您事先许可的情况下，本应用不会将这些信息对外披露或向第三方提供。本应用会不时更新本隐私权政策。 您在同意本应用服务使用协议之时，即视为您已经同意本隐私权政策全部内容。</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">1. 适用范围</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">(a) 在您注册本应用小程序帐号时，您根据小程序要求提供个人绑定信息；</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">(b) 在您使用本应用网络服务，或访问本应用平台网页时，本应用自动接收并记录的您的浏览器和计算机上的信息，包括但不限于您的IP地址、浏览器的类型、使用的语言、访问日期和时间、软硬件特征信息及您需求的网页记录等数据；</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">(c)本应用严禁用户发布不良信息，如裸露、色情和亵渎内容，发布的内容我们会进行审核，一经发现不良信息，会禁用该用户的所有权限，予以封号处理。</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">2. 信息使用</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">(a)本应用不会向任何无关第三方提供、出售、出租、分享或交易您的个人登录信息。如果我们存储发生维修或升级，我们会事先发出推送消息来通知您，请您提前允许本应用消息通知。</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">(b) 本应用亦不允许任何第三方以任何手段收集、编辑、出售或者无偿传播您的个人信息。任何本应用平台用户如从事上述活动，一经发现，本应用有权立即终止与该用户的服务协议。</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">(c) 为服务用户的目的，本应用可能通过使用您的个人信息，向您提供您感兴趣的信息，包括但不限于向您发出产品和服务信息，或者与本应用合作伙伴共享信息以便他们向您发送有关其产品和服务的信息（后者需要您的事先同意）</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">3. 信息披露</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">在如下情况下，本应用将依据您的个人意愿或法律的规定全部或部分的披露您的个人信息：</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">(a) 未经您事先同意，我们不会向第三方披露；</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">(b)为提供您所要求的产品和服务，而必须和第三方分享您的个人信息；</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">(c) 根据法律的有关规定，或者行政或司法机构的要求，向第三方或者行政、司法机构披露；</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">(d) 如您出现违反中国有关法律、法规或者本应用服务协议或相关规则的情况，需要向第三方披露；</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">(e) 如您是适格的知识产权投诉人并已提起投诉，应被投诉人要求，向被投诉人披露，以便双方处理可能的权利纠纷；</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">4. 信息存储和交换</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">本应用收集的有关您的信息和资料将保存在本应用及（或）其关联公司的服务器上，这些信息和资料可能传送至您所在国家、地区或本应用收集信息和资料所在地的境外并在境外被访问、存储和展示。</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">5.本隐私政策的更改</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">(a)如果决定更改隐私政策，我们会在本政策中以及我们认为适当的位置发布这些更改，以便您了解我们如何收集、使用您的个人信息，哪些人可以访问这些信息，以及在什么情况下我们会透露这些信息。</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">(b)本公司保留随时修改本政策的权利，因此请经常查看。如对本政策作出重大更改，会提前发布通知。</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">方披露自己的个人信息，如联络方式或者邮政地址。请您妥善保护自己的个人信息，仅在必要的情形下向他人提供。如您发现自己的个人信息泄密，尤其是本应用用户名及密码发生泄露，请您立即联络本应用客服，以便本应用采取相应措施。</span></p>
|
|
|
<p><span style="color: #999999; font-family: 宋体;"> </span></p>
|
|
|
<p><span style="color: #999999; background-color: #ffffff; font-family: 宋体;">感谢您花时间了解我们的隐私政策！我们将尽全力保护您的个人信息和合法权益，再次感谢您的信任！</span></p>
|
|
|
<p> </p>', '/storage/assets/upload/image/2023/06/9956ae66-e79a-491f-9be0-811cdc33b58a.png', 1, 1, 2, '2023-06-05 22:35:23', '2023-06-06 09:40:12');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (2, 0, '体检须知', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p class="MsoNormal" style="margin: 0pt 0pt 0.0001pt; text-align: justify; font-family: Calibri; font-size: 10.5pt;"><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">一、体检前三天注意饮食</span> <span style="font-family: 宋体;">，勿食过于油腻、</span> <span style="font-family: 宋体;">辛辣、</span> <span style="font-family: 宋体;">刺激、</span> <span style="font-family: 宋体;">不易消化的食物</span> <span style="font-family: 宋体;">，不饮酒</span> <span style="font-family: 宋体;">，不吃对肝脏、</span> <span style="font-family: 宋体;">肾脏功能有损害的药物。</span></span></p>
|
|
|
<p class="MsoNormal" style="margin: 0pt 0pt 0.0001pt; text-align: justify; font-family: Calibri; font-size: 10.5pt;"><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">二、体检前一</span> <span style="font-family: 宋体;">日晚上</span>8<span style="font-family: 宋体;">点钟后</span></span><span style="font-family: \'Segoe UI\'; color: #ff0000; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">避免剧烈运动</span></span><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"> <span style="font-family: 宋体;">，保持充足的睡眠</span> <span style="font-family: 宋体;">，体检前保证</span></span><span style="font-family: \'Segoe UI\'; color: #ff0000; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">禁食（含禁牛奶，果汁，糖水等饮料）</span>10- 12<span style="font-family: 宋体;">小时</span></span><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"> <span style="font-family: 宋体;">，体检前</span></span><span style="font-family: \'Segoe UI\'; color: #ff0000; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;">2<span style="font-family: 宋体;">小时禁水</span></span><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">。</span></span></p>
|
|
|
<p class="MsoNormal" style="margin: 0pt 0pt 0.0001pt; text-align: justify; font-family: Calibri; font-size: 10.5pt;"><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">三、</span></span><span style="font-family: \'Segoe UI\'; color: #ff0000; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">若有长期服用高血压、心脏病、癫痫、哮喘等疾病药物</span> <span style="font-family: 宋体;">，体检当日请继续服用</span></span><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;">(<span style="font-family: 宋体;">配少量开水 ，约</span><span style="font-family: Segoe UI;">1</span><span style="font-family: 宋体;">小口量</span><span style="font-family: Segoe UI;">) </span><span style="font-family: 宋体;">，并携带药物供医师参考</span><span style="font-family: Segoe UI;">;</span><span style="font-family: 宋体;">糖尿病药物体检当天早上请勿服用或注射用 ，但务必携带药物于空腹检查完成后遵循医瞩服用或注射。</span></span></p>
|
|
|
<p class="MsoNormal" style="margin: 0pt 0pt 0.0001pt; text-align: justify; font-family: Calibri; font-size: 10.5pt;"><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">四、体检当日请穿着</span></span><span style="font-family: \'Segoe UI\'; color: #ff0000; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">宽松舒适的分体服装</span></span><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"> <span style="font-family: 宋体;">，</span> <span style="font-family: 宋体;">避免带扣子、</span> <span style="font-family: 宋体;">拉链、</span> <span style="font-family: 宋体;">亮片、金属物质的衣物，为避免财物丢失</span> <span style="font-family: 宋体;">，请不要携带贵重物品参检。</span></span></p>
|
|
|
<p class="MsoNormal" style="margin: 0pt 0pt 0.0001pt; text-align: justify; font-family: Calibri; font-size: 10.5pt;"><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">五、请检查当日保持膀胱充盈</span></span><span style="font-family: \'Segoe UI\'; color: #ff0000; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;">(<span style="font-family: 宋体;">憋尿</span><span style="font-family: Segoe UI;">)</span><span style="font-family: 宋体;">，</span><span style="font-family: Segoe UI;">B</span><span style="font-family: 宋体;">超检查完成后立即留取尿标本</span></span><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">。如情况允许，</span></span><span style="font-family: \'Segoe UI\'; color: #ff0000; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">请至体检中心留取粪便标本。</span></span></p>
|
|
|
<p class="MsoNormal" style="margin: 0pt 0pt 0.0001pt; text-align: justify; font-family: Calibri; font-size: 10.5pt;"><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">六、人体成分检查是运用微电流进入人体来进行检查</span> <span style="font-family: 宋体;">，故装有起搏器者不宜接受此项检查。</span> <span style="font-family: 宋体;">另体内有金属物质植入</span>(<span style="font-family: 宋体;">如</span><span style="font-family: Segoe UI;">:</span><span style="font-family: 宋体;">金属假牙、 支架、 钢钉、 节育器</span><span style="font-family: Segoe UI;">)</span><span style="font-family: 宋体;">或怀孕者 ，受检时请事先告知。</span></span></p>
|
|
|
<p class="MsoNormal" style="margin: 0pt 0pt 0.0001pt; text-align: justify; font-family: Calibri; font-size: 10.5pt;"><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">七、女士请注意</span>:</span></p>
|
|
|
<p class="MsoNormal" style="margin: 0pt 0pt 0.0001pt; text-align: justify; font-family: Calibri; font-size: 10.5pt;"><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;">1<span style="font-family: 宋体;">、</span></span><span style="font-family: \'Segoe UI\'; color: #ff0000; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">女性体检请避开月经期</span></span></p>
|
|
|
<p class="MsoNormal" style="margin: 0pt 0pt 0.0001pt; text-align: justify; font-family: Calibri; font-size: 10.5pt;"><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;">2<span style="font-family: 宋体;">、</span></span><span style="font-family: \'Segoe UI\'; color: #ff0000; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">无性生活史女性不做妇科检查</span></span><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">；</span> <span style="font-family: 宋体;">如仍需检查者请告知妇检医生。</span></span></p>
|
|
|
<p class="MsoNormal" style="margin: 0pt 0pt 0.0001pt; text-align: justify; font-family: Calibri; font-size: 10.5pt;"><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;">3<span style="font-family: 宋体;">、女士请在受检前</span><span style="font-family: Segoe UI;">2</span><span style="font-family: 宋体;">日暂停阴道用药、冲洗，避免性生活。</span></span></p>
|
|
|
<p class="MsoNormal" style="margin: 0pt 0pt 0.0001pt; text-align: justify; font-family: Calibri; font-size: 10.5pt;"><span style="font-family: \'Segoe UI\'; color: #666666; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;">4<span style="font-family: 宋体;">、</span></span><span style="font-family: \'Segoe UI\'; color: #ff0000; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;"><span style="font-family: 宋体;">怀孕、准备怀孕或不能排除是否受孕者</span> <span style="font-family: 宋体;">，避免做放射性检查</span>(<span style="font-family: 宋体;">如：</span></span><span style="font-family: \'Segoe UI\'; color: #ff0000; letter-spacing: 0pt; font-size: 9pt; background: #fafafa;">DR<span style="font-family: 宋体;">、</span><span style="font-family: Segoe UI;">CT</span><span style="font-family: 宋体;">、乳朣钼靶、</span><span style="font-family: Segoe UI;">X</span><span style="font-family: 宋体;">线骨密度等</span><span style="font-family: Segoe UI;">)</span><span style="font-family: 宋体;">。</span></span></p>', '', 2, 1, 2, '2023-06-05 22:38:56', '2023-06-08 09:26:59');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (3, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 2, '2023-06-05 22:38:56', '2023-06-05 22:38:56');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (4, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 2, '2023-06-05 22:38:56', '2023-06-05 22:38:56');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (5, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 2, '2023-06-05 22:38:56', '2023-06-05 22:38:56');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (6, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 2, '2023-06-05 22:38:56', '2023-06-05 22:38:56');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (7, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 2, '2023-06-05 22:38:56', '2023-06-05 22:38:56');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (8, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p><img src="http://127.0.0.1:8000/storage/assets/upload/image/2023/06/9956bfbd-5e5a-4006-aa39-559057151786.png" />BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 2, '2023-06-05 22:38:56', '2023-06-05 23:23:54');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (9, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 1, '2023-06-05 22:38:56', '2023-06-05 23:11:24');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (10, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 1, '2023-06-05 22:38:56', '2023-06-05 23:11:24');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (11, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 1, '2023-06-05 22:38:56', '2023-06-05 23:11:24');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (12, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 1, '2023-06-05 22:38:56', '2023-06-05 23:11:24');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (13, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 1, '2023-06-05 22:38:56', '2023-06-05 23:11:24');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (14, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 1, '2023-06-05 22:38:56', '2023-06-05 23:11:24');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (15, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 1, '2023-06-05 22:38:56', '2023-06-05 23:11:24');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (16, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 1, '2023-06-05 22:38:56', '2023-06-05 23:11:24');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (17, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 1, '2023-06-05 22:38:56', '2023-06-05 23:11:24');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (18, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 1, '2023-06-05 22:38:56', '2023-06-05 23:11:24');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (19, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 1, '2023-06-05 22:38:56', '2023-06-05 23:11:24');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (20, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 1, '2023-06-05 22:38:56', '2023-06-05 23:11:24');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (21, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 1, '2023-06-05 22:38:56', '2023-06-05 23:11:24');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (22, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>', '', 2, 1, 1, '2023-06-05 22:38:56', '2023-06-05 23:11:24');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (23, 0, 'BBBBBB', 'BBBBBB', '2023-06-05', 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB', '<p>BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB</p>
|
|
|
<p> </p>
|
|
|
<p>234</p>
|
|
|
<p>234</p>
|
|
|
<p>23</p>
|
|
|
<p>423</p>
|
|
|
<p>4</p>', '', 2, 1, 1, '2023-06-05 22:38:56', '2023-06-05 23:11:24');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (24, 1, 'YOOO', 'sadf', '2023-06-10', 'sadfasdfsadf', '<p>sadfasdfasdfasdfsadf</p>', '/storage/assets/upload/image/2023/06/995ee9ce-b535-4043-8404-f6f3e11a1e92.png', 1, 1, 2, '2023-06-10 00:48:07', '2023-06-10 00:48:07');
|
|
|
INSERT INTO lkpe.hospital_posts (id, hospital, title, author, date, `desc`, content, cover, type, status, del, created_at, updated_at) VALUES (25, 0, '测试无封面', 'ASD', '2023-06-10', 'asdasd', '<p>ASDASD</p>', '', 1, 1, 2, '2023-06-10 12:12:47', '2023-06-10 12:12:47');
|
|
|
|
|
|
|
|
|
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');
|
|
|
|
|
|
|
|
|
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');
|
|
|
|
|
|
|
|
|
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');
|
|
|
|
|
|
create table user_accounts
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
user bigint not null,
|
|
|
account varchar(50) not null,
|
|
|
secret varchar(80) not null,
|
|
|
type tinyint not null comment '1-微信OPENID',
|
|
|
del tinyint default 2 not null comment '1-删除 2-正常',
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create index user_accounts_account_index
|
|
|
on user_accounts (account);
|
|
|
|
|
|
create table user_orders
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
user bigint not null,
|
|
|
hospital bigint not null,
|
|
|
name varchar(50) not null,
|
|
|
id_number varchar(50) not null,
|
|
|
phone varchar(30) not null,
|
|
|
birthday date not null,
|
|
|
sex tinyint not null comment '1-男 2-女',
|
|
|
marriage tinyint not null comment '1-是 2-否',
|
|
|
buy_info text not null,
|
|
|
type tinyint not null comment '1-个检 2-团检',
|
|
|
combo varchar(50) not null,
|
|
|
price decimal(9, 2) not null,
|
|
|
true_price decimal(9, 2) not null,
|
|
|
group_price decimal(9, 2) not null,
|
|
|
pay_type tinyint default 0 not null comment '0-未指定 1-微信 2-会员卡 3-免费',
|
|
|
transaction varchar(50) null,
|
|
|
status tinyint not null comment '1-待支付 2-已支付 3-已取消 4-已完成 5-已退款',
|
|
|
pay_time datetime null,
|
|
|
refund bigint default 0 not null,
|
|
|
refund_time datetime null,
|
|
|
appointment bigint not null,
|
|
|
appointment_time datetime not null,
|
|
|
`show` varchar(50) not null,
|
|
|
appointment_number varchar(50) null,
|
|
|
appointment_info longtext null,
|
|
|
exam_number varchar(50) null,
|
|
|
check_status tinyint default 1 not null comment '1-待检查 2-已检查',
|
|
|
check_time datetime null,
|
|
|
referral varchar(50) default '' null,
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create index user_orders_appointment_index
|
|
|
on user_orders (appointment);
|
|
|
|
|
|
create index user_orders_combo_index
|
|
|
on user_orders (combo);
|
|
|
|
|
|
create index user_orders_hospital_index
|
|
|
on user_orders (hospital);
|
|
|
|
|
|
create index user_orders_id_number_index
|
|
|
on user_orders (id_number);
|
|
|
|
|
|
create index user_orders_name_index
|
|
|
on user_orders (name);
|
|
|
|
|
|
create index user_orders_phone_index
|
|
|
on user_orders (phone);
|
|
|
|
|
|
create index user_orders_show_index
|
|
|
on user_orders (`show`);
|
|
|
|
|
|
create index user_orders_user_index
|
|
|
on user_orders (user);
|
|
|
|
|
|
create table user_people
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
user bigint not null,
|
|
|
name varchar(50) not null,
|
|
|
id_number varchar(50) not null,
|
|
|
birthday date not null,
|
|
|
sex tinyint not null comment '1-男 2-女',
|
|
|
phone varchar(30) not null,
|
|
|
relationship varchar(30) not null,
|
|
|
marriage tinyint not null comment '1-是 2-否',
|
|
|
`default` tinyint not null comment '1-是 2-否',
|
|
|
del tinyint default 2 not null comment '1-是 2-否',
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create index user_people_id_number_index
|
|
|
on user_people (id_number);
|
|
|
|
|
|
create index user_people_user_index
|
|
|
on user_people (user);
|
|
|
|
|
|
create table user_tokens
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
user bigint not null,
|
|
|
token varchar(50) not null,
|
|
|
type tinyint not null comment '1-微信',
|
|
|
del tinyint default 2 not null comment '1-删除 2-正常',
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null,
|
|
|
constraint user_tokens_token_unique
|
|
|
unique (token)
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create table users
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
nickname varchar(100) not null,
|
|
|
avatar varchar(200) not null,
|
|
|
dev tinyint default 2 not null comment '1-测试 2-普通',
|
|
|
pay decimal(8, 2) default -1.00 not null comment '支付金额 负数按实际金额支付',
|
|
|
status tinyint default 1 not null comment '1-正常 2-禁用',
|
|
|
del tinyint default 2 not null comment '1-删除 2-正常',
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
|
|
|
create table we_chat_pays
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
out_trade_no varchar(100) not null,
|
|
|
post_data text not null,
|
|
|
params text not null,
|
|
|
callback longtext null,
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create index we_chat_pays_out_trade_no_index
|
|
|
on we_chat_pays (out_trade_no);
|
|
|
|
|
|
create table we_chat_refunds
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
admin bigint default 0 null,
|
|
|
out_trade_no varchar(100) not null,
|
|
|
post_data text not null,
|
|
|
params longtext not null,
|
|
|
callback longtext null,
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create index we_chat_refunds_out_trade_no_index
|
|
|
on we_chat_refunds (out_trade_no);
|