Interior_Designers

IDNameAddressEmailPhoneNumberStyle
1John Doe123 Main Stjohn@example.com555-1234Minimalism
2Jane Smith456 Elm Stjane@example.com555-5678Modern

Landscape_Architects

IDNameAddressEmailPhoneNumberStyle
1Michael Johnson987 Oak Stmichael@example.com555-9012Minimalism
2Emily Davis654 Pine Stemily@example.com555-1357Contemporary

Projects

IDDesignerIDArchitectIDTitleLocationStartDateEndDateBudgetStatus
(→ Interior_Designers.ID)(→ Landscape_Architects.ID)
11NoneLiving Room RedesignLos Angeles2022-01-012022-03-3110000.0Completed
2None2Garden PathwaySan Francisco2022-02-012022-04-307500.0In Progress

Materials

IDProjectIDMaterialNameQuantityUnitPrice
(→ Projects.ID)
11Wood Flooring1005.0
22Stone Tiles507.0

Employees

IDNameRoleContactInfo
1Alice BrownInterior Designeralice@example.com
2Bob GreenLandscape Architectbob@example.com

Staffing

IDProjectIDEmployeeIDHoursWorkedPayRate
(→ Projects.ID)(→ Employees.ID)
1114025
2225027