ple_assessment_lock_activities

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
ple_assessment_id CHAR 36 null
ple_assessments.id ple_assessment_lock_activities_ple_assessment_id_foreign C

Assessment UUID
action TINYINT 3 null

Lock -> 1 or Unlock -> 0
performed_by CHAR 36 null
users.id ple_assessment_lock_activities_performed_by_foreign R

Admin / user UUID (users.id)
created_at TIMESTAMP 19 CURRENT_TIMESTAMP

When the action was performed

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ple_assessment_lock_activities_assessment_created_at Performance Asc/Asc ple_assessment_id + created_at
ple_assessment_lock_activities_performed_by Performance Asc performed_by

Relationships

Close relationships within degrees of separation