os_specimen_type_units

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
CP_ID BIGINT 19 √ null
catissue_collection_protocol.IDENTIFIER FK_SPMN_TYPE_UNIT_CP_IDR
SPECIMEN_CLASS_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_TYPE_UNIT_CLASS_IDR
SPECIMEN_TYPE_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_TYPE_UNIT_TYPE_IDR
QUANTITY_UNIT_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_TYPE_UNIT_QTY_IDR
CONCENTRATION_UNIT_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SPMN_TYPE_UNIT_CONC_IDR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_SPMN_TYPE_UNIT_CLASS_ID Performance Asc SPECIMEN_CLASS_ID
FK_SPMN_TYPE_UNIT_CONC_ID Performance Asc CONCENTRATION_UNIT_ID
FK_SPMN_TYPE_UNIT_CP_ID Performance Asc CP_ID
FK_SPMN_TYPE_UNIT_QTY_ID Performance Asc QUANTITY_UNIT_ID
FK_SPMN_TYPE_UNIT_TYPE_ID Performance Asc SPECIMEN_TYPE_ID

Relationships

Close relationships within degrees of separation