人脸预警数据库er图

t_lib_info(人脸库信息表)

`lib_id``school_id``lib_name``lib_type` `create_by``create_by_name` `create_time`

box_id 1:1

t_lib_person(人脸库人员信息表)

`person_id``school_id``lib_id``user_id``user_type`(1-学生 2-老师 3-陌生人)`create_time`

t_person_picture(人员聚档信息表)

`ps_id`  `school_id` `person_id` `device_id` `device_name` `longitude` `latitude` `altitude` `person_age` `person_sex` `snap_url` `snap_time` `glass_style` `mustache_style` `respirator` `similarity` `quality` `create_time`  `snap_full_pic` `big_snap_url` `big_snap_full_url`

img_id：盒子内部唯一id

lib_id1:n

box_id 1:n

user_id=teacher_id 1:1

t_lib_person_push(人员信息下发记录表)

`pp_id``box_id``box_lib_id``person_id``sync_time``sync_status` 同步状态`img_id`

img_id 1:n

strange_id 1:n

t_face_snap(人脸抓拍信息表)

`fs_id` `school_id`  `device_id` `device_name` `camera_no` `longitude`  `latitude`  `altitude` `serial_no`  `channel_no` `img_id`  `person_age` `person_sex` `snap_id` `snap_url`  `snap_time``appear_count` `glass_style` `mustache_style` `respirator`  `similarity`  `quality` `create_time` `snap_full_pic` `person_id` `lib_type`

t_box_info(盒子信息表)

`box_id` `box_name`  `box_no`  `serial_no` `school_id` `device_factory` `account` `password` `ip_address` `is_deleted` `channel_count` `status` `type`

t_lib_correlation(人脸库关联信息表)

`bc_id` `lib_id``box_id``box_lib_id`

t_stranger(陌生人信息表)

`stranger_id``school_id``box_id``stranger_name``idcard_no``stranger_age``stranger_sex` `stranger_tel``img_id``face_url``snap_time``device_id``device_name``glass_style` `mustache_style``respirator``convert_status` `create_time``face_full_url`

t_student_archives(学生表)

archives_id...

lib_id 1:n

person_id1:n

t_teacher(老师表)

teacher_id...

person_id = stranger_id1:1

person_id 1:n

user_id=archives_id 1:1

t_stranger_relation(陌生人相似度关系表)

`sr_id``stranger_id``box_id``img_id`