catissue_distribution_protocol

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_coll_distribution_rel.DISTRIBUTION_PROTOCOL_ID FK1483BCB56B1F36E7R
catissue_distribution_spec_req.DISTRIBUTION_PROTOCOL_ID fk_distribution_protocolR
os_cp_allowed_dps.DP_ID OS_FK_CP_ALLOWED_DPS_DP_IDR
os_dist_services.DP_ID FK_OS_DIST_SERVICES_DP_IDR
os_distribution_protocol_sites.DISTRIBUTION_PROTOCOL_ID FK_DP_SITES_DP_IDR
os_dp_consent_tiers.DP_ID FK_DP_CONSENT_STMTS_DP_IDR
os_dp_coordinators.DISTRIBUTION_PROTOCOL_ID FK_DP_COORD_DP_IDR
os_dp_requirements.DP_ID FK_OS_DP_REQ_DP_IDR
os_orders.DISTRIBUTION_PROTOCOL_ID FK_OS_DO_DP_IDR
os_specimen_requests.DP_ID FK_OS_SR_DP_IDR
os_spmn_reserved_events.DP_ID FK_RESERVED_FOR_DP_IDR
os_stor_container_comp_dps.DP_ID FK_OS_STORE_CONT_CDPS_DP_IDR
os_stor_container_dps.DP_ID FK_OS_STORE_CONT_DP_DP_IDR
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
INSTITUTE_ID BIGINT 19 √ null
catissue_institution.IDENTIFIER FK_CAT_DP_INSTITUTE_IDR
REPORT_ID BIGINT 19 √ null
catissue_saved_queries.IDENTIFIER FK_DP_REPORT_IDR
DEF_RECEIVING_SITE_ID BIGINT 19 √ null
catissue_site.IDENTIFIER FK_DP_DEF_REC_SITE_IDR
ORDER_EXTN_FORM_ID BIGINT 19 √ null
dyextn_containers.IDENTIFIER FK_ORDER_EXTN_FORM_IDR
DISABLE_EMAIL_NOTIFS BIT 1 √ null
ORDER_ITEM_LABEL_FORMAT VARCHAR 255 √ null
ATTACHMENT_TYPE VARCHAR 16 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_CAT_DP_INSTITUTE_ID Performance Asc INSTITUTE_ID
FK_DP_DEF_REC_SITE_ID Performance Asc DEF_RECEIVING_SITE_ID
FK_DP_REPORT_ID Performance Asc REPORT_ID
FK_ORDER_EXTN_FORM_ID Performance Asc ORDER_EXTN_FORM_ID
idx_ditri_title Must be unique Asc TITLE

Relationships

Close relationships within degrees of separation