lunes, 7 de noviembre de 2011

Tabla Base de Datos Profesores

-- Table: "Data_Profesores"

-- DROP TABLE "Data_Profesores";

CREATE TABLE "Data_Profesores"
(
id_cedula integer NOT NULL,
"Nombre" character varying,
"Apellido" character varying(20),
"Estado" character varying(20),
"Municipio" character varying(20),
"Aldea" character varying(20),
"Genero" "char",
"Direccion" character varying(60),
"Asignatura" character varying,
"Profesion" character varying(50),
"IES" character varying(50),
"Año" date,
tel_hab integer,
tel_cel integer,
email character varying(50),
CONSTRAINT profesores_key PRIMARY KEY (id_cedula)
)
WITH (
OIDS=FALSE
);
ALTER TABLE "Data_Profesores" OWNER TO postgres;
COMMENT ON TABLE "Data_Profesores" IS 'Listado de Profesores';

No hay comentarios:

Publicar un comentario