Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table ROZ_RATY_POZ | Next Table |
Comment |
---|
Tablica rat |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_RATY | NUMBER | Y | Klucz główny z sekwencji SQ_ROZ_RATY_POZ_ID | |
2 | ID_RATY_GLOWNEJ | NUMBER | Id rat z ROZ_RAT | ||
3 | NUMER_RATY | NUMBER | Unikalny w obrębie raty numer | ||
4 | KWOTA_ZALEGLOSCI | NUMBER | Kwota zaległości | ||
5 | ODSETKI | NUMBER | Kwota Odsetek | ||
6 | OPLATA_PROLONG | NUMBER | Wysokość opłaty prolongacyjnej | ||
7 | TERMIN | DATE | Termin płatności raty | ||
8 | ID_FAK | NUMBER | Id dokumentu - raty | ||
9 | DATA_ZERWANIA | DATE | Data zerwania raty | ||
10 | ID_FAK_ODS | NUMBER | Id odsetek wygenerowanych do raty | ||
11 | ID_FAK_OPL_PR | NUMBER | Id opłaty prolongacyjnej wygenerowanej z rat | ||
12 | KWOTA_UMORZENIA_ODS | NUMBER | Kwota umorzenia odsetek wygenerowanych do raty | ||
13 | ID_FAK_UMO_ODS | NUMBER | Id umorzonych odsetek wygenerowanych do raty |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | FK_ROZ_RATY_POZ_ID_FAK | NORMAL | ID_FAK | <none> | ||||
NON-UNIQUE | FK_ROZ_RATY_POZ_ID_FAK_ODS | NORMAL | ID_FAK_ODS | <none> | ||||
NON-UNIQUE | FK_ROZ_RATY_POZ_ID_FAK_OPL_PR | NORMAL | ID_FAK_OPL_PR | <none> | ||||
NON-UNIQUE | FK_ROZ_RATY_POZ_ID_R_GL | NORMAL | ID_RATY_GLOWNEJ | <none> | ||||
UNIQUE | PK_ROZ_RATY_POZ_ID | NORMAL | ID_RATY | <none> | ||||
UNIQUE | UQ_ROZ_RATY_POZ_NUMER | NORMAL | ID_RATY_GLOWNEJ, NUMER_RATY | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_ROZ_RATY_POZ_ID_FAK | ID_FAK | F_54 | FAKTURY | ID_FAK | NO ACTION | ENABLED | No | No |
FK_ROZ_RATY_POZ_ID_FAK_ODS | ID_FAK_ODS | F_54 | FAKTURY | ID_FAK | NO ACTION | ENABLED | No | No |
FK_ROZ_RATY_POZ_ID_FAK_OPL_PR | ID_FAK_OPL_PR | F_54 | FAKTURY | ID_FAK | NO ACTION | ENABLED | No | No |
FK_ROZ_RATY_POZ_ID_FAK_UMO_ODS | ID_FAK_UMO_ODS | F_54 | FAKTURY | ID_FAK | NO ACTION | ENABLED | No | No |
FK_ROZ_RATY_POZ_ID_R_GL | ID_RATY_GLOWNEJ | F_54 | ROZ_RATY | ID_RATY_GLOWNEJ | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_ROZ_RATY_POZ_NUMER | Check | "NUMER_RATY" IS NOT NULL | ENABLED | NUMER_RATY |
NN_ROZ_RATY_POZ_TERMIN | Check | "TERMIN" IS NOT NULL | ENABLED | TERMIN |
PK_ROZ_RATY_POZ_ID | Primary Key | ENABLED | ID_RATY | |
UQ_ROZ_RATY_POZ_NUMER | Unique | ENABLED | ID_RATY_GLOWNEJ, NUMER_RATY |
Partitions |
Redaction Policies |