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