project_field_pending_change_request


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
project_field_pending_change_approver.change_id FK_project_field_pending_change_approver_approval R
field_id INT 10 null
project_field.id FK_project_field_pending_change_field R
project_id INT 10 √ null
project.id FK_project_field_pending_change_project R
site_id INT 10 √ null
site.id FK_project_field_pending_change_site R
date_created DATETIME 19 √ null
notes TEXT 65535 √ null
subcategory_id INT 10 √ null
project_note_subcategory.id FK_project_field_pending_change_subcategory R
requestor_id INT 10 null
sys_users.user_id FK_project_field_pending_change_requestor R
pending_value TEXT 65535 √ null
original_value TEXT 65535 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_project_field_pending_change_field_idx Performance Asc field_id
FK_project_field_pending_change_project_idx Performance Asc project_id
FK_project_field_pending_change_requestor_idx Performance Asc requestor_id
FK_project_field_pending_change_site_idx Performance Asc site_id
FK_project_field_pending_change_subcategory_idx Performance Asc subcategory_id

Relationships

Close relationships within degrees of separation