Ocean Freight Booking Schema

erDiagram
  SHIPPER ||--o{ BOOKING : makes
  VESSEL ||--o{ VOYAGE : sails
  VOYAGE ||--o{ BOOKING : carries
  PORT ||--o{ BOOKING : "loads at"
  BOOKING ||--|{ CONTAINER : includes
  CONTAINER ||--o{ TRACKING_EVENT : has
  BOOKING ||--o| BILL_OF_LADING : "documented by"
  SHIPPER {
    int id PK
    string name
    string gstin
  }
  VESSEL {
    int id PK
    string name
    string imo_number
  }
  VOYAGE {
    int id PK
    int vessel_id FK
    string voyage_no
    date departure
  }
  PORT {
    int id PK
    string code
    string name
  }
  BOOKING {
    int id PK
    int shipper_id FK
    int voyage_id FK
    int origin_port_id FK
    int dest_port_id
    string status
  }
  CONTAINER {
    int id PK
    int booking_id FK
    string container_no
    string size_type
    decimal weight
  }
  TRACKING_EVENT {
    int id PK
    int container_id FK
    string event
    string location
    datetime event_time
  }
  BILL_OF_LADING {
    int id PK
    int booking_id FK
    string bl_number
    date issued_on
  }