Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table KG_ROZL_KONT_ZESPOLU_DEK | Next Table |
Comment |
---|
Tablica zawiera informace o deretach i PK kolenych miesięcy |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_ROZL_DEK | NUMBER | Y | Klucz główny z sekwencji SEQ_KG_ROZL_KONT_ZESP_ID | |
2 | ID_ROZL | NUMBER | Rozliczenie którego dotyczą dekrety | ||
3 | DATA_OD | DATE | Data od okresu za który nastąpiło rozliczenie | ||
4 | DATA_DO | DATE | Data do okresu za który nastąpiło rozliczenie | ||
5 | ID_ROKU | NUMBER | Rok za który nastąpiło rozliczenie | ||
6 | DEKRET | VARCHAR2(2 CHAR) | Dekret | ||
7 | ID_DOWODU_FK | NUMBER | Dowód księgowy (PK) |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IDX_KG_ROZL_KONT_ZESP_D_ROZL | NORMAL | ID_ROZL | <none> | ||||
NON-UNIQUE | IX_KGROZLSPOLU_IDDOWODUFK | NORMAL | ID_DOWODU_FK | <none> | ||||
NON-UNIQUE | IX_KGROZLSPOLU_IDROKU | NORMAL | ID_ROKU | <none> | ||||
UNIQUE | PK_KG_ROZL_KONT_ZESP_D_ID | NORMAL | ID_ROZL_DEK | <none> | ||||
UNIQUE | UQ_KG_ROZL_KONT_ZESP_D_DRR | NORMAL | ID_ROZL, ID_ROKU, DATA_OD | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_KG_ROZL_KONT_ZESP_D_DOWODKS | ID_DOWODU_FK | F_54 | DOWODY_KS | ID_DOWODU | NO ACTION | ENABLED | No | No |
FK_KG_ROZL_KONT_ZESP_D_ID_ROKU | ID_ROKU | F_54 | FK_LATA | ID_ROKU | NO ACTION | ENABLED | No | No |
FK_KG_ROZL_KONT_ZESP_D_ROZL | ID_ROZL | F_54 | KG_ROZL_KONT_ZESPOLU | ID_ROZL | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_KG_ROZL_KONT_ZESP_D_DATA_DO | Check | "DATA_DO" IS NOT NULL | ENABLED | DATA_DO |
NN_KG_ROZL_KONT_ZESP_D_DATA_OD | Check | "DATA_OD" IS NOT NULL | ENABLED | DATA_OD |
NN_KG_ROZL_KONT_ZESP_D_ID_ROKU | Check | "ID_ROKU" IS NOT NULL | ENABLED | ID_ROKU |
NN_KG_ROZL_KONT_ZESP_D_ID_ROZL | Check | "ID_ROZL" IS NOT NULL | ENABLED | ID_ROZL |
PK_KG_ROZL_KONT_ZESP_D_ID | Primary Key | ENABLED | ID_ROZL_DEK | |
UQ_KG_ROZL_KONT_ZESP_D_DRR | Unique | ENABLED | ID_ROZL, ID_ROKU, DATA_OD |
Partitions |
Redaction Policies |