catissue_permissible_value

91363 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CONCEPT_CODE VARCHAR 40 √ null
DEFINITION TEXT 65535 √ null
PARENT_IDENTIFIER BIGINT 19 √ null
catissue_permissible_value.identifier FK_PV_PARENT_IDR
value VARCHAR 255 √ null
PUBLIC_ID VARCHAR 30 √ null
catissue_cde.PUBLIC_ID FK57DDCE1FC56C2B1R
SORTORDER BIGINT 19 √ null
identifier BIGINT 19 √ null
catissue_coll_event_param.COLLECTION_CONTAINER_ID FK_SPMN_COLL_CONTR
catissue_coll_event_param.COLLECTION_PROCEDURE_ID FK_SPMN_COLL_PROCR
catissue_coll_prot_event.CLINICAL_DIAGNOSIS_ID FK_CPE_CLINICAL_DIAGNOSISR
catissue_coll_prot_event.CLINICAL_STATUS_ID FK_CPE_CLINICAL_STATUSR
catissue_consent_tier_response.RESPONSE_ID FK_CONSENT_RESPR
catissue_cp_req_specimen.ANATOMIC_SITE_ID FK_SPMN_REQ_ANATOMIC_SITER
catissue_cp_req_specimen.COLLECTION_CONTAINER_ID FK_SPMN_REQ_COLL_CONTR
catissue_cp_req_specimen.COLLECTION_PROCEDURE_ID FK_SPMN_REQ_COLL_PROCR
catissue_cp_req_specimen.LATERALITY_ID FK_SPMN_REQ_LATERALITYR
catissue_cp_req_specimen.PATHOLOGICAL_STATUS_ID FK_SPMN_REQ_PATH_STATUSR
catissue_cp_req_specimen.SPECIMEN_CLASS_ID FK_SPMN_REQ_CLASSR
catissue_cp_req_specimen.SPECIMEN_TYPE_ID FK_SPMN_REQ_TYPER
catissue_embedded_event_param.EMBEDDING_MEDIUM_ID FK_SPE_EMBEDDING_MEDIUMR
catissue_fixed_event_param.FIXATION_TYPE_ID FK_SPE_FIXATION_TYPER
catissue_frozen_event_param.METHOD_ID FK_SPE_FROZEN_METHODR
catissue_participant.GENDER_ID FK_PART_GENDERR
catissue_participant.VITAL_STATUS_ID FK_PART_VITAL_STATUSR
catissue_permissible_value.PARENT_IDENTIFIER FK_PV_PARENT_IDR
catissue_race.RACE_ID FK_PART_RACE_IDR
catissue_received_event_param.RECEIVED_QUALITY_ID FK_SPMN_RECV_QUALITYR
catissue_site.TYPE_ID FK_SITE_TYPER
catissue_specimen.ANATOMIC_SITE_ID FK_SPMN_ANATOMIC_SITER
catissue_specimen.LATERALITY_ID FK_SPMN_LATERALITYR
catissue_specimen.PATHOLOGICAL_STATUS_ID FK_SPMN_PATH_STATUSR
catissue_specimen.SPECIMEN_CLASS_ID FK_SPMN_CLASSR
catissue_specimen.SPECIMEN_TYPE_ID FK_SPMN_TYPER
catissue_specimen_coll_group.CLINICAL_STATUS_ID FK_VISIT_CLINICAL_STATUSR
catissue_specimen_coll_group.COHORT_ID FK_VISIT_COHORTR
catissue_specimen_coll_group.MISSED_REASON_ID FK_VISIT_MISSED_REASONR
catissue_tis_spe_event_param.HISTOLOGICAL_QUALITY_ID FK_SPE_HIST_QUALITYR
catissue_user.DEFAULT_PRINTER_ID FK_USER_PRINTERR
os_cpr_recs.GENDER_ID FK_QUERY_CPR_RECS_GENDERR
os_cpr_recs.VITAL_STATUS_ID FK_QUERY_CPR_RECS_VSTATUSR
os_dist_services.TYPE_ID FK_DIST_SERVICE_TYPER
os_dp_requirements.ANATOMIC_SITE_ID FK_DPR_ANATOMIC_SITER
os_dp_requirements.CLINICAL_DIAGNOSIS_ID FK_DPR_CLINICAL_DIAGNOSISR
os_dp_requirements.SPECIMEN_TYPE_ID FK_DPR_SPECIMEN_TYPER
os_dpr_pathology_statuses.PATHOLOGY_STATUS_ID FK_DPR_PATH_STATUSR
os_dq_queries.RESOLUTION_ID FK_DQ_QUERY_RESOLUTIONR
os_participant_ethnicities.ETHNICITY_ID FK_PART_ETHNICITY_IDR
os_pv_props.PV_ID FK_PV_PROPS_PV_IDR
os_pvs_hierarchy.ANCESTOR_ID FK_PV_HIERARCHY_ANCESTORR
os_pvs_hierarchy.DESCENDANT_ID FK_PV_HIERARCHY_DESCENDANTR
os_shipment_containers.RECEIVED_QUALITY_ID FK_SHIP_CONT_RECV_QLTYR
os_shipment_specimens.RECEIVED_QUALITY_ID FK_SHIP_SPMN_RECV_QLTYR
os_shipments.REQUEST_STATUS FK_SHIPMENT_REQ_STATUSR
os_specimen_biohazards.BIOHAZARD_ID FK_SPMN_BIOHAZARDR
os_specimen_type_units.CONCENTRATION_UNIT_ID FK_SPMN_TYPE_UNIT_CONC_IDR
os_specimen_type_units.QUANTITY_UNIT_ID FK_SPMN_TYPE_UNIT_QTY_IDR
os_specimen_type_units.SPECIMEN_CLASS_ID FK_SPMN_TYPE_UNIT_CLASS_IDR
os_specimen_type_units.SPECIMEN_TYPE_ID FK_SPMN_TYPE_UNIT_TYPE_IDR
os_staged_part_ethnicities.ETHNICITY_ID FK_STG_PART_ETHNICITY_IDR
os_staged_participant_races.RACE_ID FK_STG_PART_RACE_IDR
os_staged_participants.GENDER_ID FK_STG_PART_GENDERR
os_staged_participants.VITAL_STATUS_ID FK_STG_PART_VITAL_STATUSR
os_stor_cont_comp_spec_classes.SPECIMEN_CLASS_ID FK_CONT_COMP_SPMN_CLASSR
os_stor_cont_comp_spec_types.SPECIMEN_TYPE_ID FK_CONT_COMP_SPMN_TYPER
os_stor_cont_spec_classes.SPECIMEN_CLASS_ID FK_CONT_SPMN_CLASSR
os_stor_cont_spec_types.SPECIMEN_TYPE_ID FK_CONT_SPMN_TYPER
os_supply_items.REASON_ID FK_SUPPLY_ITEM_CONSUME_REASONR
os_visit_clin_diagnoses.CLINICAL_DIAGNOSIS_ID FK_VISIT_CLINICAL_DIAGNOSISR
ACTIVITY_STATUS VARCHAR 16 Active

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
FK_PV_PARENT_ID Performance Asc PARENT_IDENTIFIER
PV_ATTR_VALUE_IDX Performance Asc/Asc PUBLIC_ID + value

Relationships

Close relationships within degrees of separation