| Tables |
|
ABONOS
| Tables |
|
ABONOS
Description
(There is no description for table ABONOS)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
ITEM |
|
INTEGER |
|
|
|
|
|
CUOTA |
|
INTEGER |
|
|
|
|
|
FECHA |
|
DATE |
|
|
|
|
|
VALOR |
|
NUMERIC(17,4) |
|
0 |
|
|
|
INTERES |
|
NUMERIC(17,4) |
|
0 |
|
|
|
SEGURO |
|
NUMERIC(17,4) |
|
0 |
|
|
|
AMORTIZACION |
|
NUMERIC(17,4) |
|
0 |
|
|
|
ADICIONAL |
|
NUMERIC(17,4) |
|
0 |
|
|
|
MORA |
|
NUMERIC(17,4) |
|
0 |
|
|
|
CODPRESTAMO |
|
CHAR(10) |
|
|
|
|
|
CODFORMASPAGO |
|
CHAR(5) |
|
|
|
|
|
NUMERO |
|
CHAR(10) |
|
|
|
Triggers
Trigger | Type | Activity | Order | Description |
|---|---|---|---|---|
BEFORE INSERT |
Yes |
0 |
|
Indices
Index | Fields | Active | Unique | Order |
|---|---|---|---|---|
CODPRESTAMO |
|
|
ASC |
|
CODFORMASPAGO |
|
|
ASC |
|
ITEM |
|
|
ASC |
References
Table | Foreign Key | Fields | FK Field | Delete Rule | Update Rule |
|---|---|---|---|---|---|
CODPRESTAMO |
CODIGO |
NO ACTION |
CASCADE |
||
CODFORMASPAGO |
CODIGO |
NO ACTION |
CASCADE |
Referenced By
(There are no tables referenced by table ABONOS)
Definition
CREATE TABLE ABONOS (
ITEM INTEGER NOT NULL,
CUOTA INTEGER,
FECHA DATE,
VALOR NUMERIC(17,4) DEFAULT 0,
INTERES NUMERIC(17,4) DEFAULT 0,
SEGURO NUMERIC(17,4) DEFAULT 0,
AMORTIZACION NUMERIC(17,4) DEFAULT 0,
ADICIONAL NUMERIC(17,4) DEFAULT 0,
MORA NUMERIC(17,4) DEFAULT 0,
CODPRESTAMO CHAR(10),
CODFORMASPAGO CHAR(5),
NUMERO CHAR(10)
);
ALTER TABLE ABONOS ADD CONSTRAINT PK_ABONOS PRIMARY KEY (ITEM);
ALTER TABLE ABONOS ADD CONSTRAINT FK_ABONOS_1 FOREIGN KEY (CODPRESTAMO) REFERENCES PRESTAMOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE ABONOS ADD CONSTRAINT FK_ABONOS_2 FOREIGN KEY (CODFORMASPAGO) REFERENCES FORMASPAGO (CODIGO) ON UPDATE CASCADE;
|
|
