Tool Dataprivacy Rqst Ctxlst Table Schema (tool_dataprivacy_rqst_ctxlst)


Description

Association table joining requests and contextlists

tool_dataprivacy_rqst_ctxlst table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
requestid BIGINT 19 null
tool_dataprivacy_request.id tooldatarqstctxl_req2_fk R
contextlistid BIGINT 19 null
tool_dataprivacy_contextlist.id tooldatarqstctxl_con2_fk R

Table contained -1 rows

tool_dataprivacy_rqst_ctxlst table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tooldatarqstctxl_con_ix Performance Asc contextlistid
tooldatarqstctxl_req_ix Performance Asc requestid
tooldatarqstctxl_reqcon_uix Must be unique Asc/Asc requestid + contextlistid

tool_dataprivacy_rqst_ctxlst table relationships