catissue_collection_protocol

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_clinical_diagnosis.COLLECTION_PROTOCOL_ID FK_CD_COLPROTR
catissue_coll_coordinators.COLLECTION_PROTOCOL_ID FKE490E33A48304401R
catissue_coll_distribution_rel.COLLECTION_PROTOCOL_ID FK1483BCB548304401R
catissue_coll_prot_event.COLLECTION_PROTOCOL_ID FK7AE7715948304401R
catissue_coll_prot_reg.COLLECTION_PROTOCOL_ID FK5EB25F1348304401R
catissue_collection_protocol.CONSENTS_SOURCE_CP_ID FK_CONSENTS_SOURCE_CP_IDR
catissue_collection_protocol.PARENT_CP_ID FK32DC439DBC7298B9R
catissue_consent_tier.COLL_PROTOCOL_ID FK51725303E36A4B4FR
catissue_container_cps.CP_ID FK_CAT_CC_CPID_CAT_CP_IDR
catissue_cp_site_roles.CP_ID FK_CAT_CSR_CPID_CAT_CP_IDR
catissue_saved_queries.CP_ID FK_SAVED_QUERY_CPR
catissue_site_cp.COLLECTION_PROTOCOL_ID FK_SITE_CP_COLL_PROT_IDR
catissue_specimen.COLLECTION_PROTOCOL_ID FK_SPEC_CP_IDR
catissue_st_cont_coll_prot_rel.COLLECTION_PROTOCOL_ID FK3AE9FCA748304401R
catissue_user_cp.COLLECTION_PROTOCOL_ID FK6R
os_cp_allowed_dps.CP_ID OS_FK_CP_ALLOWED_DPS_CP_IDR
os_cp_catalog_settings.CP_ID FK_OS_CP_CAT_SETTINGS_CP_IDR
os_cp_group_cps.CP_ID FK_CP_GROUP_CP_IDR
os_cp_message_settings.CP_ID FK_CP_MESSAGE_SETTINGSR
os_cp_report_settings.CP_ID FK_CP_RPT_SETTINGS_CP_IDR
os_cp_spmn_lbl_print_settings.CP_ID FK_OS_CP_SPMN_PRINT_SETTINGSR
os_cp_workflows.CP_ID FK_OS_CP_WORKFLOWS_CP_IDR
os_cpr_recs.CP_ID FK_QUERY_CPR_RECS_CP_IDR
os_dq_audit_settings.CP_ID FK_DQ_AUDIT_SETTING_CPR
os_dq_queries.CP_ID FK_DQ_QRY_CPR
os_mobile_upload_jobs.CP_ID FK_MOBILE_UPLOADS_CP_IDR
os_participant_email_tmpls.CP_ID FK_EMAIL_TMPL_CP_IDR
os_published_cp_events.COLLECTION_PROTOCOL_ID FK_PUBLISHED_EVENT_CP_IDR
os_qc_errors_log.CP_ID FK_QC_ERROR_CPR
os_specimen_deposits.CP_ID FK_OS_SPMN_DEPS_CPR
os_specimen_kits.CP_ID FK_SPMN_KIT_CP_IDR
os_specimen_requests.CP_ID FK_OS_SPMN_REQS_CP_IDR
os_specimen_type_units.CP_ID FK_SPMN_TYPE_UNIT_CP_IDR
os_stor_container_comp_cps.CP_ID FK_OS_ST_CONT_CCPS_CP_IDR
os_stor_container_cps.CP_ID FK_OS_ST_CONT_CPS_CP_IDR
os_supply_allowed_cps.CP_ID FK_OS_SUPPLY_CPS_CP_IDR
os_supply_shipments.CP_ID FK_SUPPLY_SHIPMENT_CPR
os_supply_types.CP_ID FK_SUPPLY_TYPE_CPR
os_surveys.CP_ID FK_SRY_CP_IDR
os_workflow_cps.CP_ID FK_WORKFLOW_CP_IDR
rbac_subject_roles.CP_ID FK_OS_SUB_ROLES_TO_CPR
UNSIGNED_CONSENT_DOC_URL TEXT 65535 √ null
CONSENTS_WAIVED BIT 1 √ null
CP_TYPE VARCHAR 50 √ null
PARENT_CP_ID BIGINT 19 √ null
catissue_collection_protocol.IDENTIFIER FK32DC439DBC7298B9R
SEQUENCE_NUMBER INT 10 √ null
STUDY_CALENDAR_EVENT_POINT DOUBLE 22 √ null
IS_EMPI_ENABLE BIT 1 √ null
PRINCIPAL_INVESTIGATOR_ID BIGINT 19 √ null
TITLE VARCHAR 255 √ null
SHORT_TITLE VARCHAR 50 √ null
IRB_IDENTIFIER VARCHAR 255 √ null
START_DATE DATE 10 √ null
END_DATE DATE 10 √ null
ENROLLMENT BIGINT 19 √ null
DESCRIPTION_URL VARCHAR 255 √ null
ACTIVITY_STATUS VARCHAR 50 √ null
LABEL_FORMAT VARCHAR 255 √ null
DERIV_LABEL_FORMAT VARCHAR 255 √ null
ALIQUOT_LABEL_FORMAT VARCHAR 255 √ null
PPID_FORMAT VARCHAR 255 √ null
VISIT_NAME_FORMAT VARCHAR 255 √ null
MANUAL_PPID_ALLOWED BIT 1 √ null
MANUAL_VISIT_NAME_ALLOWED BIT 1 √ null
MANUAL_SPEC_LABEL_ALLOWED BIT 1 √ null
CODE VARCHAR 32 √ null
SPMN_LABEL_PRE_PRINT_MODE VARCHAR 32 √ null
VISIT_NAME_PRINT_MODE VARCHAR 32 √ null
VISIT_NAME_PRINT_COPIES BIGINT 19 √ null
SOP_DOCUMENT_URL VARCHAR 255 √ null
SOP_DOCUMENT_NAME VARCHAR 255 √ null
CONTAINER_SEL_STRATEGY VARCHAR 32 √ null
ALIQUOTS_IN_SAME_CONT BIT 1 √ null
EXTRACT_SPR_TEXT BIT 1 √ null
BARCODING_ENABLED BIT 1 √ b'0'
BULK_PART_REG_ALLOWED BIT 1 b'0'
SPECIMEN_CENTRIC BIT 1 b'0'
VISIT_COLLECTION_MODE VARCHAR 16 √ null
STORE_SPRS BIT 1 √ null
CATALOG_ID BIGINT 19 √ null
SPECIMEN_BARCODE_FORMAT VARCHAR 255 √ null
CLOSE_PARENT_SPMNS BIT 1 √ b'0'
LABEL_SEQ_KEY VARCHAR 32 ID
SET_QTY_TO_ZERO BIT 1 √ null
DRAFT_MODE BIT 1 b'0'
VISIT_CONSENTS BIT 1 √ null
ADDL_LABEL_FORMAT VARCHAR 255 √ null
STORE_SITE_ACCESS_RIGHTS BIT 1 √ null
DRAFT_DATA_ENTRY BIT 1 b'0'
EMAIL_SENDER_GROUP BIGINT 19 √ null
os_user_groups.IDENTIFIER FK_CP_EMAIL_SENDER_GROUPR
KIT_LABELS_ENABLED BIT 1 √ b'0'
CONSENTS_SOURCE_CP_ID BIGINT 19 √ null
catissue_collection_protocol.IDENTIFIER FK_CONSENTS_SOURCE_CP_IDR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK32DC439DBC7298B9 Performance Asc PARENT_CP_ID
FK_CONSENTS_SOURCE_CP_ID Performance Asc CONSENTS_SOURCE_CP_ID
FK_CP_EMAIL_SENDER_GROUP Performance Asc EMAIL_SENDER_GROUP
idx_collection_prot_title Must be unique Asc TITLE
OS_CP_CODE_UQ Must be unique Asc CODE
SHORT_TITLE Must be unique Asc SHORT_TITLE

Relationships

Close relationships within degrees of separation