Description
(There is no description for table LOG_CASOS)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
---|---|---|---|---|---|---|---|
|
|
CODIGO |
|
INTEGER |
|
|
|
|
|
NOMBRE |
|
CHAR(80) |
|
|
|
|
|
FECHA |
|
TIMESTAMP |
|
|
|
|
|
CIERRE |
|
TIMESTAMP |
|
|
|
|
|
PROXIMA |
|
TIMESTAMP |
|
|
|
|
|
ESTADO |
|
CHAR(20) |
|
|
|
|
|
NOTA |
|
BLOB SUB_TYPE 1 SEGMENT SIZE 80 |
|
|
|
|
|
PASO_A_PASO |
|
BLOB SUB_TYPE 1 SEGMENT SIZE 80 |
|
|
|
|
|
CODRELACION |
|
CHAR(20) |
|
|
|
|
|
CODTERCERO |
|
CHAR(15) |
|
|
|
|
|
CODCONTACTO |
|
CHAR(15) |
|
|
|
|
|
CODACCION |
|
CHAR(20) |
|
|
|
|
|
CODREFERENCIA |
|
CHAR(20) |
|
|
|
|
|
CODSOLUCION |
|
INTEGER |
|
|
|
|
|
CODUSUARIO_I |
|
CHAR(10) |
|
|
|
|
|
CODUSUARIO_F |
|
CHAR(10) |
|
|
|
|
|
CODLICENCIA |
|
CHAR(15) |
|
|
Triggers
(There are no triggers for table LOG_CASOS)
Indices
(There are no indices on table LOG_CASOS)
References
(There are no references for table LOG_CASOS)
Referenced By
(There are no tables referenced by table LOG_CASOS)
Definition
CREATE TABLE LOG_CASOS (
CODIGO INTEGER,
NOMBRE CHAR(80),
FECHA TIMESTAMP,
CIERRE TIMESTAMP,
PROXIMA TIMESTAMP,
ESTADO CHAR(20),
NOTA BLOB SUB_TYPE 1 SEGMENT SIZE 80,
PASO_A_PASO BLOB SUB_TYPE 1 SEGMENT SIZE 80,
CODRELACION CHAR(20),
CODTERCERO CHAR(15),
CODCONTACTO CHAR(15),
CODACCION CHAR(20),
CODREFERENCIA CHAR(20),
CODSOLUCION INTEGER,
CODUSUARIO_I CHAR(10),
CODUSUARIO_F CHAR(10),
CODLICENCIA CHAR(15)
);
![]() ![]() ![]() |