rokkhi_day
Tables (9)
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
- guard_name — CHAR
- phone_number — CHAR
- address — CHAR
- guard_photo — IMAGE
- status — BOOL
- month_work_cnt — INT
- cur_work_cnt — INT
- type — CHAR
patrol_work
- route_id — CHAR — Foreign key → route.route_id — NOT NULL
- checkpoint_cnt — LIST
route
- route_id — CHAR — Primary key — NOT NULL
- route_title — CHAR
- checkpoint — LIST
station
- station_id — CHAR — Primary key — NOT NULL
- station_title — CHAR
- radius — FLOAT
station_work
- station_id — CHAR — Foreign key → station.station_id — NOT NULL
- response_list — LIST
time_slot
- slot_title — CHAR — Primary key — NOT NULL
- frequency — INT
- start_time — DATE
- end_time — DATE
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
- time_slot — CHAR — Foreign key → time_slot.slot_title — NOT NULL
- work_start_time — DATE
- work_end_time — DATE — NOT NULL