Comment for Table FAKTURY_MAG
Comment
powiazanie faktur z dowodami magazynowymi

Columns of Table FAKTURY_MAG
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_FAK NUMBER(8)     faktura
2 ID_DOWODU NUMBER(8)     dowod
3 WARTOSC NUMBER(12,2)     wartosc

Indexes on Table FAKTURY_MAG
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX_FAKTURYMAG1 NORMAL ID_FAK <none>        
NON-UNIQUE IX_FAKTURYMAG2 NORMAL ID_DOWODU <none>        

Foreign Key Constraints on Table FAKTURY_MAG
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_FAKTURYMAG_DOWODY ID_DOWODU F_54 MAG_DOWODY ID_DOWODU NO ACTION ENABLED No No
FK_FAKTURYMAG_FAKTURY ID_FAK F_54 FAKTURY ID_FAK NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table FAKTURY_MAG
Constraint Name Type Condition Status Columns
NN_FAKTURYMAG_IDDOWODU Check "ID_DOWODU" IS NOT NULL ENABLED ID_DOWODU
NN_FAKTURYMAG_IDFAK Check "ID_FAK" IS NOT NULL ENABLED ID_FAK
NN_FAKTURYMAG_WARTOSC Check "WARTOSC" IS NOT NULL ENABLED WARTOSC

Table FAKTURY_MAG does not have...
Partitions
Redaction Policies