text: CREATE TABLE CM_PII_CATEGORY (
    ID           INTEGER,
    NAME         VARCHAR2(255) NOT NULL,
    DESCRIPTION  VARCHAR2(1023),
    DISPLAY_NAME VARCHAR(255),
    IS_SENSITIVE INTEGER       NOT NULL,
    TENANT_ID    INTEGER DEFAULT -1234,
    CONSTRAINT PII_CATEGORY_CONSTRAINT UNIQUE (NAME, TENANT_ID),
    PRIMARY KEY (ID)
  )
  /
  CREATE SEQUENCE CM_PII_CATEGORY_SEQ START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
  /
  CREATE OR REPLACE TRIGGER CM_PII_CATEGORY_TRIG
    BEFORE INSERT
    ON CM_PII_CATEGORY
    REFERENCING NEW AS NEW
    FOR EACH ROW
    BEGIN
      SELECT CM_PII_CATEGORY_SEQ.nextval INTO :NEW.ID FROM dual;
    END;
  /
  CREATE TABLE CM_RECEIPT (
    CONSENT_RECEIPT_ID  VARCHAR2(255) NOT NULL,
    VERSION             VARCHAR2(255) NOT NULL,
    JURISDICTION        VARCHAR2(255) NOT NULL,
    CONSENT_TIMESTAMP   TIMESTAMP     NOT NULL,
    COLLECTION_METHOD   VARCHAR2(255) NOT NULL,
    LANGUAGE            VARCHAR2(255) NOT NULL,
    PII_PRINCIPAL_ID    VARCHAR2(255) NOT NULL,
    PRINCIPAL_TENANT_ID INTEGER DEFAULT -1234,
    POLICY_URL          VARCHAR2(255) NOT NULL,
    STATE               VARCHAR2(255) NOT NULL,
    PII_CONTROLLER      VARCHAR2(2048) NOT NULL,
    PRIMARY KEY (CONSENT_RECEIPT_ID)
  )
  /
  CREATE TABLE CM_PURPOSE (
    ID            INTEGER,
    NAME          VARCHAR2(255) NOT NULL,
    DESCRIPTION   VARCHAR2(1023),
    PURPOSE_GROUP VARCHAR2(255) NOT NULL,
    GROUP_TYPE    VARCHAR2(255) NOT NULL,
    TENANT_ID     INTEGER DEFAULT -1234,
    CONSTRAINT PURPOSE_CONSTRAINT UNIQUE (NAME, TENANT_ID, PURPOSE_GROUP, GROUP_TYPE),
    PRIMARY KEY (ID)
  )
  /
  CREATE SEQUENCE CM_PURPOSE_SEQ START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
  /
  CREATE OR REPLACE TRIGGER CM_PURPOSE_TRIG
    BEFORE INSERT
    ON CM_PURPOSE
    REFERENCING NEW AS NEW
    FOR EACH ROW
    BEGIN
      SELECT CM_PURPOSE_SEQ.nextval INTO :NEW.ID FROM dual;
    END;
  /
  CREATE TABLE CM_PURPOSE_CATEGORY (
    ID          INTEGER,
    NAME        VARCHAR2(255) NOT NULL,
    DESCRIPTION VARCHAR2(1023),
    TENANT_ID   INTEGER DEFAULT -1234,
    CONSTRAINT PURPOSE_CATEGORY_CONSTRAINT UNIQUE (NAME, TENANT_ID),
    PRIMARY KEY (ID)
  )
  /
  CREATE SEQUENCE CM_PURPOSE_CATEGORY_SEQ START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
  /
  CREATE OR REPLACE TRIGGER CM_PURPOSE_CATEGORY_TRIG
    BEFORE INSERT
    ON CM_PURPOSE_CATEGORY
    REFERENCING NEW AS NEW
    FOR EACH ROW
    BEGIN
      SELECT CM_PURPOSE_CATEGORY_SEQ.nextval INTO :NEW.ID FROM dual;
    END;
  /
  CREATE TABLE CM_RECEIPT_SP_ASSOC (
    ID                 INTEGER,
    CONSENT_RECEIPT_ID VARCHAR2(255) NOT NULL,
    SP_NAME            VARCHAR2(255) NOT NULL,
    SP_DISPLAY_NAME    VARCHAR(255),
    SP_DESCRIPTION     VARCHAR(255),
    SP_TENANT_ID       INTEGER DEFAULT -1234,
    CONSTRAINT RECEIPT_SP_ASSOC_CONSTRAINT UNIQUE (CONSENT_RECEIPT_ID, SP_NAME, SP_TENANT_ID),
    PRIMARY KEY (ID)
  )
  /
  CREATE SEQUENCE CM_RECEIPT_SP_ASSOC_SEQ START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
  /
  CREATE OR REPLACE TRIGGER CM_RECEIPT_SP_ASSOC_TRIG
    BEFORE INSERT
    ON CM_RECEIPT_SP_ASSOC
    REFERENCING NEW AS NEW
    FOR EACH ROW
    BEGIN
      SELECT CM_RECEIPT_SP_ASSOC_SEQ.nextval INTO :NEW.ID FROM dual;
    END;
  /
  CREATE TABLE CM_SP_PURPOSE_ASSOC (
    ID                     INTEGER,
    RECEIPT_SP_ASSOC       INTEGER       NOT NULL,
    PURPOSE_ID             INTEGER       NOT NULL,
    CONSENT_TYPE           VARCHAR2(255) NOT NULL,
    IS_PRIMARY_PURPOSE     INTEGER       NOT NULL,
    TERMINATION            VARCHAR2(255) NOT NULL,
    THIRD_PARTY_DISCLOSURE INTEGER       NOT NULL,
    THIRD_PARTY_NAME       VARCHAR2(255),
    CONSTRAINT SP_PURPOSE_ASSOC UNIQUE (RECEIPT_SP_ASSOC, PURPOSE_ID),
    PRIMARY KEY (ID)
  )
  /
  CREATE SEQUENCE CM_SP_PURPOSE_ASSOC_SEQ START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
  /
  CREATE OR REPLACE TRIGGER CM_SP_PURPOSE_ASSOC_TRIG
    BEFORE INSERT
    ON CM_SP_PURPOSE_ASSOC
    REFERENCING NEW AS NEW
    FOR EACH ROW
    BEGIN
      SELECT CM_SP_PURPOSE_ASSOC_SEQ.nextval INTO :NEW.ID FROM dual;
    END;
  /
  CREATE TABLE CM_SP_PURPOSE_PURPOSE_CAT_ASSC (
    SP_PURPOSE_ASSOC_ID INTEGER NOT NULL,
    PURPOSE_CATEGORY_ID INTEGER NOT NULL,
    CONSTRAINT SP_PUS_PS_CAT_ASSOC UNIQUE (SP_PURPOSE_ASSOC_ID, PURPOSE_CATEGORY_ID)
  )
  /
  CREATE TABLE CM_PURPOSE_PII_CAT_ASSOC (
    PURPOSE_ID         INTEGER NOT NULL,
    CM_PII_CATEGORY_ID INTEGER NOT NULL,
    IS_MANDATORY       INTEGER NOT NULL,
    CONSTRAINT PURPOSE_PII_CAT_ASSOC UNIQUE (PURPOSE_ID, CM_PII_CATEGORY_ID)
  )
  /
  CREATE TABLE CM_SP_PURPOSE_PII_CAT_ASSOC (
    SP_PURPOSE_ASSOC_ID INTEGER NOT NULL,
    PII_CATEGORY_ID     INTEGER NOT NULL,
    VALIDITY            VARCHAR(1023),
    CONSTRAINT SP_PURPOSE_PII_CATEGORY_ASSOC UNIQUE (SP_PURPOSE_ASSOC_ID, PII_CATEGORY_ID)
  )
  /
  CREATE TABLE CM_CONSENT_RECEIPT_PROPERTY (
    CONSENT_RECEIPT_ID VARCHAR2(255)  NOT NULL,
    NAME               VARCHAR2(255)  NOT NULL,
    VALUE              VARCHAR2(1023) NOT NULL,
    CONSTRAINT CONSENT_RECEIPT_PROPERTY UNIQUE (CONSENT_RECEIPT_ID, NAME)
  )
  /
  ALTER TABLE CM_RECEIPT_SP_ASSOC
    ADD CONSTRAINT CM_RECEIPT_SP_ASSOC_fk0 FOREIGN KEY (CONSENT_RECEIPT_ID) REFERENCES CM_RECEIPT (CONSENT_RECEIPT_ID)
  /
  ALTER TABLE CM_SP_PURPOSE_ASSOC
    ADD CONSTRAINT CM_SP_PURPOSE_ASSOC_fk0 FOREIGN KEY (RECEIPT_SP_ASSOC) REFERENCES CM_RECEIPT_SP_ASSOC (ID)
  /
  ALTER TABLE CM_SP_PURPOSE_ASSOC
    ADD CONSTRAINT CM_SP_PURPOSE_ASSOC_fk1 FOREIGN KEY (PURPOSE_ID) REFERENCES CM_PURPOSE (ID)
  /
  ALTER TABLE CM_SP_PURPOSE_PURPOSE_CAT_ASSC
    ADD CONSTRAINT CM_SP_P_P_CAT_ASSOC_fk0 FOREIGN KEY (SP_PURPOSE_ASSOC_ID) REFERENCES CM_SP_PURPOSE_ASSOC (ID)
  /
  ALTER TABLE CM_SP_PURPOSE_PURPOSE_CAT_ASSC
    ADD CONSTRAINT CM_SP_P_P_CAT_ASSOC_fk1 FOREIGN KEY (PURPOSE_CATEGORY_ID) REFERENCES CM_PURPOSE_CATEGORY (ID)
  /
  ALTER TABLE CM_SP_PURPOSE_PII_CAT_ASSOC
    ADD CONSTRAINT CM_SP_P_PII_CAT_ASSOC_fk0 FOREIGN KEY (SP_PURPOSE_ASSOC_ID) REFERENCES CM_SP_PURPOSE_ASSOC (ID)
  /
  ALTER TABLE CM_SP_PURPOSE_PII_CAT_ASSOC
    ADD CONSTRAINT CM_SP_P_PII_CAT_ASSOC_fk1 FOREIGN KEY (PII_CATEGORY_ID) REFERENCES CM_PII_CATEGORY (ID)
  /
  ALTER TABLE CM_CONSENT_RECEIPT_PROPERTY
    ADD CONSTRAINT CM_CONSENT_RECEIPT_PRT_fk0 FOREIGN KEY (CONSENT_RECEIPT_ID) REFERENCES CM_RECEIPT (CONSENT_RECEIPT_ID)
  /
  INSERT INTO CM_PURPOSE (NAME, DESCRIPTION, PURPOSE_GROUP, GROUP_TYPE, TENANT_ID) VALUES ('DEFAULT', 'For core functionalities of the product', 'DEFAULT', 'SP', '-1234')
  /
  INSERT INTO CM_PURPOSE_CATEGORY (NAME, DESCRIPTION, TENANT_ID) VALUES ('DEFAULT','For core functionalities of the product', '-1234')
  /
  