Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| person_construction_id | INT | 10 | √ | null |
|
|
PK. Auto incrementing |
||||
| construction_id | INT | 10 | null |
|
|
FK. Link to construction. |
|||||
| person_id | INT | 10 | null |
|
|
FK. Link to person. |
|||||
| role_id | INT | 10 | √ | NULL |
|
|
FK. Link to dic_role. |
||||
| is_primary | TINYINT | 3 | √ | 0 |
|
|
Whether this person is one of the primary examples of this role. Controls order of appearance on website for architects specifically (primary architects vs. other architects). Default is FALSE. |
||||
| person_construction_desc | TEXT | 65535 | √ | NULL |
|
|
Notes about the link between person and construction which can be made public (but currently not exposed on the website). This column contains some notes from the original STONEBUILT spreadsheet. |
||||
| documentary_sources | TEXT | 65535 | √ | NULL |
|
|
References that link this person to this construction phase |
||||
| name_verbatim | TEXT | 65535 | √ | NULL |
|
|
Name of the person as originally reported - could be a variation of the version in the person table. |
||||
| notes | TEXT | 65535 | √ | NULL |
|
|
Other relevant notes for internal use only. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| person_construction_s_pk | Primary key | Asc | person_construction_id |
| person_construction_construction_fk | Performance | Asc | construction_id |
| person_construction_role_fk | Performance | Asc | role_id |
| person_id | Performance | Asc | person_id |
| PRIMARY | Must be unique | Asc | person_construction_id |
Relationships
Close relationships within degrees of separation
