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