catissue_specimenlist_tags

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_spec_tag_items.TAG_ID FK_SPECLIST_TAGITEM_TAG_IDR
os_cart_folder_carts.CART_ID FK_CART_FOLDER_CARTS_CARTR
os_orders.CLEAR_LIST_ID FK_DO_CLEAR_LIST_IDR
os_orders.SPECIMEN_LIST_ID FK_OS_DO_SPMN_LIST_IDR
os_specimen_deposits.LIST_ID FK_OS_SPMN_DEPS_LISTR
os_specimen_list_shared_groups.LIST_ID FK_SPMN_LIST_SHR_GRP_LIST_IDR
shared_specimenlist_tags.TAG_ID FK_SHARESPECIMENLIST_USER_IDR
TAG_LABEL VARCHAR 255 null
USER_ID BIGINT 19 null
catissue_user.IDENTIFIER FK_SPECLIST_USER_IDR
DELETED_ON TIMESTAMP 19 √ null
DESCRIPTION TEXT 65535 √ null
CREATED_ON TIMESTAMP 19 CURRENT_TIMESTAMP
LAST_UPDATED_ON TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_SPECLIST_USER_ID Performance Asc USER_ID
SPECLIST_TAGLABEL_UNIQUE_KEY Must be unique Asc/Asc TAG_LABEL + USER_ID

Relationships

Close relationships within degrees of separation