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