Columns of Table POST_CZYNNOSCI_ZALACZ
Column ID Column Name Datatype Not Null Data Default Comments
1 ID NUMBER Y    
2 PLIK BLOB Y    
3 NAZWA_PLIKU VARCHAR2(50 CHAR) Y    
4 POST_CZYNNOSCI_ID NUMBER Y   Klucz obcy do tabeli POST_CZYNNOSCI.ID wskazujący na czynnść, z którą powiązany jest załącznik.
5 UTW_USR VARCHAR2(30 CHAR)   USER  
6 UTW_DAT DATE   SYSDATE  
7 MOD_USR VARCHAR2(30 CHAR)      
8 MOD_DAT DATE      

Indexes on Table POST_CZYNNOSCI_ZALACZ
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE PK_POST_CZYNNOSCI_ZALACZ NORMAL ID <none>        

Foreign Key Constraints on Table POST_CZYNNOSCI_ZALACZ
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_POSTCZZA_POSTCZ POST_CZYNNOSCI_ID F_54 POST_CZYNNOSCI ID NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table POST_CZYNNOSCI_ZALACZ
Constraint Name Type Condition Status Columns
NN_POSTCZZA_0 Check "ID" IS NOT NULL ENABLED ID
NN_POSTCZZA_1 Check "PLIK" IS NOT NULL ENABLED PLIK
NN_POSTCZZA_2 Check "NAZWA_PLIKU" IS NOT NULL ENABLED NAZWA_PLIKU
NN_POSTCZZA_3 Check "POST_CZYNNOSCI_ID" IS NOT NULL ENABLED POST_CZYNNOSCI_ID
PK_POST_CZYNNOSCI_ZALACZ Primary Key   ENABLED ID

Table POST_CZYNNOSCI_ZALACZ does not have...
Comments
Partitions
Redaction Policies