Comment for Table USLUGI_DZIAL_REG_SP_ROZ
Comment
Sposób rozliczania przedsiebiorstwa

Columns of Table USLUGI_DZIAL_REG_SP_ROZ
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).

Indexes on Table USLUGI_DZIAL_REG_SP_ROZ
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>        

Foreign Key Constraints on Table USLUGI_DZIAL_REG_SP_ROZ
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

PK, UK, & Check Constraints on Table USLUGI_DZIAL_REG_SP_ROZ
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

Table USLUGI_DZIAL_REG_SP_ROZ does not have...
Partitions
Redaction Policies