irir

Tables (15)

camera (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • type (Field2)
  • center_x (Field4)
  • center_y (Field5)
  • size_x (Field6)
  • size_y (Field7)
  • floor_id (Key2) — Foreign key → floor.id — NOT NULL

component

  • id (Key) — Primary key — NOT NULL
  • arrow (Field)
  • criteria (Field2)
  • name (Field3)
  • state_color (Field4)
  • type (Field5)
  • eboard_id (Key2) — Foreign key → eboard.id — NOT NULL

component_parkinglot_group (Untitled13)

  • component_id (Key2) — Foreign key → component.id — NOT NULL
  • lot_group_id (Key) — Foreign key → lot_group.id — NOT NULL

composer (Untitled11)

  • id (Key) — Primary key — NOT NULL
  • ipaddr (Field)
  • name (Field2)

composer_floors (Untitled12)

  • floor_id (Key) — Foreign key → floor.id — NOT NULL
  • composer_id (Key2) — Foreign key → composer.id — NOT NULL

eboard (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • type (Field2)
  • notice (Field3)
  • both_sides (Field5)
  • ip_address (Field6)
  • floor_id (Key2) — Foreign key → floor.id — NOT NULL
  • h (Field7)
  • w (Field8)
  • x (Field9)
  • y (Field10)
  • rot (Field11)

floor (Floor)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • parking_space_count (Field2)
  • image_url (Field3)
  • download_url (Field4)
  • x (Field5)
  • y (Field6)

lot_group (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • floor_id (Key2) — Foreign key → floor.id — NOT NULL

parkinglot (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • status (Field2)
  • type (Field3)
  • vehicle_id (Field5)
  • parking_time_in (Field6)
  • parking_time_out (Field7)
  • lt_x (Field8)
  • lt_y (Field9)
  • lb_x (Field10)
  • lb_y (Field11)
  • rb_x (Field12)
  • rb_y (Field13)
  • rt_x (Field14)
  • rt_y (Field15)
  • lpr (Field16)
  • floor_id (Key2) — Foreign key → floor.id — NOT NULL

parkinglot_group (Untitled9)

  • lot_group_id (Key) — Foreign key → lot_group.id — NOT NULL
  • parkinglot_id (Key2) — Foreign key → parkinglot.id — NOT NULL

poi (Untitled4)

  • poi_id (Key) — Primary key — NOT NULL
  • floor_id (Key2) — Foreign key → floor.id — NOT NULL
  • name (Field)
  • type (Field4)
  • h (Field5)
  • w (Field6)
  • x (Field7)
  • y (Field8)
  • rot (Field9)
  • used (Field2)

poi_detail (Untitled6)

  • poidetail_id (Key) — Foreign key → poi.poi_id — NOT NULL
  • parkinglot_id (Key2) — Foreign key → parkinglot.id — NOT NULL
  • eboard_id (Key3) — Foreign key → eboard.id — NOT NULL
  • camera_id (Key4) — Long — Foreign key → camera.id — NOT NULL

rled (Untitled10)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • state (Field2)

user (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • accountId (Field)
  • password (Field2)
  • name (Field3)
  • phone (Field4)
  • grade (Field5)

vehicle (Untitled2)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3