| Tables |
|
LOG_OPORTUNIDADES
| Tables |
|
LOG_OPORTUNIDADES
Description
(There is no description for table LOG_OPORTUNIDADES)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
ITEM |
|
INTEGER |
|
|
|
|
|
FECHA |
|
TIMESTAMP |
|
|
|
|
|
CIERRE |
|
TIMESTAMP |
|
|
|
|
|
PROXIMA |
|
TIMESTAMP |
|
|
|
|
|
NIVEL_INTERES |
|
CHAR(20) |
|
|
|
|
|
NOTA |
|
BLOB SUB_TYPE 1 SEGMENT SIZE 80 |
|
|
|
|
|
PASO_A_PASO |
|
BLOB SUB_TYPE 1 SEGMENT SIZE 80 |
|
|
|
|
|
CODTERCERO |
|
CHAR(15) |
|
|
|
|
|
CODUSUARIO |
|
CHAR(10) |
|
|
|
|
|
CODCONTACTO |
|
CHAR(10) |
|
|
|
|
|
CODRELACION |
|
CHAR(20) |
|
|
|
|
|
CODSOLUCION |
|
INTEGER |
|
|
|
Triggers
(There are no triggers for table LOG_OPORTUNIDADES)
Indices
(There are no indices on table LOG_OPORTUNIDADES)
References
(There are no references for table LOG_OPORTUNIDADES)
Referenced By
(There are no tables referenced by table LOG_OPORTUNIDADES)
Definition
CREATE TABLE LOG_OPORTUNIDADES (
ITEM INTEGER,
FECHA TIMESTAMP,
CIERRE TIMESTAMP,
PROXIMA TIMESTAMP,
NIVEL_INTERES CHAR(20),
NOTA BLOB SUB_TYPE 1 SEGMENT SIZE 80,
PASO_A_PASO BLOB SUB_TYPE 1 SEGMENT SIZE 80,
CODTERCERO CHAR(15),
CODUSUARIO CHAR(10),
CODCONTACTO CHAR(10),
CODRELACION CHAR(20),
CODSOLUCION INTEGER
);
|
|
