example7
Tables (5)
Untitled (Project)
- Key (projectCode) — int(10) — Primary key — NOT NULL
- Key (managerID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Field (title) — char(30)
- Field2 (loanQuantity) — int(2)
Untitled (Loan)
- Key (loanCode) — int(20) — Primary key — NOT NULL
- Key (projectCode) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Field (bank) — char(10)
- Field (title) — char(20)
- Field2 (amount) — int(10)
Untitled (Subcontractor)
- Key (subcontractorCode) — int(20) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (trade) — char(20)
- Field (address) — char(30)
- Field (tel) — int(11)
Untitled (ProjectManager)
- Key (managerID) — int(10) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (department) — char(10
- Field (tel) — int(11)
- Field (address) — char(20)
Untitled (ProjectSubcontractor)
- Key (projectCode) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (subcontractorCode) — int(20) — Foreign key → Untitled.Key — NOT NULL