os_specimen_kits

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_kit_specimens.KIT_ID FK_KIT_SPECIMENS_KIT_IDR
CP_ID BIGINT 19 null
catissue_collection_protocol.IDENTIFIER FK_SPMN_KIT_CP_IDR
SENDING_SITE_ID BIGINT 19 null
catissue_site.IDENTIFIER FK_SPMN_KIT_SENDING_SITE_IDR
RECEIVING_SITE_ID BIGINT 19 null
catissue_site.IDENTIFIER FK_SPMN_KIT_RECEIVING_SITE_IDR
SENDER_ID BIGINT 19 null
catissue_user.IDENTIFIER FK_SPMN_KIT_SENDER_IDR
SENDING_DATE TIMESTAMP 19 null
COMMENTS VARCHAR 255 √ null
ACTIVITY_STATUS VARCHAR 64 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_SPMN_KIT_CP_ID Performance Asc CP_ID
FK_SPMN_KIT_RECEIVING_SITE_ID Performance Asc RECEIVING_SITE_ID
FK_SPMN_KIT_SENDER_ID Performance Asc SENDER_ID
FK_SPMN_KIT_SENDING_SITE_ID Performance Asc SENDING_SITE_ID

Relationships

Close relationships within degrees of separation