event_timeslot

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
activity_execution.event_timeslot_id FK_9BEEE2F952A96A69 C
assignment.event_timeslot_id FK_30C544BA52A96A69 C
pid VARCHAR 16 √ NULL
created_at DATETIME 19 null
updated_at DATETIME 19 null
event_id INT UNSIGNED 10 null
event.id FK_7D08BB2771F7E88B C
timeslot_id INT UNSIGNED 10 null
timeslot.id FK_7D08BB27F920B9E9 C

Indexes

Constraint Name Type Sort Column(s)
event_timeslot_s_pk Primary key Asc id
IDX_7D08BB2771F7E88B Performance Asc event_id
IDX_7D08BB27F920B9E9 Performance Asc timeslot_id
PRIMARY Must be unique Asc id
UNIQ_7D08BB275550C4ED Must be unique Asc pid
uniq_event_timeslot Must be unique Asc/Asc event_id + timeslot_id

Relationships

Close relationships within degrees of separation