CLT

Tables (7)

BERTH (Untitled4)

  • BERTH_CD (Key) — Primary key — NOT NULL
  • SHIP_ID (Key3) — Foreign key → Inventory status.DATE — NOT NULL
  • SDT (Field3) — Foreign key → Dischare_List.SDT
  • EDT (Field5) — Foreign key → Dischare_List.EDT

Demurrage_cost (Untitled5)

  • SHIP_ID (Key4) — Foreign key → Dischare_List.SHIP_ID — NOT NULL
  • ATA (Field)
  • SDT (Field2)
  • Ton (Field3)
  • Item_type (Field4)
  • Lay_const (Field5)
  • BERTH_CD (Field6)
  • A_SDT (Field7)
  • EDT (Field8)
  • alloed_time (Field9)
  • Delay (Field10)
  • actual_time_used (Field11)
  • actual_time_float (Field12)
  • Dem_day (Field13)
  • Dem_rate (Field14)
  • Turn_time (Field15)
  • Dem_cost (Field16)

Dischare_List (Untitled3)

  • SDT (Field) — Primary key
  • EDT (Field5) — Primary key
  • ATA (Key22) — Foreign key → Vessel.ATA — NOT NULL
  • SHIP_ID (Key4) — Foreign key → Vessel.SHIP_ID — NOT NULL
  • TIDE (Key) — Foreign key → TIDE_TIME.TIDE — NOT NULL
  • d_rate (Field42) — Foreign key → Discharge_rate.d_rate
  • BERTH_CD (Field3) — Foreign key → Discharge_rate.BERTH_CD
  • Ton (Field2)
  • W_time (Field4)
  • work_time (Field6)

Discharge_rate (Untitled6)

  • d_rate (Field4) — Primary key
  • BERTH_CD (Field3) — Primary key
  • V_SIZE (Field)
  • Item_type (Field2)

Inventory status (Untitled7)

  • Item_type (Key) — Primary key — NOT NULL
  • DATE (Key3) — Foreign key → Vessel.SHIP_ID — NOT NULL
  • Item_group (Field)
  • Ton_group (Field2)
  • base_group (Field3)
  • use_group (Field4)
  • min_group (Field5)
  • max_group (Field6)

TIDE_TIME (Untitled2)

  • TIDE (Key) — Primary key — NOT NULL
  • ATA (Key22) — Foreign key → Vessel.ATA — NOT NULL
  • High_tide (Field)
  • Start (Field2)
  • End (Field3)
  • From (Field4)
  • Occupied (Field5)

Vessel (Untitled)

  • SHIP_ID (Key) — Primary key — NOT NULL
  • ATA (Key2) — Primary key — NOT NULL
  • V_SIZE (Field)
  • Item_type (Field2)
  • Ton (Field3)
  • Lay_const (Field4)
  • Dem_rate (Field5)
  • Turn_time (Field6)
  • Item_group (Field7)
  • Ton_group (Field8)