Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table SL_PARAMETRY_SPRAWOZDANIA | Next Table |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | PARAMETR | VARCHAR2(200 BYTE) | Nazwa parametru | ||
2 | DATA_OBOWIAZYWANIA_OD | DATE | Data, od kiedy obowiązuje parametr | ||
3 | WARTOSC | NUMBER(10,3) | Wartość parametru | ||
4 | ID | NUMBER(10) | Y | PK | |
5 | ID_GMINY | NUMBER | FK - id gminy, której dotyczy parametr (klucz od tabeli GMINY). Jeśli NULL, to parametr jest ogólny dla wszystkich gmin. |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_SLPARAWOZDA_IDGMINY | NORMAL | ID_GMINY | <none> | ||||
UNIQUE | PK_SL_PARAMETRY_SPRAWOZ_ID | NORMAL | ID | <none> | ||||
UNIQUE | UQ_SL_PARAMERTY_SPR_PARAMETR | NORMAL | PARAMETR, DATA_OBOWIAZYWANIA_OD, ID_GMINY | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_SL_PARAM_SPRAWOZ_ID_GMINY | ID_GMINY | F_54 | GMINY | ID_GMINY | NO ACTION | ENABLED | No | No |
FK_SL_PARAM_SPRAWOZ_NAZWA_PARA | PARAMETR | F_54 | SL_PARAMETRY_SPRAWOZDANIA_OPIS | NAZWA_PARAMETRU | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
PK_SL_PARAMETRY_SPRAWOZ_ID | Primary Key | ENABLED | ID | |
UQ_SL_PARAMERTY_SPR_PARAMETR | Unique | ENABLED | PARAMETR, DATA_OBOWIAZYWANIA_OD, ID_GMINY |
Comments |
Partitions |
Redaction Policies |