id | name | |
---|---|---|
1 | John Smith | johnsmith@example.com |
2 | Jane Doe | janedoe@example.com |
3 | Mike Johnson | mikejohnson@example.com |
4 | Emily Davis | emilydavis@example.com |
5 | David Brown | davidbrown@example.com |
id | name | address |
---|---|---|
1 | ABC Construction | 123 Main St, Anytown, USA |
2 | XYZ Builders | 456 Elm St, Anycity, USA |
3 | PQR Contractors | 789 Oak St, Anothertown, USA |
id | building_name | firm_id | architect_id |
---|---|---|---|
(→ Firm.id) | (→ Architect.id) | ||
1 | Highrise Tower | 1 | 1 |
2 | Residential Complex | 2 | 2 |
3 | Office Building | 3 | 3 |
4 | School Building | 1 | 4 |
5 | Hospital | 2 | 5 |
id | project_name | building_id | start_date | end_date |
---|---|---|---|---|
(→ Building.id) | ||||
1 | Tower Foundation | 1 | 2022-01-01 | 2022-03-31 |
2 | Complex Framework | 2 | 2022-02-01 | 2022-04-30 |
3 | Office Interior | 3 | 2022-03-01 | 2022-05-31 |
4 | School Renovation | 1 | 2022-04-01 | 2022-06-30 |
5 | Hospital Expansion | 2 | 2022-05-01 | 2022-07-31 |
id | material_type | cost |
---|---|---|
1 | Concrete | 100.0 |
2 | Steel | 200.0 |
3 | Glass | 150.0 |
4 | Wood | 50.0 |
5 | Bricks | 75.0 |
id | employee_name | position | firm_id |
---|---|---|---|
(→ Firm.id) | |||
1 | Tom Williams | Project Manager | 1 |
2 | Susan Thompson | Architect | 2 |
3 | Chris Jones | Superintendent | 3 |
4 | Lisa Brown | Engineer | 1 |
5 | Mark Taylor | Electrician | 2 |