Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table CENNIK | Next Table |
Comment |
---|
Tabela dla cennika towarow i uslug |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | NR_KATAL | NUMBER(9) | numer katalogowy | ||
2 | DATAOC | DATE | Y | Data od kiedy obowiązuje cennik | |
3 | C_NETTO | NUMBER(12,2) | Cena detaliczna - najwyzsza sposrod wszystkich cen | ||
4 | C_BRUTTO | NUMBER(12,2) | Cena brutto | ||
5 | WALUTA | VARCHAR2(3 BYTE) | waluta ceny | ||
6 | NETTO_A | NUMBER(12,2) | Cena Netto A - pierwszy poziom cen | ||
7 | NETTO_B | NUMBER(12,2) | Cena Netto B - drugi poziom cen | ||
8 | NETTO_C | NUMBER(12,2) | Cena Netto C - trzeci poziom cen | ||
9 | ID | NUMBER | kolumna z kluczem glownym (na razie udajaca tylko klucz glowny ze wzgledu na kompatybilnosc z forms) |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
UNIQUE | IX1_CENNIK | NORMAL | NR_KATAL, DATAOC | <none> | ||||
NON-UNIQUE | IX_CENNIK_WALUTA | NORMAL | WALUTA | <none> | ||||
UNIQUE | UQ_PK_CENNIK | NORMAL | ID | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_CENNIK_KIT | NR_KATAL | F_54 | KIT | NR_KATAL | NO ACTION | ENABLED | No | No |
FK_CENNIK_WALUTA | WALUTA | F_54 | SL_WALUTY | WALUTA | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_CENNIK_DATAOC | Check | "DATAOC" IS NOT NULL | ENABLED | DATAOC |
UQ_PK_CENNIK | Unique | ENABLED | ID |
Partitions |
Redaction Policies |