Comment for Table PROD_RECEPTURA_SCH_PROD
Comment
Tablica zawiera etapy produkcji receptury

Columns of Table PROD_RECEPTURA_SCH_PROD
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_RECEPTURY_SCH_PROD NUMBER Y   Klucz główny nadawany z sekwencji SQ_PROD_RECEPT_SCH_PROD_ID
2 ID_RECEPTURY NUMBER Y   Receptura której dotyczy etap produkcji
3 NAZWA_ETAPU VARCHAR2(511 CHAR) Y   Nazwa etap
4 NUMER_ETAPU NUMBER Y   Numer etapu

Indexes on Table PROD_RECEPTURA_SCH_PROD
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE FK_PROD_RECEPT_SCH_PROD_RECEPT NORMAL ID_RECEPTURY <none>        
UNIQUE PK_PROD_RECEPT_SCH_PROD_ID NORMAL ID_RECEPTURY_SCH_PROD <none>        

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

PK, UK, & Check Constraints on Table PROD_RECEPTURA_SCH_PROD
Constraint Name Type Condition Status Columns
NN_PROD_RECEPT_SCH_PROD_ID Check "ID_RECEPTURY_SCH_PROD" IS NOT NULL ENABLED ID_RECEPTURY_SCH_PROD
NN_PROD_RECEPT_SCH_PROD_ID_REC Check "ID_RECEPTURY" IS NOT NULL ENABLED ID_RECEPTURY
NN_PROD_RECEPT_SCH_PROD_NAZ Check "NAZWA_ETAPU" IS NOT NULL ENABLED NAZWA_ETAPU
NN_PROD_RECEPT_SCH_PROD_NR Check "NUMER_ETAPU" IS NOT NULL ENABLED NUMER_ETAPU
PK_PROD_RECEPT_SCH_PROD_ID Primary Key   ENABLED ID_RECEPTURY_SCH_PROD

Table PROD_RECEPTURA_SCH_PROD does not have...
Partitions
Redaction Policies