Interior_Designers
ID | Name | Address | Email | PhoneNumber | Style |
1 | John Doe | 123 Main St | john@example.com | 555-1234 | Minimalism |
2 | Jane Smith | 456 Elm St | jane@example.com | 555-5678 | Modern |
Landscape_Architects
ID | Name | Address | Email | PhoneNumber | Style |
1 | Michael Johnson | 987 Oak St | michael@example.com | 555-9012 | Minimalism |
2 | Emily Davis | 654 Pine St | emily@example.com | 555-1357 | Contemporary |
Projects
ID | DesignerID | ArchitectID | Title | Location | StartDate | EndDate | Budget | Status |
| (→ Interior_Designers.ID) | (→ Landscape_Architects.ID) | | | | | | |
1 | 1 | None | Living Room Redesign | Los Angeles | 2022-01-01 | 2022-03-31 | 10000.0 | Completed |
2 | None | 2 | Garden Pathway | San Francisco | 2022-02-01 | 2022-04-30 | 7500.0 | In Progress |
Materials
ID | ProjectID | MaterialName | Quantity | UnitPrice |
| (→ Projects.ID) | | | |
1 | 1 | Wood Flooring | 100 | 5.0 |
2 | 2 | Stone Tiles | 50 | 7.0 |
Employees
ID | Name | Role | ContactInfo |
1 | Alice Brown | Interior Designer | alice@example.com |
2 | Bob Green | Landscape Architect | bob@example.com |
Staffing
ID | ProjectID | EmployeeID | HoursWorked | PayRate |
| (→ Projects.ID) | (→ Employees.ID) | | |
1 | 1 | 1 | 40 | 25 |
2 | 2 | 2 | 50 | 27 |