CREATE TABLE "RENAPO"."RELACIONES" 
   (	"CVE_ATR_IND_REC" NUMBER NOT NULL ENABLE, 
	"CVE_ATRIBUTO_TABLA_REQUERIDA" NUMBER NOT NULL ENABLE, 
	"NOMBRE" VARCHAR2(80 BYTE) NOT NULL ENABLE, 
	 CONSTRAINT "RELACIONES_PK" PRIMARY KEY ("CVE_ATR_IND_REC", "CVE_ATRIBUTO_TABLA_REQUERIDA") ENABLE
   ) ORGANIZATION INDEX NOCOMPRESS PCTFREE 10 INITRANS 2 MAXTRANS 255 LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "RENAB_DATO" 
 PCTTHRESHOLD 50;


  CREATE TABLE "RENAPO"."CAT_ATRIBUTO_TBL" 
   (	"CVE_ATRIBUTO" NUMBER(*,0) NOT NULL ENABLE, 
	"CVE_TABLA" NUMBER(*,0), 
	"NOMBRE_ATRIBUTO" VARCHAR2(80 BYTE), 
	"DESC_ATRIBUTO" VARCHAR2(250 BYTE), 
	 CONSTRAINT "PK_CAT_ATRIBUTO_TBL" PRIMARY KEY ("CVE_ATRIBUTO")
  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)
  TABLESPACE "RENAB_DATO"  ENABLE, 
	 CONSTRAINT "FK_ATRIBUTO_TABLA" FOREIGN KEY ("CVE_TABLA")
	  REFERENCES "RENAPO"."CAT_TABLA_BD" ("CVE_TABLA") ENABLE
   ) 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)
  TABLESPACE "RENAB_DATO" ;
 
  CREATE INDEX "RENAPO"."FK_ATB_TABLA_FK" ON "RENAPO"."CAT_ATRIBUTO_TBL" ("CVE_TABLA") 
  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)
  TABLESPACE "RENAB_DATO" ;
 
  CREATE UNIQUE INDEX "RENAPO"."PK_CAT_ATRIBUTO_TBL" ON "RENAPO"."CAT_ATRIBUTO_TBL" ("CVE_ATRIBUTO") 
  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)
  TABLESPACE "RENAB_DATO" ;
 

  CREATE TABLE "RENAPO"."DATOENT_ATRIBUTO" 
   (	"CVE_DATOENT_ATR" NUMBER(*,0) NOT NULL ENABLE, 
	"CVE_DATOENT" NUMBER(*,0), 
	"CVE_ATRIBUTO" NUMBER(*,0), 
	 CONSTRAINT "PK_DATOENT_ATRIBUTO" PRIMARY KEY ("CVE_DATOENT_ATR")
  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)
  TABLESPACE "RENAB_DATO"  ENABLE, 
	 CONSTRAINT "FK_DENTATR_DENT" FOREIGN KEY ("CVE_DATOENT")
	  REFERENCES "RENAPO"."DATO_ENTRADA" ("CVE_DATOENT") ENABLE, 
	 CONSTRAINT "FK_DENTA_ATRIBUTO" FOREIGN KEY ("CVE_ATRIBUTO")
	  REFERENCES "RENAPO"."CAT_ATRIBUTO_TBL" ("CVE_ATRIBUTO") ENABLE
   ) 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)
  TABLESPACE "RENAB_DATO" ;
 
  CREATE INDEX "RENAPO"."FK_DENTA_ATR_FK" ON "RENAPO"."DATOENT_ATRIBUTO" ("CVE_ATRIBUTO") 
  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)
  TABLESPACE "RENAB_DATO" ;
 
  CREATE UNIQUE INDEX "RENAPO"."PK_DATOENT_ATRIBUTO" ON "RENAPO"."DATOENT_ATRIBUTO" ("CVE_DATOENT_ATR") 
  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)
  TABLESPACE "RENAB_DATO" ;
 

  CREATE TABLE "RENAPO"."DATO_ENTRADA" 
   (	"CVE_DATOENT" NUMBER(*,0) NOT NULL ENABLE, 
	"CVE_TIPO_DATOENT" NUMBER(*,0), 
	"DESC_DATOENT" VARCHAR2(80 BYTE), 
	 CONSTRAINT "PK_DATO_ENTRADA" PRIMARY KEY ("CVE_DATOENT")
  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)
  TABLESPACE "RENAB_DATO"  ENABLE, 
	 CONSTRAINT "FK_DENT_TPDENT" FOREIGN KEY ("CVE_TIPO_DATOENT")
	  REFERENCES "RENAPO"."CAT_TIPO_DATO_ENT" ("CVE_TIPO_DATOENT") ENABLE
   ) 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)
  TABLESPACE "RENAB_DATO" ;
 
  CREATE INDEX "RENAPO"."FK_TPDENT_DENT_FK" ON "RENAPO"."DATO_ENTRADA" ("CVE_TIPO_DATOENT") 
  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)
  TABLESPACE "RENAB_DATO" ;
 
  CREATE UNIQUE INDEX "RENAPO"."PK_DATO_ENTRADA" ON "RENAPO"."DATO_ENTRADA" ("CVE_DATOENT") 
  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)
  TABLESPACE "RENAB_DATO" ;