catissue_query_folders

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_qfolder_share_setting.FOLDER_ID CAT_QFSS_FOLDER_ID_CAT_QF_IDR
catissue_query_folder_queries.FOLDER_ID CAT_QFQ_FOLDER_ID_CAT_QF_IDR
os_query_folder_shared_groups.FOLDER_ID FK_QFOLDER_SHR_GRP_FOLDER_IDR
NAME VARCHAR 64 null
OWNER BIGINT 19 null
catissue_user.IDENTIFIER CAT_QF_OWNER_CAT_USR_IDR
SHARED_WITH_ALL BIT 1 √ null
ALLOW_EDITS_BY_SHARED_USERS BIT 1 √ b'0'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
CAT_QF_OWNER_CAT_USR_ID Performance Asc OWNER
NAME Must be unique Asc NAME

Relationships

Close relationships within degrees of separation