Tool Dataprivacy Ctxlevel Table Schema (tool_dataprivacy_ctxlevel)


Description

Default comment for the table, please edit me

tool_dataprivacy_ctxlevel table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
contextlevel SMALLINT 5 null
purposeid BIGINT 19 √ null
tool_dataprivacy_purpose.id tooldatactxl_pur2_fk R
categoryid BIGINT 19 √ null
tool_dataprivacy_category.id tooldatactxl_cat2_fk R
usermodified BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null

Table contained -1 rows

tool_dataprivacy_ctxlevel table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tooldatactxl_cat_ix Performance Asc categoryid
tooldatactxl_con_uix Must be unique Asc contextlevel
tooldatactxl_pur_ix Performance Asc purposeid

tool_dataprivacy_ctxlevel table relationships

Close relationships within degrees of separation