test
Tables (8)
admins
- admin_id — INT
- admin_username — VARCHAR(20) — NOT NULL
- admin_pw — CHAR(60) — NOT NULL
- admin_name — VARCHAR(20) — NOT NULL
- admin_level — TINYINT — NOT NULL
- admin_face_img — MEDIUMBLOB
- org_id — INT — NOT NULL
bounding_boxes
- bounding_box_id — INT
- bounding_box_timestamp — DATETIME(6) — NOT NULL
- turret_id — INT — NOT NULL
- record_id — INT — NOT NULL
- y1 — FLOAT — NOT NULL
- x1 — FLOAT — NOT NULL
- y2 — FLOAT — NOT NULL
- x2 — FLOAT — NOT NULL
- label — INT
insiders
- insider_id — INT
- insider_name — VARCHAR(20) — NOT NULL
- insider_front_img — MEDIUMBLOB
- insider_phone_num — CHAR(13) — NOT NULL
- register_admin_id — INT
- org_id — INT — NOT NULL
insiders_few_shot_learning_imgs
- insider_id — INT
- insider_front_img1 — MEDIUMBLOB
- insider_front_img2 — MEDIUMBLOB
- insider_front_img3 — MEDIUMBLOB
- insider_left_img1 — MEDIUMBLOB
- insider_left_img2 — MEDIUMBLOB
- insider_right_img1 — MEDIUMBLOB
- insider_right_img2 — MEDIUMBLOB
- insider_upper_img1 — MEDIUMBLOB
- insider_upper_img2 — MEDIUMBLOB
- insider_lower_img1 — MEDIUMBLOB
- insider_lower_img2 — MEDIUMBLOB
orgs
- org_id — INT
- registered_at — TIMESTAMP
records
- record_id — INT
- turret_id — INT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- record_save_location — VARCHAR(255) — NOT NULL
turret_logs
- turret_log_id — INT
- turret_id — INT — NOT NULL
- turret_time — TIMESTAMP
- turret_mode — TINYINT — NOT NULL
- lot_details — VARCHAR(255)
- operator_id — INT
- turret_pan_angle — DOUBLE — NOT NULL
- turret_tilt_angle — DOUBLE — NOT NULL
- joystick_x — DOUBLE — NOT NULL
- joystick_y — DOUBLE — NOT NULL
- joystick_trigger — TINYINT — NOT NULL
- target_id — INT
turrets
- turret_id — INT
- turret_pan_angle — INT — NOT NULL
- turret_tilt_angle — INT — NOT NULL
- turret_location — VARCHAR(20) — NOT NULL
- org_id — INT — NOT NULL