Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||
| entidad | varchar | 50 | null |
|
|
||||||
| registro_id | varchar | 50 | null |
|
|
||||||
| campo | varchar | 63 | 'nombre'::character varying |
|
|
||||||
| idioma | varchar | 5 | null |
|
|
||||||
| texto | text | 2147483647 | ''::text |
|
|
||||||
| estatus | varchar | 15 | 'borrador'::character varying |
|
|
||||||
| texto_origen | text | 2147483647 | √ | null |
|
|
|||||
| actualizado_por | varchar | 100 | √ | null |
|
|
|||||
| tiempo_creado | timestamptz | 35,6 | √ | CURRENT_TIMESTAMP |
|
|
|||||
| tiempo_actualizado | timestamptz | 35,6 | √ | CURRENT_TIMESTAMP |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| traducciones_pkey | Primary key | Asc | id |
| ix_traducciones__idioma_entidad | Performance | Asc/Asc | idioma + entidad |
| uq_traducciones__registro | Must be unique | Asc/Asc/Asc/Asc | entidad + registro_id + campo + idioma |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| ck_traducciones__estatus | (((estatus)::text = ANY ((ARRAY['borrador'::character varying, 'revisado'::character varying, 'no_aplica'::character varying])::text[]))) |
Relationships
Close relationships within degrees of separation
