os_spmn_reserved_events

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_specimen.RESERVED_EVENT_ID FK_SPMN_RESERVE_EVENT_IDR
os_spmn_reserved_events.CANCELLED_EVENT_ID FK_CANCELLED_RESERVE_EVENT_IDR
SPECIMEN_ID BIGINT 19 null
catissue_specimen.IDENTIFIER FK_RESERVED_SPMN_IDR
DP_ID BIGINT 19 null
catissue_distribution_protocol.IDENTIFIER FK_RESERVED_FOR_DP_IDR
CANCELLED_EVENT_ID BIGINT 19 √ null
os_spmn_reserved_events.IDENTIFIER FK_CANCELLED_RESERVE_EVENT_IDR
USER_ID BIGINT 19 null
EVENT_TIME TIMESTAMP 19 null
COMMENTS VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_CANCELLED_RESERVE_EVENT_ID Performance Asc CANCELLED_EVENT_ID
FK_RESERVED_FOR_DP_ID Performance Asc DP_ID
FK_RESERVED_SPMN_ID Performance Asc SPECIMEN_ID

Relationships

Close relationships within degrees of separation