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