person_relationship

175 rows


Description

Linking people to other people e.g. parents/children

Columns

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

PK. Autoincrementing integer.
person_id1 INT 10 null
person.person_id person_relationship_ibfk_1 R

FK. First person.
person_id2 INT 10 null
person.person_id person_relationship_ibfk_2 R

FK. Second person.
relationship_id INT 10 null
dic_relationship.relationship_id person_relationship_ibfk_3 R

FK. Relationship type, link to dic_relationship
relationship_notes TEXT 65535 √ NULL

Notes about the relationship.
documentary_sources TEXT 65535 √ NULL

Documentary sources about the relationship
entered_by VARCHAR 250 √ NULL

Person who entered the initial record
entered_date DATE 10 √ current_timestamp()
modified_by VARCHAR 250 √ NULL
modified_date DATETIME 19 √ NULL

Indexes

Constraint Name Type Sort Column(s)
person_relationship_s_pk Primary key Asc person_relationship_id
person_id1 Performance Asc person_id1
person_id2 Performance Asc person_id2
PRIMARY Must be unique Asc person_relationship_id
relationship_id Performance Asc relationship_id

Relationships

Close relationships within degrees of separation