os_dp_requirements

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_dpr_pathology_statuses.DPR_ID OS_FK_DPR_PATH_DPR_IDR
DP_ID BIGINT 19 null
catissue_distribution_protocol.IDENTIFIER FK_OS_DP_REQ_DP_IDR
SPECIMEN_TYPE VARCHAR 50 √ null
ANATOMIC_SITE VARCHAR 150 √ null
SPECIMEN_COUNT BIGINT 19 √ null
QUANTITY DECIMAL 24,8 √ null
COMMENTS VARCHAR 255 √ null
ACTIVITY_STATUS VARCHAR 16 null
CLINICAL_DAIGNOSIS VARCHAR 255 √ null
COST DOUBLE 22 √ null
SPECIMEN_TYPE_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_DPR_SPECIMEN_TYPER
ANATOMIC_SITE_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_DPR_ANATOMIC_SITER
CLINICAL_DIAGNOSIS_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_DPR_CLINICAL_DIAGNOSISR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_DPR_ANATOMIC_SITE Performance Asc ANATOMIC_SITE_ID
FK_DPR_CLINICAL_DIAGNOSIS Performance Asc CLINICAL_DIAGNOSIS_ID
FK_DPR_SPECIMEN_TYPE Performance Asc SPECIMEN_TYPE_ID
FK_OS_DP_REQ_DP_ID Performance Asc DP_ID

Relationships

Close relationships within degrees of separation