lunes, 7 de noviembre de 2011

Tabla Base de Datos Cuadro General

-- Table: "Cuadro_general"

-- DROP TABLE "Cuadro_general";

CREATE TABLE "Cuadro_general"
(
"Estado" character varying(20),
"Municipio" character varying(20),
"Aldea" character varying(20),
id_cedula integer NOT NULL,
"Nombre" character varying(20),
"Apellido" character varying(20),
"Genero" "char",
fecha_nacimiento timestamp without time zone,
"Grupo_sanguineo" character varying,
"Nacionalidad" "char",
direccion character varying(150),
"lugar de nacimiento" character varying(20),
telefono_de_hab integer,
telefono_celular integer,
email character varying(50),
"TIT_Medio" character varying,
"NUM_TITULO" integer,
"LIBRO" character varying(20),
"Folio" character varying(5),
"Plan_inter" character varying(20),
"cod_Plantel" integer,
"año_titulo" integer,
t1_ma integer,
"t1_PNNC" integer,
"t1_LC" integer,
"t1_TDA" integer,
"t1_PNAT" integer,
"t1_PLAD" integer,
"T1_IA" integer,
"T1_MA" integer,
"T1_INFO" integer,
"T1_LAPP1" integer,
"T1_CONT1" integer,
"T1_ING1" integer,
"T1_EST1" integer,
"T1_ESP1" integer,
"T1_PROY1" integer,
"T2_LAPP2" integer,
"T2_EST2" integer,
"T2_CONT2" integer,
"T2_FUE" integer,
"T2_PRE" integer,
"T2_COST" integer,
"T2_OS" integer,
"T2_MER1" integer,
"T2_DAR" integer,
"T2_ESP2" integer,
"T2_PROY2" integer,
"T3_FIN" integer,
"T3_ING2" integer,
"T3_MER2" integer,
"T3_AP" integer,
"T3_HSA" integer,
"T3_INMER" integer,
"T3_ISP3" integer,
"T3_PROY3" integer,
"T4_SIST" integer,
"T4_DAR2" integer,
"T4_AUD1" integer,
"T4_GESDE" integer,
"T4_FSP4" integer,
"T4_PROY4" integer,
CONSTRAINT id_cedula_est_key PRIMARY KEY (id_cedula)
)
WITH (
OIDS=FALSE
);
ALTER TABLE "Cuadro_general" OWNER TO postgres;

No hay comentarios:

Publicar un comentario