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)