   ON UPDATE NO ACTION
 );
 
-DROP TABLE IF EXISTS DM_ROLE_POLICY;
 CREATE  TABLE DM_ROLE_POLICY (
   ID BIGSERIAL NOT NULL PRIMARY KEY,
   ROLE_NAME VARCHAR(45) NOT NULL ,

    DM_DEVICE (ID) ON DELETE NO ACTION ON UPDATE NO ACTION
);

DROP TABLE IF EXISTS DM_APPLICATION;
CREATE TABLE DM_APPLICATION (
  ID BIGSERIAL NOT NULL PRIMARY KEY,
  NAME VARCHAR(50) NOT NULL,
  APP_IDENTIFIER VARCHAR(150) NOT NULL,

);
CREATE UNIQUE INDEX DEVICE_ID_UNIQUE ON DM_POLICY_COMPLIANCE_STATUS (DEVICE_ID ASC);

CREATE TABLE IF NOT EXISTS  DM_POLICY_CHANGE_MGT (
  ID BIGSERIAL NOT NULL PRIMARY KEY,
  POLICY_ID INTEGER NOT NULL,
  DEVICE_TYPE_ID INTEGER NOT NULL,
  TENANT_ID INTEGER NOT NULL
);

CREATE TABLE IF NOT EXISTS  DM_POLICY_COMPLIANCE_FEATURES (
  ID BIGSERIAL NOT NULL PRIMARY KEY,
  COMPLIANCE_STATUS_ID INTEGER NOT NULL,
  TENANT_ID INTEGER NOT NULL,
