Exercise7
Tables (5)
LOANS (Untitled4)
- loanId (Key) — char(5) — Primary key — NOT NULL
- amount (Field) — integer
- payment (Field2) — integer
- projectId (Key2) — char(10) — Foreign key → PROJECT.projectId — NOT NULL
- projectId (Key3) — char(10) — Foreign key → PROJECT.projectId — NOT NULL
PM (Untitled)
- employeeNumber (Key) — char(5) — Primary key — NOT NULL
- name (Field) — char(30)
- phone (Field2) — char(11)
- departmentId (Field3) — char(4)
- gender (Field4) — char(1)
PROJECT (Untitled2)
- projectId (Key) — char(10) — Primary key — NOT NULL
- projectName (Field) — char(30)
- startDate (Field2) — date
- endDate (Field3) — date
- description (Field4) — text
- employeeNumber (Key2) — char(5) — Foreign key → PM.employeeNumber — NOT NULL
- loanId (Key3) — char(5) — Foreign key → LOANS.loanId — NOT NULL
SPECIALIZATION (CopyOfUntitled3)
- specializationCode (Key) — char(5) — Primary key — NOT NULL
- subcontractorId (Key2) — char(5) — Foreign key → SUBCONTRACTORS.subcontractorId — NOT NULL
- specializationName (Field3) — char(30)
SUBCONTRACTORS (Untitled3)
- subcontractorId (Key) — char(5) — Primary key — NOT NULL
- subcontractorName (Field) — char(30)
- specializationCode (Field2) — char(2)
- specializationName (Field3) — char(30)
- projectId (Key2) — char(10) — Foreign key → PROJECT.projectId — NOT NULL