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