Columns of Table KG_HISTORIA
Column ID Column Name Datatype Not Null Data Default Comments
1 ID NUMBER Y   Klucz glowny nadawany z sekwencji SEQ_KG_HISTORIA_ID
2 PARAMETR VARCHAR2(256 BYTE)     Nazwa parametru czyli TABELA.KOLUMNA
3 KLUCZ NUMBER     Klucz po ktorym pobieramy parametr jezeli pusty to pobieramy z jednowierszowej tabeli
4 DATA_OD DATE     Data od ktorej obowiazuje parametr
5 WARTOSC VARCHAR2(256 BYTE)     Wartosc danego parametru

Indexes on Table KG_HISTORIA
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE PK_KG_HISTORIA NORMAL ID <none>        
UNIQUE UQ_KG_HISTORIA_DATA_NUM_KL NORMAL DATA_OD, PARAMETR, KLUCZ <none>        

PK, UK, & Check Constraints on Table KG_HISTORIA
Constraint Name Type Condition Status Columns
NN_KG_HISTORIA_DATA_OD Check "DATA_OD" IS NOT NULL ENABLED DATA_OD
NN_KG_HISTORIA_PARAMETR Check "PARAMETR" IS NOT NULL ENABLED PARAMETR
NN_KG_HISTORIA_WARTOSC Check "WARTOSC" IS NOT NULL ENABLED WARTOSC
PK_KG_HISTORIA Primary Key   ENABLED ID
UQ_KG_HISTORIA_DATA_NUM_KL Unique   ENABLED DATA_OD, PARAMETR, KLUCZ

Table KG_HISTORIA does not have...
Comments
Partitions
Foreign Key Constraints
Redaction Policies