Freight
Tables (5)
companies (Untitled2)
- id (Key) — Primary key — NOT NULL
- Field
countries (Untitled4)
- Key — Primary key — NOT NULL
- Field
ocean_freight_factors (운임에 영향을 주는 요인들)
- id (Key) — auto_increment — Primary key — NOT NULL
- 수에즈 운하 통행량 (Field) — int
- 파나마 운하 통행량 (Field2) — int
- 호르무즈 해협 통행량 (Field3) — int
- 말라카 해협 통행량 (Field4) — int
- 벙커유 가격 (Field6) — decmial
- 날짜 (Field5) — Date
ocean_freights (운임정보)
- id (Field1) — auto_increment — Primary key — NOT NULL
- SHIPLINE_ID (Key) — int — Foreign key → companies.id — NOT NULL
- ETD (출발 일자) (Field) — Date
- CONTAINER_TYPE (Field6) — string(enum)
- POL_ID (Key2) — int — Foreign key → ports.Key — NOT NULL
- POD_ID (Key3) — int — Foreign key → ports.Key — NOT NULL
- FREIGHT($) (Field11) — decimal
ports (Untitled3)
- Key — Primary key — NOT NULL
- Field
- country_id (Key2) — Foreign key → countries.Key — NOT NULL