os_user_groups

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_collection_protocol.EMAIL_SENDER_GROUP FK_CP_EMAIL_SENDER_GROUPR
os_cart_folder_user_groups.GROUP_ID FK_CART_FOLDER_UG_GROUPR
os_cp_group_form_notif_users.USER_GROUP_ID FK_CPG_FORM_NOTIF_USER_GROUPR
os_cp_message_settings.SENDER_GROUP_ID FK_CP_SENDER_GROUPR
os_dq_audit_settings.AUDITORS_GROUP_ID FK_DQ_AUDIT_SETTING_AUDITORSR
os_dq_audit_settings.COORDINATORS_GROUP_ID FK_DQ_AUDIT_SETTING_NOTIFYR
os_form_notif_user_grps.USER_GROUP_ID FK_FORM_NOTIF_USER_GRPR
os_query_folder_shared_groups.GROUP_ID FK_QFOLDER_SHR_GRP_GRP_IDR
os_specimen_list_shared_groups.GROUP_ID FK_SPMN_LIST_SHR_GRP_GRP_IDR
os_user_group_users.GROUP_ID FK_GRP_USERS_GRP_IDR
os_wf_lab_user_groups.USER_GROUP_ID FK_LAB_USER_GROUP_IDR
os_wf_lib_task_notif_groups.USER_GROUP_ID FK_LIB_TASK_NOTIF_GROUPS_USERR
os_wf_lib_task_user_groups.USER_GROUP_ID FK_WF_LIB_TASK_UG_IDR
os_wf_task_eff_user_groups.USER_GROUP_ID FK_TASK_EFF_UGS_UGR
os_workflow_notif_user_groups.USER_GROUP_ID FK_WORKFLOW_NOTIFS_UG_IDR
os_workflow_task_notif_groups.USER_GROUP_ID FK_TASK_NOTIF_GROUPS_USERR
os_workflow_task_user_groups.USER_GROUP_ID FK_TASK_UG_GROUPR
NAME VARCHAR 64 null
DESCRIPTION VARCHAR 255 null
INSTITUTE_ID BIGINT 19 null
catissue_institution.IDENTIFIER FK_USER_GROUP_INSTITUTER
ACTIVITY_STATUS VARCHAR 32 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_USER_GROUP_INSTITUTE Performance Asc INSTITUTE_ID

Relationships

Close relationships within degrees of separation