| projectID | projectName | startDate | endDate | budget | Project_Manager | Construction_Manager | Edifice |
|---|---|---|---|---|---|---|---|
| 1 | New Office Building | 2023-01-01 | 2023-12-31 | 1000000.0 | John Doe | Jane Smith | High Rise |
| 2 | School Renovation | 2023-02-01 | 2023-11-30 | 800000.0 | Mike Johnson | Lisa Brown | Elementary School |
| 3 | Warehouse Expansion | 2023-03-01 | 2023-12-15 | 750000.0 | Mark Williams | Karen Lee | Industrial Park |
| employeeID | firstName | lastName | jobTitle | salary |
|---|---|---|---|---|
| 1 | Alan | Smith | Carpenter | 60000.0 |
| 2 | Beth | Davis | Electrician | 65000.0 |
| 3 | Charlie | Martin | Plumber | 62000.0 |
| 4 | David | Parker | Site Supervisor | 70000.0 |
| 5 | Eva | Collins | Architect | 90000.0 |
| materialID | name | quantity | unitCost |
|---|---|---|---|
| 1 | Concrete | 100.0 | 50.0 |
| 2 | Steel Rebars | 50.0 | 60.0 |
| 3 | Windows | 150.0 | 150.0 |
| 4 | Doors | 75.0 | 200.0 |
| 5 | Roofing Materials | 100.0 | 80.0 |
| taskID | description | status | startTime | completionTime | assignedEmployeeID |
|---|---|---|---|---|---|
| (→ Employees.employeeID) | |||||
| 1 | Prepare site for construction | In Progress | 2023-01-02 08:00:00 | 2023-01-02 17:00:00 | 1 |
| 2 | Set up temporary office | Completed | 2023-01-03 09:00:00 | 2023-01-03 16:00:00 | 2 |
| 3 | Install electrical system | Not Started | None | None | 3 |
| 4 | Install plumbing | In Progress | 2023-01-04 08:00:00 | 2023-01-04 17:00:00 | 4 |
| 5 | Begin framing of building | In Progress | 2023-01-05 08:00:00 | 2023-01-05 17:00:00 | 5 |
| equipmentID | type | make | model | purchasePrice |
|---|---|---|---|---|
| 1 | Excavator | Caterpillar | 320D | 75000.0 |
| 2 | Crane | Manitowoc | Model 222 | 120000.0 |
| 3 | Forklift | Hyster | FT30-40 | 30000.0 |
| 4 | Scaffolding | Rosendahl | RSC 500 | 10000.0 |
| 5 | Truck | Ford | F-350 | 35000.0 |
| supplierID | companyName | contactName | phoneNumber | address |
|---|---|---|---|---|
| 1 | ABC Concrete | Tom Anderson | 555-123-4567 | 123 Main St, Concrete City |
| 2 | XYZ Steel | Jessica Thomas | 555-789-0123 | 456 Second Ave, Steelville |
| 3 | Window Manufacturers Inc. | George Wilson | 555-321-6540 | 789 Third St, Windowtown |
| 4 | Door Makers Ltd. | Betty Clark | 555-987-6544 | 135 Fourth St, Doorway |
| 5 | Roofing Solutions | Samuel Harris | 555-555-5555 | 987 Fifth St, Roofsville |