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
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