exe7
Tables (8)
ABC development corp (Untitled)
- commercial building (Key) — int — Primary key — NOT NULL
- project number (Field) — char(10)
Heating (Untitled7)
- ID (Key) — int — Primary key — NOT NULL
- name (Field) — char(5)
- phone (Field2) — char(5)
- work no (Key3) — int — Foreign key → Work category.work no — NOT NULL
Loan (Untitled5)
- loan number (Key) — int — Primary key — NOT NULL
- loan amount (Field) — char(10)
- loan payment (Field2) — char(10)
- project no (Key2) — int — Foreign key → Project.project no — NOT NULL
Plumping (Untitled8)
- ID (Key) — int — Primary key — NOT NULL
- name (Field) — char(5)
- pdone (Field2) — char(5)
- work no (Key3) — int — Foreign key → Work category.work no — NOT NULL
Projecrt manager (Untitled2)
- employee ID (Key2) — int — Primary key — NOT NULL
- manager name (Field) — char(10)
- manager phone (Field2) — char(10)
- manager add (Field3) — char(10)
- project no (Key) — int — Foreign key → Project.project no — NOT NULL
Project (Untitled6)
- project no (Key) — int — Primary key — NOT NULL
- project name (Field) — char(20)
- description (Field2) — text
- commercial building (Key2) — int — Foreign key → ABC development corp.commercial building — NOT NULL
Subcontactor (Untitled3)
- subcontractor ID (Key) — int — Primary key — NOT NULL
- subcontractor item (Field2) — int — Primary key
- subcontractor name (Field) — char(20)
- subcontractor phone (Field3) — char(20)
- subcontractor add (Field4) — char(20)
- project no (Key2) — int — Foreign key → Project.project no — NOT NULL
- employee ID (Key22) — int — Foreign key → Projecrt manager.employee ID — NOT NULL
Work category (Untitled4)
- work no (Key3) — int — Primary key — NOT NULL
- project no (Key) — int — Foreign key → Project.project no — NOT NULL
- employee ID (Key2) — int — Foreign key → Projecrt manager.employee ID — NOT NULL