project_field_pending_change_approver


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
change_id BIGINT 19 null
project_field_pending_change_request.id FK_project_field_pending_change_approver_approval R
role_id INT 10 √ null
sys_roles.role_id FK_project_field_pending_change_approver_role R
approver_id INT 10 √ null
sys_users.user_id FK_project_field_pending_change_approver_user R
status_id INT 10 √ null
approval_timestamp DATETIME 19 √ null
project_field_approver_id BIGINT 19 √ null
project_field_change_approver.id FK_project_field_pending_change_approver_field_approval R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_project_field_pending_change_approver_change_idx Performance Asc change_id
FK_project_field_pending_change_approver_field_approval_idx Performance Asc project_field_approver_id
FK_project_field_pending_change_approver_role_idx Performance Asc role_id
FK_project_field_pending_change_approver_user_idx Performance Asc approver_id

Relationships

Close relationships within degrees of separation