t

Tables (5)

Building

  • building_no (Field) — int — Primary key
  • building_name (Field2) — varchar2(200)
  • Field3

Emp

  • emp_no (Field) — varchar2(200) — Primary key
  • emp_id (Field2) — varchar2(200)
  • dept_no (Field3) — int
  • grade_no (Field4) — int
  • building_no (Field5) — int — Foreign key → Building.building_no

Equpment

  • Equpment_no (Field) — int — Primary key
  • Equpment_name (Field2) — varchar2(200)
  • Field3
  • line_no (Field4) — int — Foreign key → Line.line_no

Line

  • line_no (Field) — int — Primary key
  • line_name (Field2) — varchar2(200)
  • Field3
  • building_no (Field4) — int — Foreign key → Building.building_no

Plant

  • Plant_no (Field) — int — Primary key
  • Equpment_name (Field2) — varchar2(200)
  • Line_name (Field3) — varchar2(200)
  • Field4