emotions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
emotion_activity.emotion_id emotion_activity_emotion_id_foreign C
emotion_call.emotion_id emotion_call_emotion_id_foreign C
emotion_primary_id INT UNSIGNED 10 null
emotions_primary.id emotions_emotion_primary_id_foreign C
emotion_secondary_id INT UNSIGNED 10 null
emotions_secondary.id emotions_emotion_secondary_id_foreign C
name VARCHAR 255 null
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
emotions_emotion_primary_id_foreign Performance Asc emotion_primary_id
emotions_emotion_secondary_id_foreign Performance Asc emotion_secondary_id

Relationships

Close relationships within degrees of separation