catissue_site

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_base_shipment.RECEIVER_SITE_ID FK84DE7ECCCAF26781R
catissue_base_shipment.SENDER_SITE_ID FK84DE7ECCB0ACF1C7R
catissue_coll_prot_event.SITE_ID FK_SITE_ID_CPER
catissue_coll_prot_reg.SITE_ID FK_CPR_SITE_IDR
catissue_cp_site_roles.SITE_ID FK_CAT_CSR_SITEID_CAT_SITE_IDR
catissue_distribution_protocol.DEF_RECEIVING_SITE_ID FK_DP_DEF_REC_SITE_IDR
catissue_part_medical_id.SITE_ID FK349E77F9A7F77D13R
catissue_pathology_report.SOURCE_ID FK904EC9F040DCD7BFR
catissue_site_coordinators.SITE_ID FK_SITE_ID_BY_CAT_SITE_IDR
catissue_site_cp.SITE_ID FK_SITE_CP_SITE_IDR
catissue_site_users.SITE_ID FK2R
catissue_specimen_coll_group.SITE_ID FK_SITE_ID_SCGR
catissue_storage_container.SITE_ID FK28429D01A7F77D13R
catissue_user.PRIMARY_SITE_ID FK_USER_PRIMARY_SITE_IDR
catissue_user_sites.SITE_ID FK_CAT_US_SITEID_CAT_SITE_IDR
os_container_transfer_events.FROM_SITE_ID FK_CONT_TRAF_EVT_FROM_SITER
os_container_transfer_events.TO_SITE_ID FK_CONT_TRAF_EVT_TO_SITER
os_distribution_protocol_sites.SITE_ID FK_DP_SITES_SITE_IDR
os_orders.SITE_ID FK_OS_DO_SITE_IDR
os_shipments.RECEIVING_SITE_ID OS_FK_SHIP_RECV_SITE_IDR
os_shipments.SENDING_SITE_ID OS_FK_SHIP_SENDING_SITE_IDR
os_specimen_gels.SITE_ID FK_SPMN_GEL_SITE_IDR
os_specimen_kits.RECEIVING_SITE_ID FK_SPMN_KIT_RECEIVING_SITE_IDR
os_specimen_kits.SENDING_SITE_ID FK_SPMN_KIT_SENDING_SITE_IDR
os_storage_containers.SITE_ID FK_OS_ST_CONT_SITE_IDR
rbac_subject_roles.SITE_ID FK_OS_SUB_ROLES_TO_SITER
NAME VARCHAR 255 null
TYPE VARCHAR 50 √ null
EMAIL_ADDRESS VARCHAR 255 √ null
USER_ID BIGINT 19 √ null
catissue_user.IDENTIFIER FKB024C3432206F20FR
ACTIVITY_STATUS VARCHAR 50 √ null
ADDRESS_ID BIGINT 19 √ null
CODE VARCHAR 50 √ null
INSTITUTE_ID BIGINT 19 √ null
catissue_institution.IDENTIFIER FK_CT_SITE_INSTITUTE_IDR
ADDRESS TEXT 65535 √ null
CONTAINER_ID BIGINT 19 √ null
os_storage_containers.IDENTIFIER FK_SITE_CONT_IDR
TYPE_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SITE_TYPER

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
CATISSUE_SITE_CODE_UQ Must be unique Asc CODE
FK_CT_SITE_INSTITUTE_ID Performance Asc INSTITUTE_ID
FK_SITE_CONT_ID Performance Asc CONTAINER_ID
FK_SITE_TYPE Performance Asc TYPE_ID
FKB024C3432206F20F Performance Asc USER_ID
FKB024C3436CD94566 Performance Asc ADDRESS_ID
INDX_CAT_SITE_TYPE Performance Asc TYPE
NAME Must be unique Asc NAME

Relationships

Close relationships within degrees of separation