catissue_user

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_base_shipment.RECEIVER_USER_ID FK84DE7ECC4502E901R
catissue_base_shipment.SENDER_USER_ID FK84DE7ECC2ABD7347R
catissue_cell_spe_review_param.USER_ID FK_USER_CELL_EVENTR
catissue_coll_coordinators.USER_ID FKE490E33A2206F20FR
catissue_coll_event_param.USER_ID FK_USER_COLL_EVENTR
catissue_coll_prot_reg.CONSENT_WITNESS FK5EB25F13A0FF79D4R
catissue_cp_req_specimen.COLLECTOR_ID FK_COLLECTOR_CP_REQ_SPECIMENR
catissue_cp_req_specimen.RECEIVER_ID FK_RECEIVER_CP_REQ_SPECIMENR
catissue_disposal_event_param.USER_ID FK_USER_DISP_EVENTR
catissue_distri_event_param.USER_ID FK_USER_DISTRI_EVENTR
catissue_embedded_event_param.USER_ID FK_USER_EMB_EVENTR
catissue_fixed_event_param.USER_ID FK_USER_FIXED_EVENTR
catissue_fluid_spe_event_param.USER_ID FK_USER_FLUID_EVENTR
catissue_form_record_entry.UPDATED_BY FK_RE_UPDATED_BY_USERS_IDR
catissue_frozen_event_param.USER_ID FK_USER_FROZEN_EVENTR
catissue_in_out_event_param.USER_ID FK_USER_INOUT_EVENTR
catissue_mol_spe_review_param.USER_ID FK_USER_MOL_EVENTR
catissue_password.UPDATED_BY FK_PASSWORD_UPDATED_BYR
catissue_password.USER_ID FKDE1F38972206F20FR
catissue_procedure_event_param.USER_ID FK_USER_PROC_EVENTR
catissue_qfolder_share_setting.USER_ID CAT_QFSS_USER_ID_CAT_USR_IDR
catissue_quarantine_params.USER_ID FK3C12AE3B2206F20FR
catissue_query_audit_logs.RUN_BY FK_QAUDIT_LOG_RUN_BY_USERS_IDR
catissue_query_folders.OWNER CAT_QF_OWNER_CAT_USR_IDR
catissue_received_event_param.USER_ID FK_USER_REC_EVENTR
catissue_review_params.USER_ID FK5311FFF62206F20FR
catissue_saved_queries.CREATED_BY FK_SAVED_QUERIES_CREATED_BYR
catissue_saved_queries.LAST_UPDATED_BY FK_SAVED_QUERIES_UPDATED_BYR
catissue_site.USER_ID FKB024C3432206F20FR
catissue_site_coordinators.USER_ID FK_USER_ID_BY_CAT_USER_IDR
catissue_site_users.USER_ID FK1R
catissue_spec_tag_items.ADDED_BY FK_CART_ITEMS_ADDED_BYR
catissue_specimen_coll_group.COLLECTOR_ID FK_USER_EVENT_MAPPINGR
catissue_specimen_coll_group.RECEIVER_ID FK_RECEIVER_ID_SCGR
catissue_specimen_event_param.USER_ID FK753F33AD2206F20FR
catissue_specimenlist_tags.USER_ID FK_SPECLIST_USER_IDR
catissue_spun_event_parameters.USER_ID FK_USER_SPUN_EVENTR
catissue_thaw_event_parameters.USER_ID FK_USER_THAW_EVENTR
catissue_tis_spe_event_param.USER_ID FK_USER_TISSUE_EVENTR
catissue_transfer_event_param.USER_ID FK_USER_TRANSFER_EVENTR
catissue_user_cp.USER_ID FK5R
catissue_user_sites.USER_ID FK_CAT_US_USERID_CAT_USER_IDR
os_auth_tokens.USER_ID FK_AUTH_TOKENS_USER_IDR
os_bulk_import_jobs.CREATED_BY FK_OS_BLK_IMP_JOBS_CREATED_BYR
os_cfg_settings.ACTIVATED_BY FK_CFG_SETTINGS_ACTIVATED_BYR
os_child_spmn_events.USER_ID FK_CHILD_SPMN_EVENTS_USER_IDR
os_container_activity_logs.PERFORMED_BY FK_CONT_ACT_LOG_USER_IDR
os_container_store_lists.USER_ID FK_STORE_LIST_USER_IDR
os_container_transfer_events.USER_ID FK_CONT_TRAF_EVT_USERR
os_cp_catalog_settings.CREATED_BY FK_OS_CP_CAT_SETTINGS_CREATORR
os_cp_catalog_settings.LAST_UPDATED_BY FK_OS_CP_CAT_SETTINGS_UPDATERR
os_cp_report_rcpts.USER_ID FK_CP_RPT_RCPTS_USR_IDR
os_cpr_messaging_activities.SENT_BY FK_EMAIL_ACT_SENT_BYR
os_cpr_recs.CONSENT_WITNESS FK_QUERY_CPR_RECS_WITNESSR
os_cpr_recs.CREATOR FK_QUERY_CPR_RECS_CREATORR
os_cpr_recs.UPDATER FK_QUERY_CPR_RECS_UPDATERR
os_data_backup_audit_logs.RUN_BY FK_DATA_BACKUP_USER_IDR
os_delete_audit_logs.USER_ID FK_AUDIT_LOGS_USER_IDR
os_delete_spmn_events.USER_ID FK_DELETE_EVENT_USER_IDR
os_dp_coordinators.USER_ID FK_DP_COORD_USER_IDR
os_dq_queries.ASSIGNED_TO FK_DQ_QRY_ASSIGNEDR
os_dq_queries.AUDITOR_ID FK_DQ_QRY_AUDITORR
os_dq_query_comments.AUTHOR_ID FK_DQ_QUERY_COMMENT_AUTHORR
os_export_jobs.CREATED_BY FK_EXPORT_JOBS_USERR
os_forgot_password_tokens.USER_ID FK_FG_TOKENS_USER_IDR
os_form_data_entry_tokens.CREATED_BY FK_FDE_TK_CREATORR
os_label_print_file_items.CREATOR_ID FK_PRINT_FILE_USER_IDR
os_label_print_jobs.SUBMITTED_BY FK_LBL_PRN_JOBS_SUBM_IDR
os_licenses.UPLOADED_BY FK_LICENSE_UPLOADED_BYR
os_login_audit_logs.IMPERSONATED_BY FK_LOGIN_AUDIT_IMP_BYR
os_login_audit_logs.USER_ID FK_LOGIN_AUDIT_LOGS_USER_IDR
os_mobile_upload_jobs.CREATED_BY FK_MOBILE_UPLOADS_CREATOR_IDR
os_notifications.CREATED_BY FK_NOTIFICATION_CREATED_BYR
os_order_items.RETURNED_BY FK_OS_OI_RETURNED_BYR
os_orders.DISTRIBUTOR_ID FK_OS_DO_DISTRIBUTER_IDR
os_orders.REQUESTER_ID FK_OS_DO_REQUESTER_IDR
os_participant_anon_events.ANONYMIZED_BY FK_PART_ANON_EVENT_USER_IDR
os_participant_email_tmpls.CREATED_BY FK_EMAIL_TMPL_CREATORR
os_participant_email_tmpls.UPDATED_BY FK_EMAIL_TMPL_UPDATERR
os_pde_audit_logs.USER_ID FK_PDE_AUDIT_LOG_USERR
os_pde_notifs.CREATED_BY FK_PDE_NOTIF_USER_IDR
os_pooled_specimens.USER_ID FK_POOLED_EVENT_USERR
os_print_rules.UPDATED_BY FK_PRINT_RULE_UPDATED_BYR
os_published_cp_events.PUBLISHED_BY FK_PUBLISHED_EVENT_USERR
os_published_cp_reviewers.USER_ID FK_PUBLISHED_CP_REVIEWERR
os_qc_errors_log.USER_ID FK_QC_ERROR_USER_IDR
os_sched_cont_act_users.USER_ID FK_SCHED_CONT_ACT_USER_IDR
os_scheduled_job_shared_users.USER_ID FK_OS_SCHEDULED_JOB_SU_USRR
os_scheduled_jobs.CREATED_BY FK_OS_SCHEDULED_JOB_CREATED_BYR
os_scheduled_jobs.RUN_AS_USER_ID FK_SCHED_RUN_USER_IDR
os_scheduled_jobs_notif_rcpts.USER_ID FK_OS_SCHLD_JOB_RECPT_USERSR
os_shipment_notify_users.USER_ID OS_FK_SHIP_NOTIFY_USER_IDR
os_shipments.RECEIVER_ID OS_FK_SHIP_RECEIVER_IDR
os_shipments.REQUESTER_ID FK_SHIPMENT_REQUESTERR
os_shipments.SENDER_ID OS_FK_SHIP_SENDER_IDR
os_sms_provider_configs.CREATOR_ID FK_SMS_PROVIDER_CFG_CREATORR
os_sms_provider_configs.UPDATED_BY FK_SMS_PROVIDER_CFG_UPDATERR
os_specimen_cart_folders.OWNER_ID FK_CART_FOLDER_OWNERR
os_specimen_kits.SENDER_ID FK_SPMN_KIT_SENDER_IDR
os_specimen_requests.PROCESSOR_ID FK_OS_SPMN_REQS_PROCESSORR
os_specimen_requests.REQUESTOR_ID FK_OS_SPMN_REQS_REQUESTORR
os_specimen_requests.SCREENED_BY FK_SPMN_REQS_SCREENERR
os_storage_containers.CREATED_BY FK_OS_ST_CONT_CREATED_BYR
os_supplies.CREATED_BY FK_SUPPLY_CREATORR
os_supplies.UPDATED_BY FK_SUPPLY_UPDATERR
os_supply_items.USED_BY FK_SUPPLY_ITEMS_USED_BYR
os_supply_shipments.RECEIVER_ID FK_SUPPLY_SHIPMENT_RECEIVERR
os_supply_shipments.SENDER_ID FK_SUPPLY_SHIPMENT_SENDERR
os_supply_type_notif_users.USER_ID FK_ST_NOTIF_USERS_USER_IDR
os_survey_instances.COMPLETED_BY FK_SURVEY_INSTANCE_COMPL_USERR
os_survey_instances.CREATED_BY FK_SRY_INVITATION_CREATED_BYR
os_survey_instances.REMINDERS_STOPPED_BY FK_SURVEY_INST_REM_STOPPED_BYR
os_unhandled_exceptions.USER_ID FK_UNHANDLED_EXCEPTION_USER_IDR
os_user_api_calls_log.IMPERSONATED_USER_ID FK_CALL_LOG_IMP_USER_IDR
os_user_api_calls_log.USER_ID FK_OS_USER_API_LOG_USER_IDR
os_user_db_sessions.USER_ID FK_DB_SESSION_USERR
os_user_devices.USER_ID OS_DEVICE_USER_IDR
os_user_favorites.USER_ID FK_FAVORITE_VIEW_USERR
os_user_group_users.USER_ID FK_GRP_USERS_USR_IDR
os_user_login_otps.USER_ID FK_LOGIN_OTP_USERR
os_user_notifications.USER_ID FK_NOTIF_USERS_USER_IDR
os_user_otp_details.USER_ID FK_OS_UOTP_USER_IDR
os_user_ui_states.USER_ID FK_UI_STATE_USERR
os_wf_libraries.CREATED_BY FK_WF_LIBRARY_CREATORR
os_wf_libraries.UPDATED_BY FK_WF_LIBRARY_UPDATERR
os_workflow_instances.CREATOR_ID FK_WF_INSTANCE_CREATORR
os_workflow_task_instances.USER_ID FK_WF_TASK_INSTANCE_USER_IDR
os_workflows.CREATED_BY FK_WORKFLOW_CREATORR
os_workflows.UPDATED_BY FK_WORKFLOW_UPDATERR
query_tags.USER_ID FK_QUERYTAG_USER_IDR
rbac_subject_roles.SUBJECT_ID FK_OS_SUB_ID_USER_IDR
shared_query_tags.USER_ID FK_SHARED_QUERY_USER_IDR
shared_specimenlist_tags.USER_ID FK_SHARED_SPECLIST_USER_IDR
EMAIL_ADDRESS VARCHAR 255 √ null
FIRST_NAME VARCHAR 255 √ null
LAST_NAME VARCHAR 255 √ null
LOGIN_NAME VARCHAR 255 null
START_DATE DATE 10 √ null
ACTIVITY_STATUS VARCHAR 50 √ null
DEPARTMENT_ID BIGINT 19 √ null
ADDRESS_ID BIGINT 19 √ null
STATUS_COMMENT TEXT 65535 √ null
FIRST_TIME_LOGIN BIT 1 √ b'1'
FORGOT_PASSWORD_TOKEN VARCHAR 255 √ null
PASSWORD VARCHAR 64 √ null
IS_ADMIN BIT 1 √ null
ADDRESS TEXT 65535 √ null
PHONE_NUMBER VARCHAR 63 √ null
MANAGE_FORMS BIT 1 b'0'
INSTITUTE_ID BIGINT 19 √ null
catissue_institution.IDENTIFIER FK_USER_INSTITUTE_IDR
TYPE VARCHAR 16 √ NONE
PRIMARY_SITE_ID BIGINT 19 √ null
catissue_site.IDENTIFIER FK_USER_PRIMARY_SITE_IDR
DOMAIN_ID BIGINT 19 null
os_auth_domains.IDENTIFIER FK_USER_DOMAIN_IDR
TIME_ZONE VARCHAR 32 √ null
DND BIT 1 b'0'
API_USER BIT 1 √ b'0'
IP_RANGE VARCHAR 255 √ null
FORCE_PASSWORD_RESET BIT 1 b'1'
MANAGE_WFS BIT 1 √ null
DOWNLOAD_LABELS_PRINT_FILE BIT 1 √ b'0'
DEFAULT_PRINTER_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_USER_PRINTERR
MANAGE_PRINT_JOBS BIT 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_USER_DOMAIN_ID Performance Asc DOMAIN_ID
FK_USER_INSTITUTE_ID Performance Asc INSTITUTE_ID
FK_USER_PRIMARY_SITE_ID Performance Asc PRIMARY_SITE_ID
FK_USER_PRINTER Performance Asc DEFAULT_PRINTER_ID
FKB025CFC76CD94566 Performance Asc ADDRESS_ID
INDX_USER_FNAME Performance Asc FIRST_NAME
INDX_USER_LNAME Performance Asc LAST_NAME
USER_DOMAIN_LOGIN_UQ Must be unique Asc/Asc LOGIN_NAME + DOMAIN_ID
USER_EMAIL_ADDRESS_UQ Must be unique Asc EMAIL_ADDRESS

Relationships

Close relationships within degrees of separation