Comment for Table PROD_RECEPTURA_ZAL
Comment
Tablica zawiera załączniki dla receptury

Columns of Table PROD_RECEPTURA_ZAL
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_RECEPTURY_ZAL NUMBER Y   Klucz główny nadawany z sekwencji SQ_PROD_RECEPTURA_ZAL_ID
2 ID_RECEPTURY NUMBER Y   Receptura do którego podłączone są załączniki
3 NAZWA_PLIKU VARCHAR2(255 CHAR) Y   Nazwa pliku
4 ZALACZNIK BLOB Y   Załącznik

Indexes on Table PROD_RECEPTURA_ZAL
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE FK_PROD_RECEPT_ZAL_RECEPT NORMAL ID_RECEPTURY <none>        
UNIQUE PK_PROD_RECEPT_ZAL_ID NORMAL ID_RECEPTURY_ZAL <none>        

Foreign Key Constraints on Table PROD_RECEPTURA_ZAL
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_PROD_RECEPT_ZAL_RECEPT ID_RECEPTURY F_54 PROD_RECEPTURA ID_RECEPTURY NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table PROD_RECEPTURA_ZAL
Constraint Name Type Condition Status Columns
NN_PROD_RECEPT_ZAL_ID Check "ID_RECEPTURY_ZAL" IS NOT NULL ENABLED ID_RECEPTURY_ZAL
NN_PROD_RECEPT_ZAL_ID_REC Check "ID_RECEPTURY" IS NOT NULL ENABLED ID_RECEPTURY
NN_PROD_RECEPT_ZAL_NAZWA Check "NAZWA_PLIKU" IS NOT NULL ENABLED NAZWA_PLIKU
NN_PROD_RECEPT_ZAL_ZAL Check "ZALACZNIK" IS NOT NULL ENABLED ZALACZNIK
PK_PROD_RECEPT_ZAL_ID Primary Key   ENABLED ID_RECEPTURY_ZAL

Table PROD_RECEPTURA_ZAL does not have...
Partitions
Redaction Policies