mm
Tables (5)
DEPARTMEN LOCATION (Untitled4)
- DEPNO (INT(2)) — Primary key — NOT NULL
- LOCNO (CHAR(2)) — Primary key — NOT NULL
DEPARTMENT (Untitled2)
- DEPNO. (Key) — INT(2)) — Primary key — NOT NULL
- NAME (Key2) — CHAR(20) — Primary key — NOT NULL
- LOCATION (Key3) — CHAR(30) — Primary key — NOT NULL
- EMPNO. (Key4) — INT(6) — Foreign key → EMPOLYEE.EMPNO. — NOT NULL
- NAME (Key22) — CHAR(15) — Foreign key → EMPOLYEE.NAME — NOT NULL
- BIRTH (Key32) — DATE — Foreign key → EMPOLYEE.BIRTH — NOT NULL
- GENDER (Key42) — CHAR(1) — Foreign key → EMPOLYEE.GENDER — NOT NULL
- DEPNO. (Key6) — INT(2)) — Foreign key → EMPOLYEE.DEPNO. — NOT NULL
- NAME (Key23) — CHAR(20) — Foreign key → EMPOLYEE.NAME — NOT NULL
- LOCATION (Key33) — CHAR(30) — Foreign key → EMPOLYEE.LOCATION — NOT NULL
- DEPNO (INT(2)) — Foreign key → DEPARTMEN LOCATION.DEPNO — NOT NULL
- LOCNO (CHAR(2)) — Foreign key → DEPARTMEN LOCATION.LOCNO — NOT NULL
- MANAGERNO (Field) — CHAR(6)
- MANAGERSTARTDATE (Field2) — CHAR(13)
EMPOLYEE (Untitled)
- EMPNO. (Key) — INT(6) — Primary key — NOT NULL
- NAME (Key2) — CHAR(15) — Primary key — NOT NULL
- BIRTH (Key3) — DATE — Primary key — NOT NULL
- GENDER (Key4) — CHAR(1) — Primary key — NOT NULL
- DEPNO. (Key6) — INT(2)) — Foreign key → DEPARTMENT.DEPNO. — NOT NULL
- NAME (Key23) — CHAR(20) — Foreign key → DEPARTMENT.NAME — NOT NULL
- LOCATION (Key33) — CHAR(30) — Foreign key → DEPARTMENT.LOCATION — NOT NULL
- EMPNO. (Key43) — INT(6) — Foreign key → DEPARTMENT.EMPNO. — NOT NULL
- NAME (Key222) — CHAR(15) — Foreign key → DEPARTMENT.NAME — NOT NULL
- BIRTH (Key322) — DATE — Foreign key → DEPARTMENT.BIRTH — NOT NULL
- GENDER (Key422) — CHAR(1) — Foreign key → DEPARTMENT.GENDER — NOT NULL
- DEPNO. (Key63) — INT(2)) — Foreign key → DEPARTMENT.DEPNO. — NOT NULL
- NAME (Key233) — CHAR(20) — Foreign key → DEPARTMENT.NAME — NOT NULL
- LOCATION (Key333) — CHAR(30) — Foreign key → DEPARTMENT.LOCATION — NOT NULL
- DEPNO (INT(2)) — Foreign key → DEPARTMENT.DEPNO — NOT NULL
- LOCNO (CHAR(2)) — Foreign key → DEPARTMENT.LOCNO — NOT NULL
- SUPERVISIOR (Field5) — INT(6)
- ADDRESS (Field) — CHAR(50)
- DEPNO (Field2) — INT(2)
- PHONE (Field3) — CHAR(11)
- EMAIL (Field4) — CHAR(30)
- SUPERVISIOR (Key5) — INT(6) — Foreign key → EMPOLYEE.EMPNO. — NOT NULL
- NAME (Key22) — CHAR(15) — Foreign key → EMPOLYEE.NAME — NOT NULL
- BIRTH (Key32) — DATE — Foreign key → EMPOLYEE.BIRTH — NOT NULL
- GENDER (Key42) — CHAR(1) — Foreign key → EMPOLYEE.GENDER — NOT NULL
- DEPNO. (Key62) — INT(2)) — Foreign key → EMPOLYEE.DEPNO. — NOT NULL
- NAME (Key232) — CHAR(20) — Foreign key → EMPOLYEE.NAME — NOT NULL
- LOCATION (Key332) — CHAR(30) — Foreign key → EMPOLYEE.LOCATION — NOT NULL
LOCATION (Untitled3)
- LOCNO (NAME) — CHAR(3) — Primary key — NOT NULL
- NAME (Field) — CHAR(30)
- DESCIPTION (Field2) — TXT
PROJECT (Untitled5)
- PRONO (Key) — Primary key — NOT NULL
- NAME (CHAR(50))
- STARTDATE (DATE)
- ENDDATE (Field3)
- DEPNO (Field4)