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 |