ex7

Tables (6)

Project_Subcontractor (Untitled6)

  • PSid (Key) — char(13) — Primary key — NOT NULL
  • workdate (Field) — date
  • hour (Field2) — integer
  • projectid (Key2) — char(13) — Foreign key → project.projectid — NOT NULL
  • subcontractorid (Key3) — char(13) — Foreign key → subcontractor.subcontractorid — NOT NULL

loan (Untitled5)

  • loanid (Key) — char(13) — Primary key — NOT NULL
  • institution (Field) — char(10)
  • amount (Field2) — integer
  • paymentamount (Field5) — integer
  • interest rate (Field3) — char(10)
  • expire (Field4) — date
  • projectid (Key2) — char(13) — Foreign key → project.projectid — NOT NULL

project (Untitled3)

  • projectid (Key) — char(13) — Primary key — NOT NULL
  • description (Field) — text
  • startdate (Field2) — date
  • budget (Field3) — integer
  • pmid (Key2) — char(13) — Foreign key → project manager.pmid — NOT NULL

project manager (Untitled)

  • pmid (Key) — char(13) — Primary key — NOT NULL
  • name (Field) — char(10)
  • phone (Field2) — char(11)
  • address (Field3) — text

specialization (Untitled4)

  • specialization id (Key) — char(13) — Primary key — NOT NULL
  • work (Field) — char(10)
  • description (Field2) — text

subcontractor (Untitled2)

  • subcontractorid (Key) — char(13) — Primary key — NOT NULL
  • skill level (Field) — char(10)
  • agency (Field3) — char(10)
  • phone (Field4) — char(11)
  • address (Field5) — text
  • description (Field2) — text
  • specialization id (Key2) — char(13) — Foreign key → specialization.specialization id — NOT NULL