nask
Tables (11)
device_antenna (Untitled)
- id — int — Primary key — NOT NULL
- type (Field)
- nickname (Field2)
device_beacon (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- Field
device_detection_status (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- antenna_id (id) — int — Foreign key → device_antenna.id — NOT NULL
- beacon_id (Key2) — int — Foreign key → device_beacon.id — NOT NULL
- last_in_at (Field) — time
- last_out_at (Field2)
office (Untitled4)
- id (Key) — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- admin_name (Field) — varchar
- user_id (Field2) — int
- Field3
office_classroom (Untitled6)
- id (Key) — int — Primary key — NOT NULL
- office_id (Key22) — int — Foreign key → office.user_id — NOT NULL
- name (Field) — varcar
parents (Untitled7)
- id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — int — Foreign key → user.id — NOT NULL
- name (Field)
parents_child (Untitled8)
- id (Key) — int — Primary key — NOT NULL
- beacon_id (Key2) — int — Foreign key → device_beacon.id — NOT NULL
- parents_id (Key3) — int — Foreign key → parents.id — NOT NULL
parents_child_sch (Untitled9)
- id (Key) — int — Primary key — NOT NULL
- child_id — int — Foreign key → parents_child.id — NOT NULL
- office_id (Key2) — int — Foreign key → office.id — NOT NULL
- classroom_id (Key3) — int — Foreign key → office_classroom.id — NOT NULL
- go_v_schedule_id (Key4) — int — Foreign key → vehicle_sch.id — NOT NULL
- leave_v_schedule_id (Field) — int
- leave_type (Field2) — enum
- go_type (Field3) — enum
user (Untitled5)
- id (Key) — int — Primary key — NOT NULL
- role (Field)
- email (Field2) — varchar
- password (Field3) — varchar
- access_key (Field4) — varchar
vehicle (Untitled10)
- id (Key) — int — Primary key — NOT NULL
- antenna_id (id) — int — Foreign key → device_antenna.id — NOT NULL
- latitude (Field) — decimal
- longitude (Field2) — decimal
vehicle_sch (Untitled11)
- id (Key) — int — Primary key — NOT NULL
- vehicle_id (Key2) — int — Foreign key → vehicle.id — NOT NULL
- office_id (Key3) — int — Foreign key → office.id — NOT NULL