Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| person_title_id | INT | 10 | √ | null |
|
|
PK. Autoincrementing |
||||
| person_id | INT | 10 | null |
|
|
FK. Link to person table |
|||||
| title_id | INT | 10 | null |
|
|
FK. Link to dic_title. |
|||||
| start_date | INT | 10 | √ | NULL |
|
|
Year when the person was first associated with the title |
||||
| end_date | INT | 10 | √ | NULL |
|
|
Year when the person was last associated with the title |
||||
| title_number | INT | 10 | √ | NULL |
|
|
If the title has a number, e.g. 1st Earl of Mayo, enter position here (as an integer). |
||||
| title_location | VARCHAR | 250 | √ | NULL |
|
|
If the title is tied to a place e.g. Earl of Mayo, then enter the place name here. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| person_title_s_pk | Primary key | Asc | person_title_id |
| person_person_title_fk | Performance | Asc | person_id |
| PRIMARY | Must be unique | Asc | person_title_id |
| title_person_title_fk | Performance | Asc | title_id |
Relationships
Close relationships within degrees of separation
