Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table KG_SL_BILANS_POZ_HISTORIA | Next Table |
Comment |
---|
Tablica z zapisanymi do historii pozycjami zestawieniami dla roku księgowego |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_POZ_HISTORIA | NUMBER | Y | Klucz główny z sekwencji Sq_Kg_Sl_Bilans_Poz_Id_Poz | |
2 | ID_HISTORIA | NUMBER | Y | Id historii, której dotyczy pozycja z KG_SL_BILANS_HISTORIA | |
3 | BO_STAN | NUMBER | Zapisana wartość BO | ||
4 | OBROTY | NUMBER | Zapisana wartość obrotów | ||
5 | PRZYCHOD | NUMBER | Zapisana wartość przychodów | ||
6 | ROZCHOD | NUMBER | Zapisana wartość rozchodów | ||
7 | SALDO | NUMBER | Zapisane saldo końcowe | ||
8 | ID_POZ_BILANS | NUMBER | Y | Id przepisanej do historii pozycji bilansu z KG_SL_BILANS_POZ |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | INDX_KG_SL_BILA_IDHISTORIA | NORMAL | ID_HISTORIA | <none> | ||||
NON-UNIQUE | INDX_KG_SL_BILA_IDPOZBILANS | NORMAL | ID_POZ_BILANS | <none> | ||||
UNIQUE | PK_KG_SL_BILANS_POZ_HIST_ID | NORMAL | ID_POZ_HISTORIA | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_KG_SL_BILANS_POZ_HIST_HIST | ID_HISTORIA | F_54 | KG_SL_BILANS_HISTORIA | ID_HISTORIA | NO ACTION | ENABLED | No | No |
FK_KG_SL_BIL_POZ_HIST_ID_P_BIL | ID_POZ_BILANS | F_54 | KG_SL_BILANS_POZ | ID_POZ | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_KG_SL_BILANS_POZ_HIST_HIST | Check | "ID_HISTORIA" IS NOT NULL | ENABLED | ID_HISTORIA |
NN_KG_SL_BIL_POZ_HIST_ID_P_BIL | Check | "ID_POZ_BILANS" IS NOT NULL | ENABLED | ID_POZ_BILANS |
PK_KG_SL_BILANS_POZ_HIST_ID | Primary Key | ENABLED | ID_POZ_HISTORIA |
Partitions |
Redaction Policies |