Tool Dataprivacy Ctxexpired Table Schema (tool_dataprivacy_ctxexpired)


Description

Default comment for the table, please edit me

tool_dataprivacy_ctxexpired table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
contextid BIGINT 19 null
context.id Implied Constraint R
unexpiredroles LONGTEXT 2147483647 null

Roles which have explicitly not expired yet.

expiredroles LONGTEXT 2147483647 null

Explicitly expires roles

defaultexpired BIT 1 null

The default retention period has passed.

status TINYINT 3 0
usermodified BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null

Table contained -1 rows

tool_dataprivacy_ctxexpired table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tooldatactxe_con_uix Must be unique Asc contextid

tool_dataprivacy_ctxexpired table relationships