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