parking
Tables (5)
floor
- id — int unsigned — Primary key — NOT NULL — auto_increment
- 이름 (name) — varchar(20)
- 층 이미지 경로 (image_map_path) — varchar(255) — NOT NULL
- 주차장 ID (area_id) — int unsigned — Foreign key → parking_area.id — NOT NULL
image
- Key (id) — bigint unsigned — Primary key — NOT NULL
- Field (path) — varchar(255) — NOT NULL
- Key (notification_id) — bigint unsigned — Foreign key → notification.Key — NOT NULL
notification
- Key (id) — bigint unsigned — Primary key — NOT NULL — auto_increment
- Field (state) — tinyint unsigned — default 2
- Field (category) — tinyint unsigned — NOT NULL
- Field (timestamp) — timestamp — NOT NULL
- id (sensor_id) — bigint unsigned — Foreign key → sensor.id — NOT NULL
parking_area (parking_lot)
- id — int unsigned — Primary key — NOT NULL — auto_increment
- 이름 (name) — varchar(255)
- Field (address) — varchar(255)
sensor
- id — bigint unsigned — Primary key — NOT NULL — auto_increment
- Field (sensor_state) — tinyint(1) — NOT NULL — default 0
- Field2 (sensor_connected) — tinyint(1) — NOT NULL
- Field (sensor_coord) — varchar(255) — NOT NULL
- id (floor_id) — int unsigned — Foreign key → floor.id — NOT NULL