Projects

projectIDprojectNamestartDateendDatebudgetProject_ManagerConstruction_ManagerEdifice
1New Office Building2023-01-012023-12-311000000.0John DoeJane SmithHigh Rise
2School Renovation2023-02-012023-11-30800000.0Mike JohnsonLisa BrownElementary School
3Warehouse Expansion2023-03-012023-12-15750000.0Mark WilliamsKaren LeeIndustrial Park

Employees

employeeIDfirstNamelastNamejobTitlesalary
1AlanSmithCarpenter60000.0
2BethDavisElectrician65000.0
3CharlieMartinPlumber62000.0
4DavidParkerSite Supervisor70000.0
5EvaCollinsArchitect90000.0

Materials

materialIDnamequantityunitCost
1Concrete100.050.0
2Steel Rebars50.060.0
3Windows150.0150.0
4Doors75.0200.0
5Roofing Materials100.080.0

Tasks

taskIDdescriptionstatusstartTimecompletionTimeassignedEmployeeID
(→ Employees.employeeID)
1Prepare site for constructionIn Progress2023-01-02 08:00:002023-01-02 17:00:001
2Set up temporary officeCompleted2023-01-03 09:00:002023-01-03 16:00:002
3Install electrical systemNot StartedNoneNone3
4Install plumbingIn Progress2023-01-04 08:00:002023-01-04 17:00:004
5Begin framing of buildingIn Progress2023-01-05 08:00:002023-01-05 17:00:005

Equipment

equipmentIDtypemakemodelpurchasePrice
1ExcavatorCaterpillar320D75000.0
2CraneManitowocModel 222120000.0
3ForkliftHysterFT30-4030000.0
4ScaffoldingRosendahlRSC 50010000.0
5TruckFordF-35035000.0

Suppliers

supplierIDcompanyNamecontactNamephoneNumberaddress
1ABC ConcreteTom Anderson555-123-4567123 Main St, Concrete City
2XYZ SteelJessica Thomas555-789-0123456 Second Ave, Steelville
3Window Manufacturers Inc.George Wilson555-321-6540789 Third St, Windowtown
4Door Makers Ltd.Betty Clark555-987-6544135 Fourth St, Doorway
5Roofing SolutionsSamuel Harris555-555-5555987 Fifth St, Roofsville