CVGM

Tables (12)

camera

  • IP — IP — Primary key — NOT NULL
  • ID — CHAR
  • password — CHAr

checkpoint

  • checkpoint_id — CHAR — Primary key — NOT NULL
  • group_checkpoint_id — CHAR — Foreign key → group_checkpoint.group_checkpoint_id — NOT NULL
  • latitude — FLOAT
  • longitude — FLOAT

group_checkpoint

  • group_checkpoint_id — CHAR — Primary key — NOT NULL
  • group_name — CHAR
  • checkpoint — LIST

guard

  • employee_id — CHAR — Primary key — NOT NULL
  • guard_name — CHAR
  • phone_number — CHAR
  • address — CHAR
  • guard_photo — IMAGE
  • status — BOOL
  • month_work_cnt — INT
  • cur_work_cnt — INT
  • type — CHAR

patrol_time_gps

  • checkpoint_flag — BOOL
  • checkpoint_response — BOOL
  • route_id — CHAR — NOT NULL

patrol_work

  • route_id — CHAR — Foreign key → route.route_id — NOT NULL
  • patrol_time_gps — LIST

route

  • route_id — CHAR — Primary key — NOT NULL
  • route_title — CHAR
  • checkpoint — LIST

station

  • station_id — CHAR — Primary key — NOT NULL
  • IP — IP — Foreign key → camera.IP — NOT NULL
  • station_title — CHAR
  • radius — FLOAT

station_time_gps

  • alarm_flag — BOOL
  • alarm_response — BOOL
  • station_id — CHAR — NOT NULL

station_work

  • station_id — CHAR — Foreign key → station.station_id — NOT NULL
  • station_time_gps — LIST

time_gps

  • time_gps_id — CHAR — Primary key — NOT NULL
  • checkpoint_id — CHAR — Foreign key → checkpoint.checkpoint_id — NOT NULL
  • group_checkpoint_id — CHAR — Foreign key → checkpoint.group_checkpoint_id — NOT NULL
  • time — DATE/TIME
  • latitude — FLOAT
  • longitude — FLOAT
  • checkpoint_flag — BOOL
  • checkpoint_approval — BOOL

time_slot

  • slot_title — CHAR — Primary key — NOT NULL
  • frequency — INT
  • start_time — DATE
  • end_time — DATE