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