Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| anio | text | 2147483647 | √ | null |
|
|
||
| mes | text | 2147483647 | √ | null |
|
|
||
| cve_ent | text | 2147483647 | √ | null |
|
|
||
| entidad | text | 2147483647 | √ | null |
|
|
||
| cve_mun | text | 2147483647 | √ | null |
|
|
||
| municipio | text | 2147483647 | √ | null |
|
|
||
| organismo | text | 2147483647 | √ | null |
|
|
||
| modalidad | text | 2147483647 | √ | null |
|
|
||
| destino | text | 2147483647 | √ | null |
|
|
||
| tipo | text | 2147483647 | √ | null |
|
|
||
| sexo | text | 2147483647 | √ | null |
|
|
||
| edad_rango | text | 2147483647 | √ | null |
|
|
||
| ingresos_rango | text | 2147483647 | √ | null |
|
|
||
| vivienda_valor | text | 2147483647 | √ | null |
|
|
||
| acciones | text | 2147483647 | √ | null |
|
|
||
| monto | text | 2147483647 | √ | null |
|
|
||
| row_hash | bytea | 2147483647 | √ | custom_hash_row(ARRAY[COALESCE(anio, ''::text), COALESCE(mes, ''::text), COALESCE(cve_ent, ''::text), COALESCE(entidad, ''::text), COALESCE(cve_mun, ''::text), COALESCE(municipio, ''::text), COALESCE(organismo, ''::text), COALESCE(modalidad, ''::text), COALESCE(destino, ''::text), COALESCE(tipo, ''::text), COALESCE(sexo, ''::text), COALESCE(edad_rango, ''::text), COALESCE(ingresos_rango, ''::text), COALESCE(vivienda_valor, ''::text), COALESCE(acciones, ''::text), COALESCE(monto, ''::text)]) |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| idx_raw_creditos__cve_ent_cve_mun_municipio | Performance | Asc/Asc/Asc | cve_ent + cve_mun + municipio |
Relationships
Close relationships within degrees of separation
