Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table FAKTURY_USUNIETE | Next Table |
Comment |
---|
Tabela z opisem i danymi wykasowanej faktury |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_FAK | NUMBER(22) | Y | Id wykasowanej faktury | |
2 | NUMER | VARCHAR2(50 CHAR) | Numer wykasowanej faktury | ||
3 | DATA_FAK | DATE | Data wykasowanej faktury | ||
4 | DA_WPL | DATE | Miesiąc sprzedaży wykasowanej faktury | ||
5 | WARTOSC | NUMBER(12,2) | Wartosc brutto wykasowanej faktury | ||
6 | NR_KONTR | NUMBER(6) | Nr_kontr wykasowanej faktury | ||
7 | OPERATOR | VARCHAR2(30 BYTE) | Operator wystawiajacy fakture | ||
8 | DELETE_DATE | DATE | Y | Data usuniecia faktury | |
9 | DELETE_USER | VARCHAR2(30 BYTE) | Y | Uzytkwonik kasujacy fakture | |
10 | DLETE_OPIS | VARCHAR2(255 BYTE) | Y | Opis powodow usuniecia |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IDX_FAKTURY_USN_DELETE_DATE | NORMAL | DELETE_DATE | <none> |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
SYS_C0054602 | Check | "ID_FAK" IS NOT NULL | ENABLED | ID_FAK |
SYS_C0054603 | Check | "DELETE_DATE" IS NOT NULL | ENABLED | DELETE_DATE |
SYS_C0054604 | Check | "DELETE_USER" IS NOT NULL | ENABLED | DELETE_USER |
SYS_C0054605 | Check | "DLETE_OPIS" IS NOT NULL | ENABLED | DLETE_OPIS |
Partitions |
Foreign Key Constraints |
Redaction Policies |