Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table MAG_ZAMOWIENIA | Next Table |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID | NUMBER(11) | Y | ||
2 | NUMER | NUMBER(11) | Y | ||
3 | DATA_AKCEPT_ODRZUC | DATE | |||
4 | DATA_ZAMOWIENIA | DATE | Y | ||
5 | DATA_ZAMKNIECIA | DATE | |||
6 | DATA_DOSTAWY | DATE | |||
7 | OPERATOR | VARCHAR2(30 BYTE) | |||
8 | OSOBA_AKCEPT | VARCHAR2(30 BYTE) | |||
9 | MIEJSCE_DOSTAWY | NCLOB | |||
10 | UWAGI | NCLOB | |||
11 | NR_KONTR | NUMBER(11) | Y | ||
12 | WALUTA | VARCHAR2(3 BYTE) | Y | ||
13 | RODZAJ_DOSTAWY | NUMBER(11) | Y | ||
14 | STATUS | NUMBER(11) | Y | ||
15 | AUTOR | VARCHAR2(30 CHAR) | Nazwa uzytkownika django ktory jest autorem zamowienia. | ||
16 | ADMINISTRATORA | VARCHAR2(1 CHAR) | Y | 'N' | Jezeli T to znaczy ze to administrator a nie klient utworzyl zamowienie. Kolumna niezbedna do rozruzniania niezlozonych zamowien przez admina lub klienta. |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_MAGZAMMOWIE_RODZAJDOSTAWY | NORMAL | RODZAJ_DOSTAWY | <none> | ||||
NON-UNIQUE | IX_MAGZAMMOWIE_STATUS | NORMAL | STATUS | <none> | ||||
UNIQUE | SYS_C0057738 | NORMAL | ID | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
SYS_C0059602 | RODZAJ_DOSTAWY | F_54 | MAG_ZAMOWIENIA_RODZ_DOST | ID | NO ACTION | ENABLED | Yes | Yes |
SYS_C0059603 | STATUS | F_54 | MAG_ZAMOWIENIA_STATUSY | ID | NO ACTION | ENABLED | Yes | Yes |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
SYS_C0056366 | Check | "ID" IS NOT NULL | ENABLED | ID |
SYS_C0056367 | Check | "NUMER" IS NOT NULL | ENABLED | NUMER |
SYS_C0056368 | Check | "DATA_ZAMOWIENIA" IS NOT NULL | ENABLED | DATA_ZAMOWIENIA |
SYS_C0056369 | Check | "NR_KONTR" IS NOT NULL | ENABLED | NR_KONTR |
SYS_C0056370 | Check | "WALUTA" IS NOT NULL | ENABLED | WALUTA |
SYS_C0056371 | Check | "RODZAJ_DOSTAWY" IS NOT NULL | ENABLED | RODZAJ_DOSTAWY |
SYS_C0056372 | Check | "STATUS" IS NOT NULL | ENABLED | STATUS |
SYS_C0056373 | Check | "ADMINISTRATORA" IS NOT NULL | ENABLED | ADMINISTRATORA |
SYS_C0057738 | Primary Key | ENABLED | ID |
Comments |
Partitions |
Redaction Policies |