Scribd
Upload
6 views1 page

Database Structure Overview

The document contains definitions for multiple tables that are likely part of a database schema. It defines tables for personas, programas, sedes, cargos, menus, municipios, personamenu, dependencias, areas, and departamentos with various character and integer columns for things like IDs, names, codes and other attributes.

Uploaded by

CRISTIAN JORGE GUSTÍN VALENCIA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views1 page

Database Structure Overview

The document contains definitions for multiple tables that are likely part of a database schema. It defines tables for personas, programas, sedes, cargos, menus, municipios, personamenu, dependencias, areas, and departamentos with various character and integer columns for things like IDs, names, codes and other attributes.

Uploaded by

CRISTIAN JORGE GUSTÍN VALENCIA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

persona programas

identificacion character varying(10) id_programa character varying(8)


nombres character varying(50) nombre_programa character varying(120)
apellidos character varying(50) nivel_formacion character varying(50)
telefono character varying(10) duracion integer
correoinstitucional character varying(80) red_conocimiento integer
celular character varying(10) linea_tecnologica integer
codigocargo character varying(50)
idsede character varying(6)
idtipo character varying(3)
jefeacargo character(10)
password character varying(100)
imagen character varying(350)

sede cargo menu


codigosede character varying(4) id integer id integer
nombresede character varying(100) codigocargo character varying(3) nombre character varying(35)
bd character varying(30) nombrecargo character varying(100) pnombre character varying(200)
imagen character varying(300) detalle character varying(500) icono character varying(20)
departamento integer

municipio personamenu
id integer id integer
municipio character varying(100) identificacion character varying(10)
id_departamento integer menu character varying(100)

dependencia area departamento


codigodependencia integer codigoarea integer id integer
nombredependencia character(100) nombrearea character(100) nom_departamento character varying(100)
codigoarea integer codigosede character(8)

lote public
codigo character varying(10)
nombre character varying(50)

You might also like