Dumped on 2012-05-24
area_inclusion Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
nombre |
character varying(255) |
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
categoria Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
orden_vista |
integer |
|
|
visible |
boolean |
DEFAULT true
|
|
nombre |
text |
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
comuna Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
nro |
bigint |
NOT NULL
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
comuna_distrito Structure
F-Key |
Name |
Type |
Description |
comuna.id
|
comuna_id |
integer |
PRIMARY KEY
|
distrito.id
|
distrito_id |
bigint |
PRIMARY KEY
|
Index -
Schema public
deltas_sql Structure
F-Key |
Name |
Type |
Description |
|
numero |
integer |
PRIMARY KEY
|
|
tag |
character varying(30) |
NOT NULL
|
|
timestamp |
timestamp without time zone |
DEFAULT '2012-05-24 12:34:38.704948'::timestamp without time zone
|
Index -
Schema public
distrito Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
nro |
bigint |
NOT NULL
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
domicilio_edificio Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
edificio.id
|
edificio_id |
integer |
NOT NULL
|
|
domicilio |
text |
|
|
latitud |
double precision |
|
|
longitud |
double precision |
|
|
comuna |
integer |
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
edificio Structure
F-Key |
Name |
Type |
Description |
|
cui |
integer |
NOT NULL
|
|
id |
serial |
PRIMARY KEY
|
|
superficio_m2 |
numeric(18,2) |
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
edificio_inclusion Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
edificio.id
|
edificio_id |
integer |
NOT NULL
|
plan_inclusion.id
|
plan_id |
integer |
NOT NULL
|
|
coordinador |
character varying(255) |
|
|
lunes |
character varying(255) |
|
|
martes |
character varying(255) |
|
|
miercoles |
character varying(255) |
|
|
jueves |
character varying(255) |
|
|
viernes |
character varying(255) |
|
|
sabado |
character varying(255) |
|
Index -
Schema public
establecimiento Structure
F-Key |
Name |
Type |
Description |
|
cue_anexo |
character(8) |
NOT NULL
|
|
id |
serial |
PRIMARY KEY
|
|
nombre |
text |
|
|
telefono |
text |
|
|
nivel_modalidad |
text |
|
|
tipo_establecimiento |
text |
|
|
distrito_escolar |
integer |
|
domicilio_edificio.id
|
domicilio_edificio_id |
integer |
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
establecimiento_inclusion Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
establecimiento.id
|
establecimiento_id |
integer |
NOT NULL
|
|
club_de_ciencias |
boolean |
|
|
minizoo_y_acuario |
boolean |
|
|
formacion_espectadores |
boolean |
|
|
teatro_escolar |
boolean |
|
|
ajedrez |
boolean |
|
|
medios |
boolean |
|
|
eoe |
boolean |
|
|
primera_infancia |
boolean |
|
|
centros_infantiles |
boolean |
|
|
ce |
boolean |
|
|
alumnas_madres |
boolean |
|
|
isauro_arancibia |
boolean |
|
|
piie |
boolean |
|
|
puentes_escolares |
boolean |
|
|
club_de_chicos |
boolean |
|
|
campamentos |
boolean |
|
|
orquestas |
boolean |
|
|
red_escuela_comunicacion |
boolean |
|
|
cine_zap |
boolean |
|
|
apoyo_a_la_escolaridad |
boolean |
|
|
maestro_maestro |
boolean |
|
|
nivelacion |
boolean |
|
|
aceleracion |
boolean |
|
|
salud_escolar |
boolean |
|
|
salud_odontologica |
boolean |
|
|
salud_visual |
boolean |
|
|
salud_y_prevencion_sida |
boolean |
|
Index -
Schema public
establecimiento_libros Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
establecimiento.id
|
establecimiento_id |
integer |
NOT NULL
|
|
libros_texto |
integer |
|
|
libros_literatura |
integer |
|
|
libros_ingles |
integer |
|
Index -
Schema public
establecimiento_nivel_modalidad Structure
F-Key |
Name |
Type |
Description |
establecimiento.id
|
establecimiento_id |
integer |
PRIMARY KEY
|
nivelmodalidad.id
|
nivelmodalidad_id |
integer |
PRIMARY KEY
|
Index -
Schema public
establecimiento_totales_sgd_anuales Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
establecimiento.id
|
establecimiento_id |
integer |
NOT NULL
|
|
anio |
integer |
|
|
pof_presupuestaria_cargos |
integer |
|
|
pof_presupuestaria_horas |
integer |
|
|
pof_vacante_cargos |
integer |
|
|
pof_vacante_horas |
integer |
|
Index -
Schema public
establecimiento_totales_sge_anuales Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
establecimiento.id
|
establecimiento_id |
integer |
NOT NULL
|
|
anio |
integer |
|
|
matricula |
integer |
|
|
cantidad_secciones |
integer |
|
Index -
Schema public
estado_obra Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
nombre |
character varying(50) |
NOT NULL
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
inspector Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
nombre |
text |
NOT NULL
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
mantenimiento_edificio Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
edificio.id
|
edificio_id |
integer |
NOT NULL
|
|
correctivo_finalizadas_cantidad |
integer |
|
|
correctivo_en_ejecucion_cantidad |
integer |
|
|
correctivo_a_ejecutar_cantidad |
integer |
|
|
correctivo_monto_total |
numeric(18,2) |
|
|
tareas_menores_finalizadas_cantidad |
integer |
|
|
tareas_menores_en_ejecucion_cantidad |
integer |
|
|
tareas_menores_a_ejecutar_cantidad |
integer |
|
|
tareas_menores_monto_total |
numeric(18,2) |
|
Index -
Schema public
motivo_reclamo Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
nombre |
character varying(50) |
NOT NULL
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
nivelmodalidad Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
abreviatura |
character varying(20) |
NOT NULL
|
|
nombre |
character varying(100) |
NOT NULL
|
|
orden |
integer |
NOT NULL
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
obra Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
edificio.id
|
edificio_id |
integer |
|
rubro_obra.id
|
rubro_obra_id |
integer |
|
estado_obra.id
|
estado_obra_id |
integer |
|
plan_obra.id
|
plan_obra_id |
integer |
|
|
fecha_acta_inicio |
date |
|
|
fecha_fin |
date |
|
|
avance_obra_actual |
integer |
|
|
monto_contrato |
numeric(20,2) |
|
|
numero_expediente |
character varying(50) |
|
Index -
Schema public
plan1x1 Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
nombre |
text |
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
plan1x1_establecimiento Structure
F-Key |
Name |
Type |
Description |
plan1x1.id
|
plan1x1_id |
integer |
NOT NULL
|
establecimiento.id
|
establecimiento_id |
integer |
NOT NULL
|
|
id |
serial |
PRIMARY KEY
|
|
netbooks |
integer |
|
|
notebooks |
integer |
|
|
internet |
text |
|
Index -
Schema public
plan_inclusion Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
nombre |
character varying(255) |
|
area_inclusion.id
|
area_id |
integer |
NOT NULL
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
plan_obra Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
nombre |
character varying(50) |
NOT NULL
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
pregunta Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
destacada |
boolean |
DEFAULT false
|
|
visible |
boolean |
DEFAULT true
|
|
orden |
integer |
|
|
nombre |
text |
|
|
nombre_mostrable |
text |
|
categoria.id
|
categoria_id |
integer |
|
relevamiento.id
|
relevamiento_id |
integer |
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
reclamo Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
nombre |
character varying(100) |
NOT NULL
|
|
apellido |
character varying(100) |
NOT NULL
|
|
telefono |
character varying(50) |
NOT NULL
|
|
email |
character varying(255) |
NOT NULL
|
|
reclamo |
text |
NOT NULL
|
motivo_reclamo.id
|
motivo_reclamo_id |
integer |
NOT NULL
|
establecimiento.id
|
establecimiento_id |
integer |
NOT NULL
|
|
fecha_hora |
timestamp without time zone |
NOT NULL
|
Index -
Schema public
relevamiento Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
nombre |
text |
|
|
fecha |
date |
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
relevamiento_edificio Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
edificio.id
|
edificio_id |
integer |
NOT NULL
|
relevamiento.id
|
relevamiento_id |
integer |
|
|
ubic_tec |
text |
|
inspector.id
|
inspector_id |
integer |
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
respuesta Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
nombre |
text |
|
|
valor |
integer |
|
pregunta.id
|
pregunta_id |
integer |
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
respuesta_relevamiento_edificio Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
relevamiento_edificio.id
|
relevamiento_edificio_id |
integer |
|
respuesta.id
|
respuesta_id |
integer |
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
respuesta_relevamiento_edificio_observacion Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
respuesta_relevamiento_edificio.id
|
respuesta_relevamiento_edificio_id |
integer |
|
|
observacion |
text |
|
Index -
Schema public
rubro_obra Structure
F-Key |
Name |
Type |
Description |
|
id |
serial |
PRIMARY KEY
|
|
nombre |
character varying(255) |
NOT NULL
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
sf_guard_forgot_password Structure
F-Key |
Name |
Type |
Description |
|
id |
bigserial |
PRIMARY KEY
|
sf_guard_user.id
|
user_id |
bigint |
NOT NULL
|
|
unique_key |
character varying(255) |
|
|
expires_at |
timestamp without time zone |
NOT NULL
|
|
created_at |
timestamp without time zone |
NOT NULL
|
|
updated_at |
timestamp without time zone |
NOT NULL
|
Index -
Schema public
sf_guard_group Structure
F-Key |
Name |
Type |
Description |
|
id |
bigserial |
PRIMARY KEY
|
|
name |
character varying(255) |
UNIQUE
|
|
description |
character varying(1000) |
|
|
created_at |
timestamp without time zone |
NOT NULL
|
|
updated_at |
timestamp without time zone |
NOT NULL
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
sf_guard_group_permission Structure
F-Key |
Name |
Type |
Description |
sf_guard_group.id
|
group_id |
bigint |
PRIMARY KEY
|
sf_guard_permission.id
|
permission_id |
bigint |
PRIMARY KEY
|
|
created_at |
timestamp without time zone |
NOT NULL
|
|
updated_at |
timestamp without time zone |
NOT NULL
|
Index -
Schema public
sf_guard_permission Structure
F-Key |
Name |
Type |
Description |
|
id |
bigserial |
PRIMARY KEY
|
|
name |
character varying(255) |
UNIQUE
|
|
description |
character varying(1000) |
|
|
created_at |
timestamp without time zone |
NOT NULL
|
|
updated_at |
timestamp without time zone |
NOT NULL
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
sf_guard_remember_key Structure
F-Key |
Name |
Type |
Description |
|
id |
bigserial |
PRIMARY KEY
|
sf_guard_user.id
|
user_id |
bigint |
|
|
remember_key |
character varying(32) |
|
|
ip_address |
character varying(50) |
|
|
created_at |
timestamp without time zone |
NOT NULL
|
|
updated_at |
timestamp without time zone |
NOT NULL
|
Index -
Schema public
sf_guard_user Structure
F-Key |
Name |
Type |
Description |
|
id |
bigserial |
PRIMARY KEY
|
|
first_name |
character varying(255) |
|
|
last_name |
character varying(255) |
|
|
email_address |
character varying(255) |
UNIQUE
NOT NULL
|
|
username |
character varying(128) |
UNIQUE
NOT NULL
|
|
algorithm |
character varying(128) |
NOT NULL
DEFAULT 'sha1'::character varying
|
|
salt |
character varying(128) |
|
|
password |
character varying(128) |
|
|
is_active |
boolean |
DEFAULT true
|
|
is_super_admin |
boolean |
DEFAULT false
|
|
last_login |
timestamp without time zone |
|
|
created_at |
timestamp without time zone |
NOT NULL
|
|
updated_at |
timestamp without time zone |
NOT NULL
|
Tables referencing this one via Foreign Key Constraints:
is_active_idx is_active
Index -
Schema public
sf_guard_user_group Structure
F-Key |
Name |
Type |
Description |
sf_guard_user.id
|
user_id |
bigint |
PRIMARY KEY
|
sf_guard_group.id
|
group_id |
bigint |
PRIMARY KEY
|
|
created_at |
timestamp without time zone |
NOT NULL
|
|
updated_at |
timestamp without time zone |
NOT NULL
|
Index -
Schema public
sf_guard_user_permission Structure
F-Key |
Name |
Type |
Description |
sf_guard_user.id
|
user_id |
bigint |
PRIMARY KEY
|
sf_guard_permission.id
|
permission_id |
bigint |
PRIMARY KEY
|
|
created_at |
timestamp without time zone |
NOT NULL
|
|
updated_at |
timestamp without time zone |
NOT NULL
|
Index -
Schema public
Generated by PostgreSQL Autodoc
W3C HTML 4.01 Strict