항만 대기시간

테이블 (4)

AI_Prediction (AI_Prediction Table)

  • predict_id (Key) — INT — 기본 키 — NOT NULL
  • zone_id (Key2) — VARCHAR(10) — 외래 키 → zone.zone_id — NOT NULL
  • wait_time_min (Field) — INT
  • co2_saved_kg (Field2) — FLOAT
  • status (Field3) — VARCHAR(10)
  • timestamp (Field4) — TIMESTAMP

MongoDB

  • _id (Key) — ObjectId — 기본 키 — NOT NULL
  • user_id (Key2) — INT — 외래 키 → user.user_id — NOT NULL
  • location (Field) — GeoJSON
  • sensor_data (Field2) — Object
  • current_zone (Field3) — VARCHAR(10)
  • is_idling (Field4) — BOOLEAN
  • timestamp (Field5) — ISODate

user (user table)

  • user_id (Key) — INT — 기본 키 — NOT NULL
  • vehicle_number (Field) — VARCHAR(20)
  • truck_weight (Field2) — FLOAT
  • created_at (Field3) — DATETIME

zone (zone table)

  • zone_id (Key) — VARCHAR(10) — 기본 키 — NOT NULL
  • user_id (Key2) — INT — 외래 키 → user.user_id — NOT NULL
  • terminal_code (Field) — VARCHAR(20)
  • geom_polygon (Field2) — GEOMETRY
  • capacity (Field3) — INT