Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table PARAM_WARTOSCI_LISTY | Next Table |
Comment |
---|
Listy wartości dla parametrów określonych w PARAM_WARTOSCI/SL_PARAM_PARAMETRY. |
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. |
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> |
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 |
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 |
Partitions |
Redaction Policies |