Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | numeric | 0 | null |
|
|
id del registro |
||
| nombre | varchar | 150 | √ | null |
|
|
Descripción del Depósito |
|
| es_fisico | numeric | 0 | √ | null |
|
|
Es stock Real |
|
| es_costeo | numeric | 0 | √ | null |
|
|
se utiliza en costeo |
|
| es_disvta | numeric | 0 | √ | null |
|
|
Stock disponible para la venta |
|
| es_produccion | numeric | 0 | √ | null |
|
|
es de produccion |
|
| es_cyo | numeric | 0 | √ | null |
|
|
es deposito de cuenta y orden |
|
| activo | numeric | 0 | √ | null |
|
|
esta activo |
|
| fabrica_id | numeric | 0 | √ | null |
|
|
Codigo de Fabrica |
|
| idmodif | numeric | 0 | √ | null |
|
|
identificador de la modificacion |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| dim_depositos_pkey | Primary key | Asc | id |
| dim_depositos_idx_idmodif | Performance | Asc/Asc | idmodif + id |
Relationships
Close relationships within degrees of separation
