Comment for Table MGA_MPIT_DANE_PIT
Comment
Tabela z danymi do PIT

Columns of Table MGA_MPIT_DANE_PIT
Column ID Column Name Datatype Not Null Data Default Comments
1 ID NUMBER Y   PK
2 NUMER_PODMIOTU VARCHAR2(128 CHAR) Y   Numer podmiotu
3 WARTOSC VARCHAR2(2000 CHAR) Y   Wartość dla pola
4 ID_SL_POLA_DOKUMENTU NUMBER Y   Fk do mga_mpit_sl_pola_dokumentu
5 DATA DATE Y   data dla której jest dana kwota

Indexes on Table MGA_MPIT_DANE_PIT
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE PK_MGA_MPIT_DANE_PIT NORMAL ID <none>        
UNIQUE UQ_MGA_MPIT_DANE_PIT_DANE NORMAL NUMER_PODMIOTU, ID_SL_POLA_DOKUMENTU, DATA <none>        

Foreign Key Constraints on Table MGA_MPIT_DANE_PIT
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_MGA_MPIT_DANE_PIT_SL_POL ID_SL_POLA_DOKUMENTU F_54 MGA_MPIT_SL_POLA_DOKUMENTU ID NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table MGA_MPIT_DANE_PIT
Constraint Name Type Condition Status Columns
NN_MGA_MPIT_DANE_PIT_DATA Check "DATA" IS NOT NULL ENABLED DATA
NN_MGA_MPIT_DANE_PIT_ID_SL Check "ID_SL_POLA_DOKUMENTU" IS NOT NULL ENABLED ID_SL_POLA_DOKUMENTU
NN_MGA_MPIT_DANE_PIT_NR_POD Check "NUMER_PODMIOTU" IS NOT NULL ENABLED NUMER_PODMIOTU
NN_MGA_MPIT_DANE_PIT_WART Check "WARTOSC" IS NOT NULL ENABLED WARTOSC
PK_MGA_MPIT_DANE_PIT Primary Key   ENABLED ID
UQ_MGA_MPIT_DANE_PIT_DANE Unique   ENABLED NUMER_PODMIOTU, ID_SL_POLA_DOKUMENTU, DATA

Table MGA_MPIT_DANE_PIT does not have...
Partitions
Redaction Policies