Tool Dataprivacy Ctxinstance Table Schema (tool_dataprivacy_ctxinstance)


Description

Default comment for the table, please edit me

tool_dataprivacy_ctxinstance table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
contextid BIGINT 19 null
context.id Implied Constraint R
purposeid BIGINT 19 √ null
tool_dataprivacy_purpose.id tooldatactxi_pur2_fk R
categoryid BIGINT 19 √ null
tool_dataprivacy_category.id tooldatactxi_cat2_fk R
usermodified BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null

Table contained -1 rows

tool_dataprivacy_ctxinstance table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tooldatactxi_cat_ix Performance Asc categoryid
tooldatactxi_con_uix Must be unique Asc contextid
tooldatactxi_pur_ix Performance Asc purposeid

tool_dataprivacy_ctxinstance table relationships

Close relationships within degrees of separation