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