sg_extracciones

9 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ext_pk bigserial 19 √ nextval('estadisticas.sg_extracciones_pk_seq'::regclass)
sg_alcance_extraccion.alc_extraccion sg_alcance_extraccion_extraccion_fk R
sg_ext_est_discapacidades.dis_ext_cabezal_fk sg_ext_fk R
sg_ext_est_mat_retiradas.mre_ext_cabezal_fk sg_mre_ext_fk R
sg_ext_est_tipos_parentesco.tpa_ext_cabezal_fk sg_ext_fk R
sg_ext_estudiantes.ext_cabezal_fk sg_ext_cabezal_fk R
sg_ext_pers_sec.sec_ext_cabezal_fk sg_ext_fk R
sg_ext_pers_sector_sede.pts_ext_cabezal_fk sg_ext_sector_fk R
sg_ext_pers_tipo_sede.pts_ext_cabezal_fk sg_ext_fk R
sg_ext_personal.ext_cabezal_fk sg_ext_per_cabezal_fk R
sg_ext_sede_servicios_basicos.sba_ext_cabezal_fk sg_ext_fk R
sg_ext_sedes.ext_cabezal_fk sg_ext_sed_cabezal_fk R
sg_grado_reporta_en.rep_extraccion sg_grado_reporta_en_extraccion_fk R
ext_anio int4 10 √ null
ext_dataset_fk int8 19 √ null
sg_est_datasets.dat_pk sg_ext_dataset_fk R
ext_nombre_fk int8 19 √ null
sg_est_nombres_extracciones.nex_pk sg_ext_nombre_fk R
ext_ult_mod_fecha timestamp 29,6 √ null
ext_ult_mod_usuario varchar 45 √ null
ext_version int4 10 √ null
ext_estado varchar 45 √ null
ext_error varchar 2000 √ null
ext_descripcion varchar 2000 √ null
ext_fecha_matriculados timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
sg_extracciones_pkey Primary key Asc ext_pk
sg_ext_anio_ds_nom_uk Must be unique Asc/Asc/Asc ext_anio + ext_dataset_fk + ext_nombre_fk

Relationships

Close relationships within degrees of separation