## 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