FirmID | Name | Address |
---|---|---|
1 | ABC Construction | 123 Main St |
2 | XYZ Development | 456 Elm St |
3 | PQR Builders | 789 Oak St |
4 | MNO Homes | 000 Maple Ave |
5 | LMN Contractors | 321 Pine St |
TypeID | Description |
---|---|
1 | Single Family Residential |
2 | Multi-Family Residential |
3 | Commercial |
4 | Industrial |
5 | Retail |
6 | Custom Home |
FirmID | TypeID |
---|---|
(→ Design_Build_Firms.FirmID) | (→ Project_Types.TypeID) |
1 | 6 |
2 | 6 |
3 | 6 |
4 | 6 |
5 | 6 |
5 | 1 |