database
Tables (7)
DEPARTMENT (Untitled6)
- Deptno (Key) — Primary key — NOT NULL
- Empno (Key2) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key22) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key222) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key3) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key23) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key2222) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key22222) — Foreign key → Empno.Empno — NOT NULL
- Depname (Key4) — Foreign key → Empno.Depname — NOT NULL
- Empno (Key24) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key223) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key2223) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key32) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key232) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key222222) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key2222222) — Foreign key → Empno.Empno — NOT NULL
- Depname (Key42) — Foreign key → Empno.Depname — NOT NULL
- Deptno (Key5) — Foreign key → Empno.Deptno — NOT NULL
- Empno (Key25) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key224) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key2224) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key33) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key233) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key22223) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key222223) — Foreign key → Empno.Empno — NOT NULL
- Depname (Key43) — Foreign key → Empno.Depname — NOT NULL
- Empno (Key242) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key2232) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key22232) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key322) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key2322) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key22222222) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key222222222) — Foreign key → Empno.Empno — NOT NULL
- Depname (Key422) — Foreign key → Empno.Depname — NOT NULL
- Depname (Field)
- Floor (Field2)
DEPENDENT (Untitled5)
- Depname (Key) — Primary key — NOT NULL
- Empno (Key2) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key22) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key222) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key3) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key23) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key2222) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key22222) — Foreign key → Empno.Empno — NOT NULL
- Depname (Key4) — Foreign key → Empno.Depname — NOT NULL
- Deptno (Key5) — Foreign key → Empno.Deptno — NOT NULL
- Empno (Key25) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key224) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key2224) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key33) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key233) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key22223) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key222223) — Foreign key → Empno.Empno — NOT NULL
- Depname (Key43) — Foreign key → Empno.Depname — NOT NULL
- Empno (Key242) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key2232) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key22232) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key322) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key2322) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key2222222) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key22222222) — Foreign key → Empno.Empno — NOT NULL
- Depname (Key422) — Foreign key → Empno.Depname — NOT NULL
- Field
Empno (Untitled)
- Empno (Key) — Primary key — NOT NULL
- projectno (Key2) — Foreign key → Project.projectno — NOT NULL
- Empno (Key22) — Foreign key → Project.Empno — NOT NULL
- projectno (Key3) — Foreign key → Project(1).projectno — NOT NULL
- Empno (Key23) — Foreign key → Project(1).Empno — NOT NULL
- projectno (Key222) — Foreign key → Project(1).projectno — NOT NULL
- Empno (Key2222) — Foreign key → Project(1).Empno — NOT NULL
- Depname (Key4) — Foreign key → DEPENDENT.Depname — NOT NULL
- Empno (Key24) — Foreign key → DEPENDENT.Empno — NOT NULL
- projectno (Key223) — Foreign key → DEPENDENT.projectno — NOT NULL
- Empno (Key2223) — Foreign key → DEPENDENT.Empno — NOT NULL
- projectno (Key32) — Foreign key → DEPENDENT.projectno — NOT NULL
- Empno (Key232) — Foreign key → DEPENDENT.Empno — NOT NULL
- projectno (Key22222) — Foreign key → DEPENDENT.projectno — NOT NULL
- Empno (Key222222) — Foreign key → DEPENDENT.Empno — NOT NULL
- Depname (Key42) — Foreign key → DEPENDENT.Depname — NOT NULL
- Deptno (Key5) — Foreign key → DEPARTMENT.Deptno — NOT NULL
- Empno (Key25) — Foreign key → DEPARTMENT.Empno — NOT NULL
- projectno (Key224) — Foreign key → DEPARTMENT.projectno — NOT NULL
- Empno (Key2224) — Foreign key → DEPARTMENT.Empno — NOT NULL
- projectno (Key33) — Foreign key → DEPARTMENT.projectno — NOT NULL
- Empno (Key233) — Foreign key → DEPARTMENT.Empno — NOT NULL
- projectno (Key22223) — Foreign key → DEPARTMENT.projectno — NOT NULL
- Empno (Key222223) — Foreign key → DEPARTMENT.Empno — NOT NULL
- Depname (Key43) — Foreign key → DEPARTMENT.Depname — NOT NULL
- Empno (Key242) — Foreign key → DEPARTMENT.Empno — NOT NULL
- projectno (Key2232) — Foreign key → DEPARTMENT.projectno — NOT NULL
- Empno (Key22232) — Foreign key → DEPARTMENT.Empno — NOT NULL
- projectno (Key322) — Foreign key → DEPARTMENT.projectno — NOT NULL
- Empno (Key2322) — Foreign key → DEPARTMENT.Empno — NOT NULL
- projectno (Key2222222) — Foreign key → DEPARTMENT.projectno — NOT NULL
- Empno (Key22222222) — Foreign key → DEPARTMENT.Empno — NOT NULL
- Depname (Key422) — Foreign key → DEPARTMENT.Depname — NOT NULL
- Empname (Field)
- Title (Field2)
- Salary (Field3)
- Address (City) — Dong
Part (Untitled4)
- Partno (Key) — Primary key — NOT NULL
- Partname (Field)
- Price (Field2)
Project (Untitled2)
- projectno (Key) — Primary key — NOT NULL
- Empno (Key2) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key22) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key222) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key3) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key23) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key2222) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key22222) — Foreign key → Empno.Empno — NOT NULL
- Depname (Key4) — Foreign key → Empno.Depname — NOT NULL
- Empno (Key24) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key223) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key2223) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key32) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key232) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key222222) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key2222222) — Foreign key → Empno.Empno — NOT NULL
- Depname (Key42) — Foreign key → Empno.Depname — NOT NULL
- Deptno (Key5) — Foreign key → Empno.Deptno — NOT NULL
- Empno (Key25) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key224) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key2224) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key33) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key233) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key22223) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key222223) — Foreign key → Empno.Empno — NOT NULL
- Depname (Key43) — Foreign key → Empno.Depname — NOT NULL
- Empno (Key242) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key2232) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key22232) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key322) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key2322) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key22222222) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key222222222) — Foreign key → Empno.Empno — NOT NULL
- Depname (Key422) — Foreign key → Empno.Depname — NOT NULL
- projname (Field)
- Budget (Field2)
- Location (Field3)
Project(1) (Untitled7)
- projectno (Key) — Primary key — NOT NULL
- Empno (Key2) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key22) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key222) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key3) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key23) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key2222) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key22222) — Foreign key → Empno.Empno — NOT NULL
- Depname (Key4) — Foreign key → Empno.Depname — NOT NULL
- Empno (Key24) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key223) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key2223) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key32) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key232) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key222222) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key2222222) — Foreign key → Empno.Empno — NOT NULL
- Depname (Key42) — Foreign key → Empno.Depname — NOT NULL
- Deptno (Key5) — Foreign key → Empno.Deptno — NOT NULL
- Empno (Key25) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key224) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key2224) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key33) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key233) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key22223) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key222223) — Foreign key → Empno.Empno — NOT NULL
- Depname (Key43) — Foreign key → Empno.Depname — NOT NULL
- Empno (Key242) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key2232) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key22232) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key322) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key2322) — Foreign key → Empno.Empno — NOT NULL
- projectno (Key22222222) — Foreign key → Empno.projectno — NOT NULL
- Empno (Key222222222) — Foreign key → Empno.Empno — NOT NULL
- Depname (Key422) — Foreign key → Empno.Depname — NOT NULL
- Empno (Field)
- projectno (Field2)
- Empno (Field3)
- projectname (Field4)
- Budget (Field5)
- Location (Field6)
SUPPLIER (Untitled3)
- Suppno (Key) — Primary key — NOT NULL
- Suppname (Field)
- Credit (Field2)