os_cp_report_settings

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_cp_report_rcpts.REPORT_ID FK_CP_RPT_RCPTS_RPT_IDR
CP_ID BIGINT 19 null
catissue_collection_protocol.IDENTIFIER FK_CP_RPT_SETTINGS_CP_IDR
ENABLED BIT 1 b'1'
DATA_QUERY_ID BIGINT 19 √ null
catissue_saved_queries.IDENTIFIER FK_CP_RPT_SETTINGS_QUERY_IDR
CONFIG TEXT 65535 √ null
EMAIL_TMPL TEXT 65535 √ null
ACTIVITY_STATUS VARCHAR 16 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_CP_RPT_SETTINGS_CP_ID Performance Asc CP_ID
FK_CP_RPT_SETTINGS_QUERY_ID Performance Asc DATA_QUERY_ID

Relationships

Close relationships within degrees of separation