Comment for Table WAR_PWU_KOSZTY
Comment
Tabela kosztĂłw dotyczÄ?cych danego Polecenia Wykonania UsĹ?ugi

Columns of Table WAR_PWU_KOSZTY
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_PWU NUMBER(8) Y   Id Polecenia UsĹ?ugi
2 ID_FAK NUMBER(8)     Id Faktury, ktĂłrej zlecenie dotyczy
3 KWOTA NUMBER(12,2) Y   Kwota jaka byĹ?a potrzebna do zrealizowania usĹ?ugi
4 UWAGI VARCHAR2(120 BYTE)     Uwagi
5 DATA DATE     Data
6 ID_FAK_VAT NUMBER      
7 ID_WAR_PWU_KOSZTY NUMBER Y    

Indexes on Table WAR_PWU_KOSZTY
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX_WARPWUWUKOS_IDFAK NORMAL ID_FAK <none>        
NON-UNIQUE IX_WARPWUWUKOS_IDFAKVAT NORMAL ID_FAK_VAT <none>        
NON-UNIQUE IX_WARPWUWUKOS_IDPWU NORMAL ID_PWU <none>        
UNIQUE PK_WAR_PWU_KOSZTY NORMAL ID_WAR_PWU_KOSZTY <none>        

Foreign Key Constraints on Table WAR_PWU_KOSZTY
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_FAKTURY_WAR_PWUKOSZTY ID_FAK F_54 FAKTURY ID_FAK NO ACTION ENABLED No No
FK_WAR_PWU_KOSZTY_ID_FAK_VAT ID_FAK_VAT F_54 FAKTURY_VAT ID NO ACTION ENABLED No No
FK_WARPWU_WARPWUKOSZTY ID_PWU F_54 WAR_PWU ID_PWU NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table WAR_PWU_KOSZTY
Constraint Name Type Condition Status Columns
SYS_C0054912 Check "ID_PWU" IS NOT NULL ENABLED ID_PWU
SYS_C0054913 Check "KWOTA" IS NOT NULL ENABLED KWOTA
PK_WAR_PWU_KOSZTY Primary Key   ENABLED ID_WAR_PWU_KOSZTY

Table WAR_PWU_KOSZTY does not have...
Partitions
Redaction Policies