rokkhi_history
Tables (13)
camera
- IP — IP — Primary key — NOT NULL
- ID — CHAR
- password — CHAR
checkpoint
- checkpoint_id — CHAR — Primary key — NOT NULL
- route_id — CHAR — Foreign key → route.route_id — NOT NULL
- latitude — FLOAT
- longitude — FLOAT
- radius — FLOAT
- frequency — INT
device
- device_id — CHAR — Primary key — NOT NULL
- battery — INT
guard
- employee_id — CHAR — Primary key — NOT NULL
- time_slot — CHAR — Foreign key → time_slot.slot_title — NOT NULL
- guard_name — CHAR
- phone_number — CHAR
- address — CHAR
- status — BOOL
- type — CHAR — Patrolling/Stationary
- performance — INT
- month_work_cnt — INT
- cur_work_cnt — INT
patrol_time_gps
- patrol_time_gps_id — CHAR — Primary key — NOT NULL
- time — DATE/TIME
- latitude — FLOAT
- longitude — FLOAT
- checkpoint_flag — BOOL
- checkpoint_response — BOOL
patroll_work
- route_id — CHAR — Foreign key → route.route_id — NOT NULL
- patrol_time_gps — LIST
patrolling_guard
- route — CHAR — Foreign key → route.route_id — NOT NULL
- last_checkpoint — CHAR — Foreign key → checkpoint.checkpoint_id
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
stationary_guard
- station_id — CHAR — Foreign key → station.station_id — NOT NULL
time_slot
- slot_title — CHAR — Primary key — NOT NULL
- start_time — DATE
- end_time — DATE
- frequency — INT
work
- work_id — CHAR — Primary key — NOT NULL
- device_id — CHAR — Foreign key → device.device_id — NOT NULL
- employee_id — CHAR — Foreign key → guard.employee_id — NOT NULL
- slot_title — CHAR — Foreign key → guard.time_slot — NOT NULL
- work_start_time — DATE
- work_end_time — DATE — NOT NULL