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