## Projects

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

## Employees

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

## Materials

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

## Tasks

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

## Equipment

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

## Suppliers

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