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