Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| cve_delegacion | text | 2147483647 | √ | null |
|
|
||
| cve_subdelegacion | text | 2147483647 | √ | null |
|
|
||
| cve_entidad | text | 2147483647 | √ | null |
|
|
||
| cve_municipio | text | 2147483647 | √ | null |
|
|
||
| sector_economico_1 | text | 2147483647 | √ | null |
|
|
||
| sector_economico_2 | text | 2147483647 | √ | null |
|
|
||
| sector_economico_4 | text | 2147483647 | √ | null |
|
|
||
| tamano_patron | text | 2147483647 | √ | null |
|
|
||
| sexo | text | 2147483647 | √ | null |
|
|
||
| rango_edad | text | 2147483647 | √ | null |
|
|
||
| rango_salarial | text | 2147483647 | √ | null |
|
|
||
| rango_uma | text | 2147483647 | √ | null |
|
|
||
| asegurados | text | 2147483647 | √ | null |
|
|
||
| no_trabajadores | text | 2147483647 | √ | null |
|
|
||
| ta | text | 2147483647 | √ | null |
|
|
||
| teu | text | 2147483647 | √ | null |
|
|
||
| tec | text | 2147483647 | √ | null |
|
|
||
| tpu | text | 2147483647 | √ | null |
|
|
||
| tpc | text | 2147483647 | √ | null |
|
|
||
| ta_sal | text | 2147483647 | √ | null |
|
|
||
| teu_sal | text | 2147483647 | √ | null |
|
|
||
| tec_sal | text | 2147483647 | √ | null |
|
|
||
| tpu_sal | text | 2147483647 | √ | null |
|
|
||
| tpc_sal | text | 2147483647 | √ | null |
|
|
||
| masa_sal_ta | text | 2147483647 | √ | null |
|
|
||
| masa_sal_teu | text | 2147483647 | √ | null |
|
|
||
| masa_sal_tec | text | 2147483647 | √ | null |
|
|
||
| masa_sal_tpu | text | 2147483647 | √ | null |
|
|
||
| masa_sal_tpc | text | 2147483647 | √ | null |
|
|
||
| id | int4 | 10 | √ | null |
|
|
||
| row_hash | bytea | 2147483647 | √ | custom_hash_row(ARRAY[COALESCE(cve_delegacion, ''::text), COALESCE(cve_subdelegacion, ''::text), COALESCE(cve_entidad, ''::text), COALESCE(cve_municipio, ''::text), COALESCE(sector_economico_1, ''::text), COALESCE(sector_economico_2, ''::text), COALESCE(sector_economico_4, ''::text), COALESCE(tamano_patron, ''::text), COALESCE(sexo, ''::text), COALESCE(rango_edad, ''::text), COALESCE(rango_salarial, ''::text), COALESCE(rango_uma, ''::text), COALESCE(asegurados, ''::text), COALESCE(no_trabajadores, ''::text), COALESCE(ta, ''::text), COALESCE(teu, ''::text), COALESCE(tec, ''::text), COALESCE(tpu, ''::text), COALESCE(tpc, ''::text), COALESCE(ta_sal, ''::text), COALESCE(teu_sal, ''::text), COALESCE(tec_sal, ''::text), COALESCE(tpu_sal, ''::text), COALESCE(tpc_sal, ''::text), COALESCE(masa_sal_ta, ''::text), COALESCE(masa_sal_teu, ''::text), COALESCE(masa_sal_tec, ''::text), COALESCE(masa_sal_tpu, ''::text), COALESCE(masa_sal_tpc, ''::text)]) |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| raw_imss_pkey | Primary key | Asc | id |
Relationships
Close relationships within degrees of separation
