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 |