Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table USLUGI_DZIAL_REG_SP_ROZ | Next Table |
Comment |
---|
Sposób rozliczania przedsiebiorstwa |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID | NUMBER | Y | PK | |
2 | ID_GMINY | NUMBER | FK do tabeli gminy | ||
3 | DATA_OD | DATE | Y | Data od kiedy przedsiebiorstwo jest rozliczana w podany sposób | |
4 | SPOSOB_ROZLICZENIA | VARCHAR2(1 BYTE) | Y | Sposób rozlieczenia przedsiebiorstwa | |
5 | ID_REJ_REG | NUMBER | Y | FK do tabeli uslugi_dzial_reg_wew | |
6 | ID_ADRES_RDR | NUMBER | Id wersji adresu firmy mającej wpis w RDR. Musi być wypełnione jeśli ID_REJ_REG is not null. Fk USLUGI_DZIAL_REG_WEW_ADRESY(ID_ADRES_RDR). |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | INDX_USLUGI_DZI_IDREJREG | NORMAL | ID_REJ_REG | <none> | ||||
UNIQUE | PK_USLUGI_DZIAL_REG_SP_ROZ | NORMAL | ID | <none> | ||||
UNIQUE | UQ_USL_DZIAL_REG_SR_REJ_REG | NORMAL | ID_GMINY, DATA_OD, ID_REJ_REG | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_USL_DZIAL_REG_SP_ROZ_GMINY | ID_GMINY | F_54 | GMINY | ID_GMINY | NO ACTION | ENABLED | No | No |
FK_USL_DZIAL_REG_SP_ROZ_IDRDR | ID_ADRES_RDR | F_54 | USLUGI_DZIAL_REG_WEW_ADRESY | ID_ADRES_RDR | NO ACTION | ENABLED | No | No |
FK_USL_DZIAL_REG_SR_REJ_REG | ID_REJ_REG | F_54 | USLUGI_DZIAL_REG_WEW | ID_DZIALALNOSCI | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
CH_USL_DZIAL_REG_SR_SR | Check | sposob_rozliczenia IN ('G', 'P') | ENABLED | SPOSOB_ROZLICZENIA |
CK_USL_DZIAL_REG_SR_ID_ADR | Check | ID_ADRES_RDR IS NOT NULL | ENABLED | ID_ADRES_RDR |
NN_USL_DZIAL_REG_SR_DATA_OD | Check | "DATA_OD" IS NOT NULL | ENABLED | DATA_OD |
NN_USL_DZIAL_REG_SR_RR | Check | "ID_REJ_REG" IS NOT NULL | ENABLED | ID_REJ_REG |
NN_USL_DZIAL_REG_SR_SR | Check | "SPOSOB_ROZLICZENIA" IS NOT NULL | ENABLED | SPOSOB_ROZLICZENIA |
PK_USLUGI_DZIAL_REG_SP_ROZ | Primary Key | ENABLED | ID | |
UQ_USL_DZIAL_REG_SR_REJ_REG | Unique | ENABLED | ID_GMINY, DATA_OD, ID_REJ_REG |
Partitions |
Redaction Policies |