os_published_cp_events

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_published_cp_reviewers.PUBLISH_EVENT_ID FK_PUBLISHED_CP_EVENTR
COLLECTION_PROTOCOL_ID BIGINT 19 null
catissue_collection_protocol.IDENTIFIER FK_PUBLISHED_EVENT_CP_IDR
PUBLISHED_BY BIGINT 19 null
catissue_user.IDENTIFIER FK_PUBLISHED_EVENT_USERR
PUBLICATION_DATE TIMESTAMP 19 null
CHANGES VARCHAR 1024 null
REASON VARCHAR 1024 null
VERSION_ID BIGINT 19 null
os_published_cp_versions.IDENTIFIER FK_PUBLISHED_EVENT_VERSIONR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_PUBLISHED_EVENT_CP_ID Performance Asc COLLECTION_PROTOCOL_ID
FK_PUBLISHED_EVENT_USER Performance Asc PUBLISHED_BY
FK_PUBLISHED_EVENT_VERSION Performance Asc VERSION_ID

Relationships

Close relationships within degrees of separation