Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table REJESTRY_DEK | Next Table |
Comment |
---|
reguly dekretowan dla rejestrow |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | REJESTR1 | VARCHAR2(5 BYTE) | Y | rejestr (PK 1/3 i FK) | |
2 | NAL_ZOB2 | CHAR(1 BYTE) | Y | naleznosc czy zobowiazanie (PK 2/3 i FK) | |
3 | RODZAJ3 | VARCHAR2(6 BYTE) | Y | rodzaj (PK 3/3) | |
4 | KONTO | VARCHAR2(32 CHAR) | konto | ||
5 | ID_REGULY | NUMBER | przypisana regula | ||
6 | ID_REJESTRY | VARCHAR2(7 BYTE) | |||
7 | KONTO_POZABIL | VARCHAR2(32 CHAR) | Przypisane bezpośrednio konto pozabilansowe | ||
8 | ID_REGULY_POZABIL | NUMBER | Reguła ustalenia konta pozabilansowego |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IDX_REJESTRY_DEK_REJ_RODZ | NORMAL | REJESTR, RODZAJ | <none> | ||||
NON-UNIQUE | IX_REJESTESTRY_IDREGULY | NORMAL | ID_REGULY | <none> | ||||
NON-UNIQUE | IX_REJESTESTRY_IDREGULYPOZABI | NORMAL | ID_REGULY_POZABIL | <none> | ||||
NON-UNIQUE | IX_REJESTESTRY_IDREJESTRY | NORMAL | ID_REJESTRY | <none> | ||||
UNIQUE | PK_REJESTRYDEK | NORMAL | REJESTR, NAL_ZOB, RODZAJ | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_REJESTRYDEK_REG_DEK | ID_REGULY | F_54 | REGULY_KS | ID_REGULY | NO ACTION | ENABLED | No | No |
FK_REJESTRYDEK_REG_DEK_PB | ID_REGULY_POZABIL | F_54 | REGULY_KS | ID_REGULY | NO ACTION | ENABLED | No | No |
FK_REJESTRYDEK_REJESTRY | REJESTR, NAL_ZOB | F_54 | REJESTRY | REJESTR,NAL_ZOB | NO ACTION | ENABLED | No | No |
FK_REJESTRY_DEK_REJESTRY2 | ID_REJESTRY | F_54 | REJESTRY | ID | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
PK_REJESTRYDEK | Primary Key | ENABLED | REJESTR, NAL_ZOB, RODZAJ |
Partitions |
Redaction Policies |