| style_id | style_name |
|---|---|
| 1 | Modern |
| 2 | Contemporary |
| 3 | Traditional |
| 4 | Rustic |
| 5 | Minimalist |
| designer_id | name | design_style |
|---|---|---|
| (→ Style.style_id) | ||
| 1 | John Doe | 1 |
| 2 | Jane Smith | 2 |
| 3 | Michael Johnson | 3 |
| 4 | Emily Davis | 4 |
| 5 | David Brown | 5 |
| architect_id | name | landscape_style |
|---|---|---|
| (→ Style.style_id) | ||
| 1 | Mark Williams | 1 |
| 2 | Laura Wilson | 2 |
| 3 | Thomas Jackson | 3 |
| 4 | Nicholas Taylor | 4 |
| 5 | William Martin | 5 |
| project_id | title | start_date | end_date | interior_designer_id | landscape_architect_id |
|---|---|---|---|---|---|
| (→ Interior_Designer.designer_id) | (→ Landscape_Architect.architect_id) | ||||
| 1 | Living Room Redesign | 2021-07-01 | 2021-09-01 | 1 | 1 |
| 2 | Kitchen Remodel | 2021-08-01 | 2021-10-01 | 2 | 2 |
| 3 | Bathroom Renovation | 2021-06-01 | 2021-08-01 | 3 | 3 |
| 4 | Garden Design | 2021-05-01 | 2021-07-01 | 4 | 4 |
| 5 | Office Space Makeover | 2021-04-01 | 2021-06-01 | 5 | 5 |
| material_id | name | description |
|---|---|---|
| 1 | Wood | High quality hardwood |
| 2 | Stone | Variety of natural stones |
| 3 | Glass | Tempered and laminated glass |
| 4 | Metal | Stainless steel and brass |
| 5 | Textile | Cotton, silk, and wool fabrics |
| projectmaterial_id | project_id | material_id | quantity |
|---|---|---|---|
| (→ Project.project_id) | (→ Material.material_id) | ||
| 1 | 1 | 1 | 50 |
| 2 | 1 | 2 | 25 |
| 3 | 1 | 3 | 10 |
| 4 | 1 | 4 | 20 |
| 5 | 1 | 5 | 30 |