Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | varchar | 50 | null |
|
|
id del registro |
||
| nombre | varchar | 150 | √ | null |
|
|
Descripción larga |
|
| codemp_id | numeric | 0 | √ | null |
|
|
Código de Empresa |
|
| cencos_id | numeric | 0 | √ | null |
|
|
centro de costo |
|
| codctr_id | varchar | 50 | √ | null |
|
|
centro de costo |
|
| activo | bool | 1 | √ | null |
|
|
esta activo ? |
|
| idmodif | numeric | 0 | √ | null |
|
|
identificador de la modificacion |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| dim_centros_de_costos_pkey | Primary key | Asc | id |
| dim_centros_de_costos_idx_idmodif | Performance | Asc/Asc | idmodif + id |
Relationships
Close relationships within degrees of separation
