Comment for Table KG_SL_BILANS_HISTORIA
Comment
Tablica z zapisanymi do historii zestawieniami dla roku księgowego

Columns of Table KG_SL_BILANS_HISTORIA
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_HISTORIA NUMBER Y   Klucz główny z sekwencji Sq_Kg_Sl_Bilans_Poz_Id_Poz
2 RODZAJ_BILANS VARCHAR2(8 BYTE) Y   Rodzaj zestawienia z KG_SL_BILANS
3 ID_ROKU NUMBER Y   Id roku księgowego, którego dotyczy zestawienie z FK_LATA

Indexes on Table KG_SL_BILANS_HISTORIA
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE INDX_KG_SL_BILA_IDROKU NORMAL ID_ROKU <none>        
UNIQUE PK_KG_SL_BILANS_HIST_ID NORMAL ID_HISTORIA <none>        
UNIQUE UQ_KG_SL_BILANS_HIST_ROK_BIL NORMAL RODZAJ_BILANS, ID_ROKU <none>        

Foreign Key Constraints on Table KG_SL_BILANS_HISTORIA
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_KG_SL_BILANS_HIST_ID_ROKU ID_ROKU F_54 FK_LATA ID_ROKU NO ACTION ENABLED No No
FK_KG_SL_BILANS_HIST_RODZ_BIL RODZAJ_BILANS F_54 KG_SL_BILANS RODZAJ NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table KG_SL_BILANS_HISTORIA
Constraint Name Type Condition Status Columns
NN_KG_SL_BILANS_HIST_ID_ROKU Check "ID_ROKU" IS NOT NULL ENABLED ID_ROKU
NN_KG_SL_BILANS_HIST_RODZ_BIL Check "RODZAJ_BILANS" IS NOT NULL ENABLED RODZAJ_BILANS
PK_KG_SL_BILANS_HIST_ID Primary Key   ENABLED ID_HISTORIA
UQ_KG_SL_BILANS_HIST_ROK_BIL Unique   ENABLED RODZAJ_BILANS, ID_ROKU

Table KG_SL_BILANS_HISTORIA does not have...
Partitions
Redaction Policies