assignment

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
role VARCHAR 32 null
attended TINYINT 3 √ NULL
attended_at DATETIME 19 √ NULL
pid VARCHAR 16 √ NULL
created_at DATETIME 19 null
updated_at DATETIME 19 null
event_timeslot_id INT UNSIGNED 10 null
event_timeslot.id FK_30C544BA52A96A69 C
user_id INT UNSIGNED 10 null
user.id FK_30C544BAA76ED395 C

Indexes

Constraint Name Type Sort Column(s)
assignment_s_pk Primary key Asc id
IDX_30C544BA52A96A69 Performance Asc event_timeslot_id
IDX_30C544BAA76ED395 Performance Asc user_id
PRIMARY Must be unique Asc id
UNIQ_30C544BA5550C4ED Must be unique Asc pid
uniq_assignment_event_timeslot_user Must be unique Asc/Asc event_timeslot_id + user_id

Relationships

Close relationships within degrees of separation