NGL_bluescreen

Tables (9)

Chassis (chassis)

  • Chassis_id (Key) — varchar2(4) — Primary key — NOT NULL
  • Yard_id (id) — varchar2(5) — Foreign key → Yard.Yard_id — NOT NULL
  • Division_name (division_name) — varchar2(3) — Foreign key → Yard.Division_name — NOT NULL
  • Type (type) — varchar2(8)

Container (container)

  • Container_id (container) — varchar2(11) — Primary key — NOT NULL
  • Yard_id (id) — varchar2(5) — Foreign key → Yard.Yard_id — NOT NULL
  • Division_name (division_name) — varchar2(3) — Foreign key → Yard.Division_name — NOT NULL
  • Type (type) — varchar2(8)
  • Size (size) — varchar2(4)

Division (division)

  • Division_id (id) — varchar2(3) — Primary key — NOT NULL
  • Num_yard (num_yard) — int
  • Field

Driver (driver)

  • Driver_id (id) — varchar2(8) — Primary key — NOT NULL
  • Field

I/O_transaction (i/o_transaction)

  • Transaction_id (transaction_id) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

Location (location)

    Trailer (trailer)

    • Trailer_id (trailer_id) — varchar2(10) — Primary key — NOT NULL
    • Yard_id (id2) — varchar2(5) — Foreign key → Yard.Yard_id — NOT NULL
    • Division_name (division_name) — varchar2(3) — Foreign key → Yard.Division_name — NOT NULL
    • Size (size) — varchar2(3)

    Truck (truck)

    • Truck_id (truck_id) — Primary key — NOT NULL
    • Yard_id (id2) — varchar2(5) — Foreign key → Yard.Yard_id — NOT NULL
    • Division_name (division_name) — varchar2(3) — Foreign key → Yard.Division_name — NOT NULL
    • Field

    Yard (yard)

    • Yard_id (id) — varchar2(5) — Primary key — NOT NULL
    • Division_name (division_name) — varchar2(3) — Foreign key → Division.Division_id — NOT NULL
    • Field