Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table PROD_RECEPTURA_SUROWCE | Next Table |
Comment |
---|
Tablica zawiera surowce receptury |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_RECEPTURY_SUR | NUMBER | Y | Klucz główny nadawany z sekwencji SQ_PROD_RECEPT_SUR_ID | |
2 | ID_RECEPTURY | NUMBER | Y | Receptura w skład której wchodzą surowce | |
3 | NAZWA_SUROWCA | VARCHAR2(1023 CHAR) | Nazwa surowca | ||
4 | NR_KATAL_SUROWCA | NUMBER | Nr katalogowy towaru odpowiadającego surowcowi | ||
5 | NAZWA_KIT | VARCHAR2(511 CHAR) | Nazwa artykułu, zapisywana na stałe w momencie tworzenia | ||
6 | KOD_JM | NUMBER | Jednostka miaty, zapisywana na stałe w momencie tworzenia | ||
7 | LICZBA_SUROWCA | NUMBER | Liczba surowca | ||
8 | CENA | NUMBER | Cena jednostkowa | ||
9 | ID_RECEPTURY_SCH_PROD | NUMBER | Etap produkcji |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | FK_PROD_RECEPT_SUR_JM | NORMAL | KOD_JM | <none> | ||||
NON-UNIQUE | FK_PROD_RECEPT_SUR_KIT | NORMAL | NR_KATAL_SUROWCA | <none> | ||||
NON-UNIQUE | FK_PROD_RECEPT_SUR_RECEPT | NORMAL | ID_RECEPTURY | <none> | ||||
NON-UNIQUE | FK_PROD_RECEPT_SUR_SCH | NORMAL | ID_RECEPTURY_SCH_PROD | <none> | ||||
UNIQUE | PK_PROD_RECEPT_SUR_ID | NORMAL | ID_RECEPTURY_SUR | <none> | ||||
UNIQUE | UQ_PROD_RECEPT_SUR | NORMAL | NR_KATAL_SUROWCA, ID_RECEPTURY_SCH_PROD, ID_RECEPTURY | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_PROD_RECEPT_SUR_JM | KOD_JM | F_54 | JM | KOD_JM | NO ACTION | ENABLED | No | No |
FK_PROD_RECEPT_SUR_KIT | NR_KATAL_SUROWCA | F_54 | KIT | NR_KATAL | NO ACTION | ENABLED | No | No |
FK_PROD_RECEPT_SUR_RECEPT | ID_RECEPTURY | F_54 | PROD_RECEPTURA | ID_RECEPTURY | NO ACTION | ENABLED | No | No |
FK_PROD_RECEPT_SUR_SCH | ID_RECEPTURY_SCH_PROD | F_54 | PROD_RECEPTURA_SCH_PROD | ID_RECEPTURY_SCH_PROD | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_PROD_RECEPT_SUR_ID | Check | "ID_RECEPTURY_SUR" IS NOT NULL | ENABLED | ID_RECEPTURY_SUR |
NN_PROD_RECEPT_SUR_ID_REC | Check | "ID_RECEPTURY" IS NOT NULL | ENABLED | ID_RECEPTURY |
PK_PROD_RECEPT_SUR_ID | Primary Key | ENABLED | ID_RECEPTURY_SUR | |
UQ_PROD_RECEPT_SUR | Unique | ENABLED | NR_KATAL_SUROWCA, ID_RECEPTURY_SCH_PROD, ID_RECEPTURY |
Partitions |
Redaction Policies |