catissue_spec_tag_items

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TAG_ID BIGINT 19 null
catissue_specimenlist_tags.IDENTIFIER FK_SPECLIST_TAGITEM_TAG_IDR
OBJ_ID BIGINT 19 null
catissue_specimen.IDENTIFIER FK_SPECLIST_OBJ_IDR
IDENTIFIER BIGINT 19 √ null
ADDED_BY BIGINT 19 √ null
catissue_user.IDENTIFIER FK_CART_ITEMS_ADDED_BYR
ADDED_ON TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_CART_ITEMS_ADDED_BY Performance Asc ADDED_BY
FK_SPECLIST_OBJ_ID Performance Asc OBJ_ID
SPECLIST_TAGID_UNIQUE_KEY Must be unique Asc/Asc TAG_ID + OBJ_ID

Relationships

Close relationships within degrees of separation