Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| comunicacion_id | INT | 10 | √ | null |
|
|
||
| comunicacion_caso_id | INT | 10 | null |
|
|
|||
| comunicacion_casoEstado_id | INT | 10 | null |
|
|
|||
| comunicacion_asunto_id | INT | 10 | null |
|
|
|||
| comunicacion_usuario_id | INT | 10 | null |
|
|
|||
| comunicacion | TEXT | 65535 | √ | null |
|
|
||
| comunicacion_fechaIngreso | DATETIME | 19 | null |
|
|
|||
| comunicacion_historial_id | INT | 10 | √ | null |
|
|
||
| comunicacion_fechaModificacion | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|
|||
| comunicacion_modificada | BIT | 1 | null |
|
|
|||
| comunicacion_sistemaAntiguo | BIT | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | comunicacion_id |
| caso_id | Performance | Asc | comunicacion_caso_id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors