-------------------------------------------------------- -------------------------------------------------------- -- DDL for Table OBJETIVOS -------------------------------------------------------- CREATE TABLE "[MIESQUEMA]"."OBJETIVOS" ( "ID_OBJETIVO" VARCHAR2(20 BYTE), "DESC_OBJETIVO" VARCHAR2(50 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "[MIESQUEMA]" ; -------------------------------------------------------- -- DDL for Table ROLES -------------------------------------------------------- CREATE TABLE "[MIESQUEMA]"."ROLES" ( "ID_ROL" VARCHAR2(20 BYTE), "DESCRIPCION" VARCHAR2(50 BYTE), "ROL_PADRE" VARCHAR2(20 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 16384 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "[MIESQUEMA]" ; -------------------------------------------------------- -- DDL for Table ROLES_OBJETIVOS -------------------------------------------------------- CREATE TABLE "[MIESQUEMA]"."ROLES_OBJETIVOS" ( "ID" NUMBER, "ID_ROL" VARCHAR2(20 BYTE), "ID_OBJETIVO" VARCHAR2(20 BYTE), "ACCION" VARCHAR2(20 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "[MIESQUEMA]" ; -------------------------------------------------------- -- DDL for Table ROLES_USUARIO -------------------------------------------------------- CREATE TABLE "[MIESQUEMA]"."ROLES_USUARIO" ( "ID_ROL" VARCHAR2(20 BYTE), "LOGIN" VARCHAR2(30 BYTE), "ID_ROL_USU" NUMBER(19,0) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "[MIESQUEMA]" ; -------------------------------------------------------- -- DDL for Table USUARIOS -------------------------------------------------------- CREATE TABLE "[MIESQUEMA]"."USUARIOS" ( "LOGIN" VARCHAR2(40 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 16384 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "[MIESQUEMA]" ; -------------------------------------------------------- -- DDL for Table USUARIOS_ROLES -------------------------------------------------------- CREATE TABLE "[MIESQUEMA]"."USUARIOS_ROLES" ( "COD_ROL" VARCHAR2(3 BYTE), "COD_USUARIO" VARCHAR2(10 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 16384 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "[MIESQUEMA]" ; -------------------------------------------------------- -- DDL for Index OBJETIVOS_PK -------------------------------------------------------- CREATE UNIQUE INDEX "[MIESQUEMA]"."OBJETIVOS_PK" ON "[MIESQUEMA]"."OBJETIVOS" ("ID_OBJETIVO") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "IND[MIESQUEMA]" ; -------------------------------------------------------- -- DDL for Index ROLES_PK -------------------------------------------------------- CREATE UNIQUE INDEX "[MIESQUEMA]"."ROLES_PK" ON "[MIESQUEMA]"."ROLES" ("ID_ROL") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 32768 NEXT 32768 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "IND[MIESQUEMA]" ; -------------------------------------------------------- -- DDL for Index ROLES_OBJETIVOS_PK -------------------------------------------------------- CREATE UNIQUE INDEX "[MIESQUEMA]"."ROLES_OBJETIVOS_PK" ON "[MIESQUEMA]"."ROLES_OBJETIVOS" ("ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "IND[MIESQUEMA]" ; -------------------------------------------------------- -- DDL for Index ROLES_USUARIO_PK -------------------------------------------------------- CREATE UNIQUE INDEX "[MIESQUEMA]"."ROLES_USUARIO_PK" ON "[MIESQUEMA]"."ROLES_USUARIO" ("ID_ROL_USU") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "IND[MIESQUEMA]" ; -------------------------------------------------------- -- DDL for Index USUARIOS_PK -------------------------------------------------------- CREATE UNIQUE INDEX "[MIESQUEMA]"."USUARIOS_PK" ON "[MIESQUEMA]"."USUARIOS" ("LOGIN") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 32768 NEXT 32768 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "IND[MIESQUEMA]" ; -------------------------------------------------------- -- DDL for Index FK_USU -------------------------------------------------------- CREATE INDEX "[MIESQUEMA]"."FK_USU" ON "[MIESQUEMA]"."USUARIOS_ROLES" ("COD_USUARIO") PCTFREE 0 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 16384 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "IND[MIESQUEMA]" ; -------------------------------------------------------- -- DDL for Index USUARIOS_ROLES_ROL -------------------------------------------------------- CREATE UNIQUE INDEX "[MIESQUEMA]"."USUARIOS_ROLES_ROL" ON "[MIESQUEMA]"."USUARIOS_ROLES" ("COD_ROL", "COD_USUARIO") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 32768 NEXT 32768 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "IND[MIESQUEMA]" ; -------------------------------------------------------- -- Constraints for Table OBJETIVOS -------------------------------------------------------- ALTER TABLE "[MIESQUEMA]"."OBJETIVOS" ADD CONSTRAINT "OBJETIVOS_PK" PRIMARY KEY ("ID_OBJETIVO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "IND[MIESQUEMA]" ENABLE; ALTER TABLE "[MIESQUEMA]"."OBJETIVOS" MODIFY ("ID_OBJETIVO" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table ROLES -------------------------------------------------------- ALTER TABLE "[MIESQUEMA]"."ROLES" ADD CONSTRAINT "PK_ROLES" PRIMARY KEY ("ID_ROL") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 32768 NEXT 32768 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "IND[MIESQUEMA]" ENABLE; ALTER TABLE "[MIESQUEMA]"."ROLES" MODIFY ("ID_ROL" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table ROLES_OBJETIVOS -------------------------------------------------------- ALTER TABLE "[MIESQUEMA]"."ROLES_OBJETIVOS" ADD CONSTRAINT "ROLES_OBJETIVOS_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "IND[MIESQUEMA]" ENABLE; ALTER TABLE "[MIESQUEMA]"."ROLES_OBJETIVOS" MODIFY ("ID" NOT NULL ENABLE); ALTER TABLE "[MIESQUEMA]"."ROLES_OBJETIVOS" MODIFY ("ID_ROL" NOT NULL ENABLE); ALTER TABLE "[MIESQUEMA]"."ROLES_OBJETIVOS" MODIFY ("ID_OBJETIVO" NOT NULL ENABLE); ALTER TABLE "[MIESQUEMA]"."ROLES_OBJETIVOS" MODIFY ("ACCION" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table ROLES_USUARIO -------------------------------------------------------- ALTER TABLE "[MIESQUEMA]"."ROLES_USUARIO" ADD CONSTRAINT "ROLES_USUARIO_PK" PRIMARY KEY ("ID_ROL_USU") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "IND[MIESQUEMA]" ENABLE; ALTER TABLE "[MIESQUEMA]"."ROLES_USUARIO" MODIFY ("ID_ROL" NOT NULL ENABLE); ALTER TABLE "[MIESQUEMA]"."ROLES_USUARIO" MODIFY ("LOGIN" NOT NULL ENABLE); ALTER TABLE "[MIESQUEMA]"."ROLES_USUARIO" MODIFY ("ID_ROL_USU" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table USUARIOS -------------------------------------------------------- ALTER TABLE "[MIESQUEMA]"."USUARIOS" ADD CONSTRAINT "PK_USUARIOS" PRIMARY KEY ("LOGIN") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 32768 NEXT 32768 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "IND[MIESQUEMA]" ENABLE; ALTER TABLE "[MIESQUEMA]"."USUARIOS" MODIFY ("LOGIN" NOT NULL ENABLE); -------------------------------------------------------- -- Constraints for Table USUARIOS_ROLES -------------------------------------------------------- ALTER TABLE "[MIESQUEMA]"."USUARIOS_ROLES" ADD CONSTRAINT "PK_USUARIOS_ROLES" PRIMARY KEY ("COD_ROL", "COD_USUARIO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 32768 NEXT 32768 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "IND[MIESQUEMA]" ENABLE; ALTER TABLE "[MIESQUEMA]"."USUARIOS_ROLES" MODIFY ("COD_ROL" NOT NULL ENABLE); -------------------------------------------------------- -- Ref Constraints for Table ROLES -------------------------------------------------------- ALTER TABLE "[MIESQUEMA]"."ROLES" ADD CONSTRAINT "ROLES_R01" FOREIGN KEY ("ROL_PADRE") REFERENCES "[MIESQUEMA]"."ROLES" ("ID_ROL") ENABLE; -------------------------------------------------------- -- Ref Constraints for Table ROLES_OBJETIVOS -------------------------------------------------------- ALTER TABLE "[MIESQUEMA]"."ROLES_OBJETIVOS" ADD CONSTRAINT "ROLES_OBJETIVOS_R01" FOREIGN KEY ("ID_ROL") REFERENCES "[MIESQUEMA]"."ROLES" ("ID_ROL") ENABLE; ALTER TABLE "[MIESQUEMA]"."ROLES_OBJETIVOS" ADD CONSTRAINT "ROLES_OBJETIVOS_R02" FOREIGN KEY ("ID_OBJETIVO") REFERENCES "[MIESQUEMA]"."OBJETIVOS" ("ID_OBJETIVO") ENABLE; -------------------------------------------------------- -- Ref Constraints for Table ROLES_USUARIO -------------------------------------------------------- ALTER TABLE "[MIESQUEMA]"."ROLES_USUARIO" ADD CONSTRAINT "ROLES_USUARIO_R01" FOREIGN KEY ("ID_ROL") REFERENCES "[MIESQUEMA]"."ROLES" ("ID_ROL") ENABLE; -------------------------------------------------------- -- Ref Constraints for Table USUARIOS_ROLES -------------------------------------------------------- ALTER TABLE "[MIESQUEMA]"."USUARIOS_ROLES" ADD CONSTRAINT "FK_ROL" FOREIGN KEY ("COD_ROL") REFERENCES "[MIESQUEMA]"."ROLES" ("ID_ROL") ON DELETE CASCADE ENABLE; ALTER TABLE "[MIESQUEMA]"."USUARIOS_ROLES" ADD CONSTRAINT "FK_USU" FOREIGN KEY ("COD_USUARIO") REFERENCES "[MIESQUEMA]"."USUARIOS" ("LOGIN") ON DELETE CASCADE ENABLE NOVALIDATE;