CM_* — Consent management¶

10 tables in APIM 3.2.0.

CM_CONSENT_RECEIPT_PROPERTY¶

APIM DB (WSO2AM_DB) · PK: — · Unique: CONSENT_RECEIPT_ID, NAME

Column	Type	Notes
`CONSENT_RECEIPT_ID`	`VARCHAR(255)`	FK → CM_RECEIPT · NOT NULL
`NAME`	`VARCHAR(255)`	NOT NULL
`VALUE`	`VARCHAR(1023)`	NOT NULL

Foreign keys

CONSENT_RECEIPT_ID → CM_RECEIPT CONSENT_RECEIPT_ID

CM_PII_CATEGORY¶

APIM DB (WSO2AM_DB) · PK: ID · Unique: NAME, TENANT_ID

Column	Type	Notes
`ID`	`INTEGER`	PK · AUTO_INCREMENT
`NAME`	`VARCHAR(255)`	NOT NULL
`DESCRIPTION`	`VARCHAR(1023)`
`DISPLAY_NAME`	`VARCHAR(255)`
`IS_SENSITIVE`	`INTEGER`	NOT NULL
`TENANT_ID`	`INTEGER`	DEFAULT '-1234'

Referenced by

CM_SP_PURPOSE_PII_CAT_ASSOC via PII_CATEGORY_ID

CM_PURPOSE¶

APIM DB (WSO2AM_DB) · PK: ID · Unique: NAME, TENANT_ID, PURPOSE_GROUP, GROUP_TYPE

Column	Type	Notes
`ID`	`INTEGER`	PK · AUTO_INCREMENT
`NAME`	`VARCHAR(255)`	NOT NULL
`DESCRIPTION`	`VARCHAR(1023)`
`PURPOSE_GROUP`	`VARCHAR(255)`	NOT NULL
`GROUP_TYPE`	`VARCHAR(255)`	NOT NULL
`TENANT_ID`	`INTEGER`	DEFAULT '-1234'

Referenced by

CM_SP_PURPOSE_ASSOC via PURPOSE_ID

CM_PURPOSE_CATEGORY¶

APIM DB (WSO2AM_DB) · PK: ID · Unique: NAME, TENANT_ID

Column	Type	Notes
`ID`	`INTEGER`	PK · AUTO_INCREMENT
`NAME`	`VARCHAR(255)`	NOT NULL
`DESCRIPTION`	`VARCHAR(1023)`
`TENANT_ID`	`INTEGER`	DEFAULT '-1234'

Referenced by

CM_SP_PURPOSE_PURPOSE_CAT_ASSC via PURPOSE_CATEGORY_ID

CM_PURPOSE_PII_CAT_ASSOC¶

APIM DB (WSO2AM_DB) · PK: — · Unique: PURPOSE_ID, CM_PII_CATEGORY_ID

Column	Type	Notes
`PURPOSE_ID`	`INTEGER`	NOT NULL
`CM_PII_CATEGORY_ID`	`INTEGER`	NOT NULL
`IS_MANDATORY`	`INTEGER`	NOT NULL

CM_RECEIPT¶

APIM DB (WSO2AM_DB) · PK: CONSENT_RECEIPT_ID

Column	Type	Notes
`CONSENT_RECEIPT_ID`	`VARCHAR(255)`	PK · NOT NULL
`VERSION`	`VARCHAR(255)`	NOT NULL
`JURISDICTION`	`VARCHAR(255)`	NOT NULL
`CONSENT_TIMESTAMP`	`TIMESTAMP`	NOT NULL
`COLLECTION_METHOD`	`VARCHAR(255)`	NOT NULL
`LANGUAGE`	`VARCHAR(255)`	NOT NULL
`PII_PRINCIPAL_ID`	`VARCHAR(255)`	NOT NULL
`PRINCIPAL_TENANT_ID`	`INTEGER`	DEFAULT '-1234'
`POLICY_URL`	`VARCHAR(255)`	NOT NULL
`STATE`	`VARCHAR(255)`	NOT NULL
`PII_CONTROLLER`	`VARCHAR(2048)`	NOT NULL

Referenced by

CM_CONSENT_RECEIPT_PROPERTY via CONSENT_RECEIPT_ID
CM_RECEIPT_SP_ASSOC via CONSENT_RECEIPT_ID

CM_RECEIPT_SP_ASSOC¶

APIM DB (WSO2AM_DB) · PK: ID · Unique: CONSENT_RECEIPT_ID, SP_NAME, SP_TENANT_ID

Column	Type	Notes
`ID`	`INTEGER`	PK · AUTO_INCREMENT
`CONSENT_RECEIPT_ID`	`VARCHAR(255)`	FK → CM_RECEIPT · NOT NULL
`SP_NAME`	`VARCHAR(255)`	NOT NULL
`SP_DISPLAY_NAME`	`VARCHAR(255)`
`SP_DESCRIPTION`	`VARCHAR(255)`
`SP_TENANT_ID`	`INTEGER`	DEFAULT '-1234'

Foreign keys

CONSENT_RECEIPT_ID → CM_RECEIPT CONSENT_RECEIPT_ID

Referenced by

CM_SP_PURPOSE_ASSOC via RECEIPT_SP_ASSOC

CM_SP_PURPOSE_ASSOC¶

APIM DB (WSO2AM_DB) · PK: ID · Unique: RECEIPT_SP_ASSOC, PURPOSE_ID

Column	Type	Notes
`ID`	`INTEGER`	PK · AUTO_INCREMENT
`RECEIPT_SP_ASSOC`	`INTEGER`	FK → CM_RECEIPT_SP_ASSOC · NOT NULL
`PURPOSE_ID`	`INTEGER`	FK → CM_PURPOSE · NOT NULL
`CONSENT_TYPE`	`VARCHAR(255)`	NOT NULL
`IS_PRIMARY_PURPOSE`	`INTEGER`	NOT NULL
`TERMINATION`	`VARCHAR(255)`	NOT NULL
`THIRD_PARTY_DISCLOSURE`	`INTEGER`	NOT NULL
`THIRD_PARTY_NAME`	`VARCHAR(255)`

Foreign keys

RECEIPT_SP_ASSOC → CM_RECEIPT_SP_ASSOC ID
PURPOSE_ID → CM_PURPOSE ID

Referenced by

CM_SP_PURPOSE_PII_CAT_ASSOC via SP_PURPOSE_ASSOC_ID
CM_SP_PURPOSE_PURPOSE_CAT_ASSC via SP_PURPOSE_ASSOC_ID

CM_SP_PURPOSE_PII_CAT_ASSOC¶

APIM DB (WSO2AM_DB) · PK: — · Unique: SP_PURPOSE_ASSOC_ID, PII_CATEGORY_ID

Column	Type	Notes
`SP_PURPOSE_ASSOC_ID`	`INTEGER`	FK → CM_SP_PURPOSE_ASSOC · NOT NULL
`PII_CATEGORY_ID`	`INTEGER`	FK → CM_PII_CATEGORY · NOT NULL
`VALIDITY`	`VARCHAR(1023)`

Foreign keys

SP_PURPOSE_ASSOC_ID → CM_SP_PURPOSE_ASSOC ID
PII_CATEGORY_ID → CM_PII_CATEGORY ID

CM_SP_PURPOSE_PURPOSE_CAT_ASSC¶

APIM DB (WSO2AM_DB) · PK: — · Unique: SP_PURPOSE_ASSOC_ID, PURPOSE_CATEGORY_ID

Column	Type	Notes
`SP_PURPOSE_ASSOC_ID`	`INTEGER`	FK → CM_SP_PURPOSE_ASSOC · NOT NULL
`PURPOSE_CATEGORY_ID`	`INTEGER`	FK → CM_PURPOSE_CATEGORY · NOT NULL

Foreign keys

SP_PURPOSE_ASSOC_ID → CM_SP_PURPOSE_ASSOC ID
PURPOSE_CATEGORY_ID → CM_PURPOSE_CATEGORY ID