항만 대기시간
테이블 (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