YML
Tables (14)
Division
- Key (Division_ID) — VARCHAR2(10) — Primary key — NOT NULL
- Key (Division_Name) — VARCHAR2(30) — NOT NULL
- Key (Address_ID) — NUMBER(8) — Foreign key → Untitled.Key — NOT NULL
Manager
- Key (User_ID) — VARCHAR2(20) — Foreign key → User.Key — NOT NULL
- department (Position) — VARCHAR(50)
- office_phone (Office_Phone) — VARCHAR(20)
- Key (Division_ID) — VARCHAR2(10) — Foreign key → Division.Key — NOT NULL
Site
- Key (Site_ID) — VARCHAR2(10) — Primary key — NOT NULL
- Key (Yard_ID) — VARCHAR2(30) — Foreign key → Yard.Key — NOT NULL
- Field (Site_Name) — VARCHAR2(30)
- Key (Address_ID) — NUMBER(8) — Foreign key → Untitled.Key — NOT NULL
- Field (y_Cordinate) — NUMBER(8)
- Field (x_Cordinate) — NUMBER(8)
- Field (y_Max_Size) — NUMBER(8)
- Field (x_Max_Size) — NUMBER(8)
Truck
- Key (Truck_ID) — VARCHAR2(10) — Primary key — NOT NULL
- Field (Status) — VARCHAR2(10)
- Key (Zone_ID) — VARCHAR2(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Chassis)
- Key (Chassis_ID) — VARCHAR2(10) — Primary key — NOT NULL
- Field (Status) — VARCHAR2(20)
- Field (Type) — VARCHAR2(20)
- Key (Truck_ID) — VARCHAR2(10) — Foreign key → Truck.Key — NOT NULL
- Key (Zone_ID) — VARCHAR2(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Container)
- Key (Container_ID) — VARCHAR2(10) — Primary key — NOT NULL
- Field (Status) — VARCHAR2(20)
- Field (Type)
- Key (Zone_ID) — VARCHAR2(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Trailer)
- Key (Trailer_ID) — VARCHAR2(10) — Primary key — NOT NULL
- Field (Status) — VARCHAR2(20)
- Field (Type) — VARCHAR2(20)
- Key (Zone_ID) — VARCHAR2(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Address)
- Key (Address_ID) — NUMBER(8) — Primary key — NOT NULL
- Field (House_Number) — VARCHAR2(20)
- Field (Street_Name) — VARCHAR2(20)
- Field (City) — VARCHAR2(20)
- Field (ZipCode) — NUMBER(5)
Untitled (Driver)
- Key (User_ID) — VARCHAR2(20) — Foreign key → User.Key — NOT NULL
- Key (Current_Location) — NUMBER(8) — Foreign key → Untitled.Key — NOT NULL
- Field (Current_Status) — VARCHAR2(20)
- Field (Private_Truck_Info) — VARCHAR2(20)
- Key (Truck_ID) — VARCHAR2(10) — Foreign key → Truck.Key — NOT NULL
Untitled (Tranport_Log)
- Key (Log_ID) — NUMBER(10) — Primary key — NOT NULL
- Key (Driver_ID) — VARCHAR2(20) — Foreign key → Untitled.Key — NOT NULL
- Key (Container_ID) — VARCHAR2(10) — Foreign key → Untitled.Key — NOT NULL
- Key (Chassis_ID) — VARCHAR2(10) — Foreign key → Untitled.Key — NOT NULL
- Key (Truck_ID) — VARCHAR2(10) — Foreign key → Truck.Key — NOT NULL
- Key (Trailer_ID) — VARCHAR2(10) — Foreign key → Untitled.Key — NOT NULL
- Key (Depart_Zone_ID) — VARCHAR2(10) — Foreign key → Untitled.Key — NOT NULL
- Field (Depart_Date) — DATE
- Key (Arrive_Zone_ID) — VARCHAR2(10) — Foreign key → Untitled.Key — NOT NULL
- Field (Arrive_Date) — DATE
- Field (Log_Memo) — VARCHAR2(30)
- Field (Assigned) — BOOLEAN
Untitled (Zone)
- Key (Zone_ID) — VARCHAR2(10) — Primary key — NOT NULL
- Key (Site_ID) — VARCHAR2(10) — Foreign key → Site.Key — NOT NULL
- Field (Status) — VARCHAR2(10)
- Field (Storage_Type) — VARCHAR2(10)
- Field (y_Cordinate) — NUMBER(8)
- Field (x_Cordinate) — NUMBER(8)
Untitled (Password)
- Key (User_ID) — VARCHAR2(20) — Foreign key → User.Key — NOT NULL
- Field (Password) — VARCHAR2(255)
User
- Key (User_ID) — VARCHAR2(20) — Primary key — NOT NULL
- username (UserName) — VARCHAR2(50) — NOT NULL
- email (Email) — VARCHAR2(100)
- role_id (Role_ID) — NUMBER(2)
- Field (Phone_Number) — VARCHAR2(20)
Yard
- Key (Yard_ID) — VARCHAR2(10) — Primary key — NOT NULL
- Key (Division_ID) — VARCHAR2(30) — Foreign key → Division.Key — NOT NULL
- Key (Yard_Name) — VARCHAR2(30) — NOT NULL
- Field (Site_ID) — VARCHAR2(30)
- Key (Address_ID) — NUMBER(8) — Foreign key → Untitled.Key — NOT NULL