asdas

CREATE TABLE esq_ceac_planclase.tbl_eval_designacion
(
  idregistro numeric NOT NULL,
  id_departamento numeric,
  id_personal_asigna numeric,
  fecha_inicio timestamp without time zone,
  fecha_final timestamp without time zone,
  estado text,
  observacion text,
  CONSTRAINT tbl_eval_designacion_pkey PRIMARY KEY (idregistro)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE esq_ceac_planclase.tbl_eval_designacion
  OWNER TO ceac_analitico;

CREATE TABLE esq_ceac_planclase.tbl_eval_designacion_docente
(
  idregistro numeric NOT NULL,
  id_designacion numeric,
  id_docente numeric,
  cedula_docente text,
  responsable text,
  observacion text,
  tipo_evaluador text,
  CONSTRAINT tbl_eval_designacion_docente_pkey PRIMARY KEY (idregistro)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE esq_ceac_planclase.tbl_eval_designacion_docente
  OWNER TO ceac_analitico;


CREATE TABLE esq_ceac_planclase.tbl_eval_catalogo_evaluacion
(
  idregistro numeric NOT NULL,
  nombre text,
  estado text,
  CONSTRAINT pk_evalcatalogoevaluacion001 PRIMARY KEY (idregistro)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE esq_ceac_planclase.tbl_eval_catalogo_evaluacion
  OWNER TO ceac_analitico;

  CREATE TABLE esq_ceac_planclase.tbl_eval_catalogo_ind_ponderacion
(
  idregistro numeric NOT NULL,
  idcatalogo_indicadore numeric,
  contenido_eval text,
  ponderacion_minimo double precision,
  ponderacion_maxima double precision,
  CONSTRAINT pk_catalogoindponderacion001 PRIMARY KEY (idregistro)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE esq_ceac_planclase.tbl_eval_catalogo_ind_ponderacion
  OWNER TO ceac_analitico;


  CREATE TABLE esq_ceac_planclase.tbl_eval_catalogo_indicadores
(
  idregistro numeric NOT NULL,
  idcatalogo numeric,
  nombre text,
  definicion text,
  evidencias text,
  CONSTRAINT pk_evalcatalogoinficadores PRIMARY KEY (idregistro)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE esq_ceac_planclase.tbl_eval_catalogo_indicadores
  OWNER TO ceac_analitico;


CREATE SEQUENCE esq_ceac_planclase.seq_id_eval_catalogo_evaluacion
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 1
  CACHE 1;
ALTER TABLE esq_ceac_planclase.seq_id_eval_catalogo_evaluacion
  OWNER TO ceac_analitico;


CREATE SEQUENCE esq_ceac_planclase.seq_id_eval_catalogo_ind_ponderacion
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 1
  CACHE 1;
ALTER TABLE esq_ceac_planclase.seq_id_eval_catalogo_ind_ponderacion
  OWNER TO ceac_analitico;



CREATE SEQUENCE esq_ceac_planclase.seq_id_eval_catalogo_indicadores
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 1
  CACHE 1;
ALTER TABLE esq_ceac_planclase.seq_id_eval_catalogo_indicadores
  OWNER TO ceac_analitico;


  CREATE SEQUENCE esq_ceac_planclase.seq_id_eval_designacion
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 19
  CACHE 1;
ALTER TABLE esq_ceac_planclase.seq_id_eval_designacion
  OWNER TO ceac_analitico;


CREATE SEQUENCE esq_ceac_planclase.seq_id_eval_designacion_docente
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 1
  CACHE 1;
ALTER TABLE esq_ceac_planclase.seq_id_eval_designacion_docente
  OWNER TO ceac_analitico;