Comment for Table PARAM_WARTOSCI_LISTY
Comment
Listy wartości dla parametrów określonych w PARAM_WARTOSCI/SL_PARAM_PARAMETRY.

Columns of Table PARAM_WARTOSCI_LISTY
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_POZ NUMBER Y   PK z sekwencji sq_Param_wartosci.
2 ID_LISTY NUMBER Y   FK do PARAM_WARTOSCI.id. Identyfikator listy.
3 KOLEJNOSC NUMBER     Liczba porządkowa - określa kolejność parametru w liście.
4 WARTOSC_DATE DATE     Wartość parametru, gdy w słowniku SL_param_parametry.typ_danych = D.
5 WARTOSC_NUMBER NUMBER     Wartość parametru, gdy w słowniku SL_param_parametry.typ_danych = N.
6 WARTOSC_VARCHAR VARCHAR2(2000 CHAR)     Wartość parametru, gdy w słowniku SL_param_parametry.typ_danych = V.
7 WARTOSC_CLOB CLOB     Wartość parametru, gdy w słowniku SL_param_parametry.typ_danych = B.
8 WARTOSC_BLOB BLOB     Wartość parametru, gdy w słowniku SL_param_parametry.typ_danych = C.

Indexes on Table PARAM_WARTOSCI_LISTY
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE INDX_PARAM_WART_IDLISTY NORMAL ID_LISTY <none>        
UNIQUE PK_PARAM_WART_LISTY_ID_POZ NORMAL ID_POZ <none>        

Foreign Key Constraints on Table PARAM_WARTOSCI_LISTY
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_PARAM_WART_LISTY_PARAM_WART ID_LISTY F_54 PARAM_WARTOSCI ID NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table PARAM_WARTOSCI_LISTY
Constraint Name Type Condition Status Columns
CK_PARAM_WART_LISTY_WARTOSC Check ( Wartosc_date is not null and Wartosc_number is null and Wartosc_varchar is null and Wartosc_CLOB is null and Wartosc_BLOB is null) or ( Wartosc_date is null and Wartosc_number is not null and Wartosc_varchar is null and Wartosc_CLOB is null and Wartosc_BLOB is null) or ( Wartosc_date is null and Wartosc_number is null and Wartosc_varchar is not null and Wartosc_CLOB is null and Wartosc_BLOB is null) or ( Wartosc_date is null and Wartosc_number is null and Wartosc_varchar is null and Wartosc_CLOB is not null and Wartosc_BLOB is null) or ( Wartosc_date is null and Wartosc_number is null and Wartosc_varchar is null and Wartosc_CLOB is null and Wartosc_BLOB is not null) ENABLED WARTOSC_BLOB, WARTOSC_CLOB, WARTOSC_DATE, WARTOSC_NUMBER, WARTOSC_VARCHAR
NN_PARAM_WART_LISTY_ID_LISTY Check "ID_LISTY" IS NOT NULL ENABLED ID_LISTY
PK_PARAM_WART_LISTY_ID_POZ Primary Key   ENABLED ID_POZ

Table PARAM_WARTOSCI_LISTY does not have...
Partitions
Redaction Policies