metadata_love_relationships


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
account_id INT UNSIGNED 10 null
accounts.id metadata_love_relationships_account_id_foreign C
relationship_id INT UNSIGNED 10 null
relationships.id metadata_love_relationships_relationship_id_foreign C
is_active BIT 1 null
notes MEDIUMTEXT 16777215 √ null
meet_date DATETIME 19 √ null
official_date DATETIME 19 √ null
breakup_date DATETIME 19 √ null
breakup_reason MEDIUMTEXT 16777215 √ null
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
metadata_love_relationships_account_id_foreign Performance Asc account_id
metadata_love_relationships_relationship_id_foreign Performance Asc relationship_id

Relationships

Close relationships within degrees of separation