construction_styles

97 rows


Description

Linking a phase of construction to one or more architectural styles

Columns

Column Type Size Nulls Auto Default Children Parents Comments
construction_style_id INT 10 √ null

PK. Auto incrementing
construction_id INT 10 null
construction.construction_id construction_styles_ibfk_2 R

FK. Link to construction
style_id INT 10 null
dic_style.style_id construction_styles_ibfk_1 R

FK. Link to dic_style
is_primary_style TINYINT 3 √ NULL

Whether the style is the primary style or a substyle

Indexes

Constraint Name Type Sort Column(s)
construction_styles_s_pk Primary key Asc construction_style_id
idx_construction_style_construction_id Performance Asc construction_id
PRIMARY Must be unique Asc construction_style_id
style_id Performance Asc style_id

Relationships

Close relationships within degrees of separation