catissue_site_cp

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SITE_ID BIGINT 19 0
catissue_site.IDENTIFIER FK_SITE_CP_SITE_IDR
COLLECTION_PROTOCOL_ID BIGINT 19 0
catissue_collection_protocol.IDENTIFIER FK_SITE_CP_COLL_PROT_IDR
IDENTIFIER BIGINT 19 √ null
CODE VARCHAR 16 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_SITE_CP_COLL_PROT_ID Performance Asc COLLECTION_PROTOCOL_ID
OS_CP_SITE_SITE_ID_CP_ID_UQ Must be unique Asc/Asc SITE_ID + COLLECTION_PROTOCOL_ID

Relationships

Close relationships within degrees of separation