Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table PROD_RECEPTURA | Next Table |
Comment |
---|
Tablica receptur produkcji |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_RECEPTURY | NUMBER | Y | Klucz główny nadawany z sekwencji SQ_PROD_RECEPTURA_ID | |
2 | NAZWA_RECEPTURY | VARCHAR2(1023 CHAR) | Nazwa receptury | ||
3 | NUMER_RECEPTURY | VARCHAR2(63 CHAR) | Numer receptury, nadawany sekwencyjnie wg. wzoru NUMER/ROK | ||
4 | NR_KATAL_GOT | NUMBER | Towar z katalogu wyborów gotowych | ||
5 | DATA_WPROWADZENIA | TIMESTAMP(6) | Y | SYSDATE | Data wprowadzenia |
6 | LICZBA_PRODUKTOW | NUMBER | Y | 1 | Liczba produktów, których dotyczy receptura |
7 | AUTOR_DJ | VARCHAR2(64 CHAR) | Nazwa wprowadzającego z poziomu DJANGO | ||
8 | ID_STATUSU | NUMBER | Status receptury | ||
9 | NUMER_RECEPTURY_LICZNIK | NUMBER | Numer receptury licznik |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | FK_PROD_RECEPTURA_KIT | NORMAL | NR_KATAL_GOT | <none> | ||||
NON-UNIQUE | FK_PROD_RECEPTURA_ST | NORMAL | ID_STATUSU | <none> | ||||
UNIQUE | PK_PROD_RECEPTURA_ID | NORMAL | ID_RECEPTURY | <none> | ||||
UNIQUE | UQ_PROD_RECEPTURA_NR | NORMAL | NUMER_RECEPTURY | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_PROD_RECEPTURA_KIT | NR_KATAL_GOT | F_54 | KIT | NR_KATAL | NO ACTION | ENABLED | No | No |
FK_PROD_RECEPTURA_ST | ID_STATUSU | F_54 | PROD_SL_RECEPTURA_STATUS | ID_STATUSU | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_PROD_RECEPTURA_DATA | Check | "DATA_WPROWADZENIA" IS NOT NULL | ENABLED | DATA_WPROWADZENIA |
NN_PROD_RECEPTURA_ID | Check | "ID_RECEPTURY" IS NOT NULL | ENABLED | ID_RECEPTURY |
NN_PROD_RECEPTURA_L_PROD | Check | "LICZBA_PRODUKTOW" IS NOT NULL | ENABLED | LICZBA_PRODUKTOW |
PK_PROD_RECEPTURA_ID | Primary Key | ENABLED | ID_RECEPTURY | |
UQ_PROD_RECEPTURA_NR | Unique | ENABLED | NUMER_RECEPTURY |
Partitions |
Redaction Policies |