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.
41 lines
5.1 KiB
SQL
41 lines
5.1 KiB
SQL
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);
|
|
|
|
INSERT INTO lkpe.user_people (id, user, name, id_number, birthday, sex, phone, relationship, marriage, `default`, del, created_at, updated_at) VALUES (1, 1, '陆予', '130322199409060012', '1994-09-06', 1, '15232310906', '本人', 2, 2, 2, '2023-04-12 23:29:17', '2023-04-13 10:22:35');
|
|
INSERT INTO lkpe.user_people (id, user, name, id_number, birthday, sex, phone, relationship, marriage, `default`, del, created_at, updated_at) VALUES (2, 1, '陆予一二', '130322199409060012', '1994-09-06', 1, '15232310906', '其他', 2, 2, 1, '2023-04-12 23:29:31', '2023-04-13 00:16:50');
|
|
INSERT INTO lkpe.user_people (id, user, name, id_number, birthday, sex, phone, relationship, marriage, `default`, del, created_at, updated_at) VALUES (3, 1, '陆予二', '130322199409060012', '1994-09-06', 1, '15232310906', '其他', 2, 2, 2, '2023-04-12 23:29:31', '2023-04-13 00:23:39');
|
|
INSERT INTO lkpe.user_people (id, user, name, id_number, birthday, sex, phone, relationship, marriage, `default`, del, created_at, updated_at) VALUES (4, 1, '陆予三', '130322199409060012', '1994-09-06', 1, '15232310906', '其他', 2, 2, 2, '2023-04-12 23:29:31', '2023-04-12 23:29:31');
|
|
INSERT INTO lkpe.user_people (id, user, name, id_number, birthday, sex, phone, relationship, marriage, `default`, del, created_at, updated_at) VALUES (5, 1, '陆予四', '130322199409060012', '1994-09-06', 1, '15232310906', '其他', 2, 2, 1, '2023-04-12 23:29:31', '2023-04-13 00:16:56');
|
|
INSERT INTO lkpe.user_people (id, user, name, id_number, birthday, sex, phone, relationship, marriage, `default`, del, created_at, updated_at) VALUES (6, 1, '陆予五', '130322199409060012', '1994-09-06', 1, '15232310906', '其他', 2, 2, 2, '2023-04-12 23:29:31', '2023-04-12 23:29:31');
|
|
INSERT INTO lkpe.user_people (id, user, name, id_number, birthday, sex, phone, relationship, marriage, `default`, del, created_at, updated_at) VALUES (7, 1, '陆予六', '130322199409060012', '1994-09-06', 1, '15232310906', '其他', 2, 2, 2, '2023-04-12 23:29:31', '2023-04-12 23:29:31');
|
|
INSERT INTO lkpe.user_people (id, user, name, id_number, birthday, sex, phone, relationship, marriage, `default`, del, created_at, updated_at) VALUES (8, 1, '陆予七', '130322199409060012', '1994-09-06', 1, '15232310906', '其他', 2, 2, 2, '2023-04-12 23:29:31', '2023-04-12 23:29:31');
|
|
INSERT INTO lkpe.user_people (id, user, name, id_number, birthday, sex, phone, relationship, marriage, `default`, del, created_at, updated_at) VALUES (9, 1, '陆予八', '130322199409060012', '1994-09-06', 1, '15232310906', '其他', 2, 2, 2, '2023-04-12 23:29:31', '2023-04-12 23:29:31');
|
|
INSERT INTO lkpe.user_people (id, user, name, id_number, birthday, sex, phone, relationship, marriage, `default`, del, created_at, updated_at) VALUES (10, 1, '陆予九', '130322199409060012', '1994-09-06', 1, '15232310906', '其他', 2, 2, 2, '2023-04-12 23:29:31', '2023-04-12 23:29:31');
|
|
INSERT INTO lkpe.user_people (id, user, name, id_number, birthday, sex, phone, relationship, marriage, `default`, del, created_at, updated_at) VALUES (11, 1, '陆予十', '130322199409060012', '1994-09-06', 1, '15232310906', '其他', 1, 2, 2, '2023-04-12 23:29:31', '2023-04-13 10:21:41');
|
|
INSERT INTO lkpe.user_people (id, user, name, id_number, birthday, sex, phone, relationship, marriage, `default`, del, created_at, updated_at) VALUES (12, 1, '陆予三三', '130322199409060012', '1994-09-06', 1, '15232310906', '本人', 1, 1, 2, '2023-04-13 10:22:35', '2023-05-26 14:48:06');
|
|
INSERT INTO lkpe.user_people (id, user, name, id_number, birthday, sex, phone, relationship, marriage, `default`, del, created_at, updated_at) VALUES (13, 1, '团检预约测试', '110101198805279357', '2023-05-30', 1, '12345678901', '其他', 2, 2, 2, '2023-05-30 18:02:04', '2023-05-30 18:02:04');
|
|
INSERT INTO lkpe.user_people (id, user, name, id_number, birthday, sex, phone, relationship, marriage, `default`, del, created_at, updated_at) VALUES (14, 1, '团检预约测试', '110101198805279357', '1988-05-27', 1, '12345678901', '其他', 2, 2, 2, '2023-06-01 15:57:40', '2023-06-01 15:57:40');
|
|
INSERT INTO lkpe.user_people (id, user, name, id_number, birthday, sex, phone, relationship, marriage, `default`, del, created_at, updated_at) VALUES (15, 1, '报告测试', '130302200005307330', '2000-05-30', 1, '13245678901', '其他', 2, 2, 2, '2023-06-03 01:28:08', '2023-06-03 01:28:08');
|