sys_roles


Columns

Column Type Size Nulls Auto Default Children Parents Comments
role_id INT 10 √ null
contract_holder_support.role_id FK503B5F09839C9EC3 R
intake.assigned_role_id FK_2i5nyx5396ma3p3gq3rp9i8h3 R
locale_contact.role_id FK_mu931g7k25ys1f7aygieejqld R
milestone_task_detail.accountable_role_id FK79905FFCABE08F8B R
milestone_task_detail.responsible_role_id FK79905FFCFD6A367A R
notification_group_role.role_id FK_nxht9wpqfr17f48wfr62g2agd R
notification_owner.owner_id FKA73D425F94ACA766 R
plg_signature_role.role_id FK_plg_sig_role_role R
powerbi_entry_roles.role_id fk_powerbi_role C
process_library_record_accountable.role_id FK71A2DFED839C9EC3 R
process_library_record_consulted.role_id FKA92ADDF1839C9EC3 R
process_library_record_informed.role_id FK10ED10A2839C9EC3 R
process_library_record_responsible.role_id FKAC1DE5DC839C9EC3 R
program_asset_responsible_roles.role_id FK_r4by8o0be82ud3qfqagsia1o R
program_company.role_id FK_50gpypr1xg36aq3b73wr64yrq R
program_contact.role_id FK_hddn1f92odeu2yyka6rdjdscg R
program_milestone_type.responsible_role_id FK_pu0i08qc6t8bl3i3p2hk7k7jr R
program_support.role_id FK_gu4kci1k79e7opwmovrb1uhpr R
program_workflow_log.owner_role_id FK_ovsj67dje3wmrxr73p9wjsoes R
program_workflow_participant_type.role_id FK_1ipwjaq4gjgcjkuj9p49g73pr R
project_company.role_id FKA9FB0557839C9EC3 R
project_contact.role_id FKAA0AECFA839C9EC3 R
project_field.role_id FKC752D854839C9EC3 R
project_field_change_approver.role_id FK_project_field_change_approver_role R
project_field_pending_change_approver.role_id FK_project_field_pending_change_approver_role R
project_plg_recipient.role_id FK_project_plg_recipient_role R
project_plg_signature.role_id FK_project_plg_signature_role R
project_plg_signature_role.role_id FK_prj_plg_sig_role_role R
project_support.role_id FK2C648A9839C9EC3 R
project_support_auto.role_id FK_project_support_auto R
scheduled_notification_owner.role_id FKC651A731839C9EC3 R
site_contact.role_id FK7C287328839C9EC3 R
site_contact_role.role_id FK63D97F2D839C9EC3 R
site_support.role_id FKD4E3CED7839C9EC3 R
sitepack_file_role.role_id FKCBA0B9BA839C9EC3 R
survey_participation.role_id FK_bpqieo5abb7ar306rmwk5f67j R
survey_response.respondent_role_id FK_n24daevdemv8xenlwxfhijiu3 R
sys_company_types.role_id FK5B8C0C45839C9EC3 R
sys_role_permits.role_id FKB4DA3121839C9EC3 R
sys_role_users.role_id FK553305B1839C9EC3 R
sys_temporary_role_users.role_id FK_pnk8bat94tuq6sakd17e722e9 R
vendor_task.role_id FK_8o61niwb35h58yg32ddhrilxl R
workflow_log.owner_role_id FK_7ao1gk2nqshmg6yoql8v8se84 R
workflow_participant_type.role_id FK47260146839C9EC3 R
name VARCHAR 80 √ null
code VARCHAR 10 √ null
cloneable BIT 1 b'1'
site_contact BIT 1 b'0'
role_type_id INT 10 √ null
sys_role_type.id FK_tl5hgo8xu862p2hoxrdafquim R
update_option INT 10 √ null
version BIGINT 19 null
vendor_survey_eligible BIT 1 null
archived BIT 1 b'0'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc role_id
IX_sys_roles_type_id Performance Asc/Asc role_type_id + role_id
name Must be unique Asc name

Relationships

Close relationships within degrees of separation