Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table OD_FAKTURY_VAT | Next Table |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID | NUMBER | Y | Klucz glowny PK - z sekwencji | |
2 | ID_OD_FAKTURA | NUMBER | Y | OD_FAKTURA - FK do od_faktury | |
3 | KOD_ST_VAT | CHAR(1 BYTE) | Kod stawki vat - FK do st_vat | ||
4 | TYP_VAT | VARCHAR2(5 BYTE) | 'O' | Typ vatu - default O | |
5 | NETTO | NUMBER | Y | Wartosc netto | |
6 | VAT | NUMBER(12,2) | Kwota vat | ||
7 | TYP_NETTO | VARCHAR2(8 BYTE) | Typ netto - FK do netto | ||
8 | NETTO_WALUTA | NUMBER | Wartosc netto w walucie | ||
9 | VAT_WALUTA | NUMBER | Kwota vat w walucie | ||
10 | OPIS | VARCHAR2(60 BYTE) | Opis | ||
11 | OBSZAR | VARCHAR2(8 BYTE) | |||
12 | ID_AKTYWNOSCI | VARCHAR2(19 BYTE) | |||
13 | GRP_TOW | NUMBER(3) | |||
14 | SYMBOL_MPK | VARCHAR2(20 BYTE) | |||
15 | ID_PWU | NUMBER(8) |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_ODFAKTKTURY_IDODFAKTURA | NORMAL | ID_OD_FAKTURA | <none> | ||||
NON-UNIQUE | IX_ODFAKTKTURY_KODSTVAT | NORMAL | KOD_ST_VAT | <none> | ||||
NON-UNIQUE | IX_ODFAKTKTURY_TYPNETTO | NORMAL | TYP_NETTO | <none> | ||||
UNIQUE | PK_OD_FAKTURY_VAT | NORMAL | ID | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_OD_FAKTURY_VAT_AKTYWNOSC | ID_AKTYWNOSCI | F_54 | AKTYWNOSCI | ID | NO ACTION | ENABLED | No | No |
FK_OD_FAKTURY_VAT_GRUPY_TOW | GRP_TOW | F_54 | GRUPY_TOW | GRP_TOW | NO ACTION | ENABLED | No | No |
FK_OD_FAKTURY_VAT_MAT_MPK | SYMBOL_MPK | F_54 | MAT_MPK | SYMBOL | NO ACTION | ENABLED | No | No |
FK_OD_FAKTURY_VAT_NETTO | TYP_NETTO | F_54 | NETTO | TYP_NETTO | NO ACTION | ENABLED | No | No |
FK_OD_FAKTURY_VAT_OBSZARY | OBSZAR | F_54 | OBSZARY | OBSZAR | NO ACTION | ENABLED | No | No |
FK_OD_FAKTURY_VAT_OD_FAKTURY | ID_OD_FAKTURA | F_54 | OD_FAKTURY | ID | NO ACTION | ENABLED | No | No |
FK_OD_FAKTURY_VAT_ST_VAT | KOD_ST_VAT | F_54 | ST_VAT | KOD_VAT | NO ACTION | ENABLED | No | No |
FK_OD_FAKTURY_VAT_WAR_PWU | ID_PWU | F_54 | WAR_PWU | ID_PWU | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_OD_FAKTURY_VAT_ID_OD_FAK | Check | "ID_OD_FAKTURA" IS NOT NULL | ENABLED | ID_OD_FAKTURA |
NN_OD_FAKTURY_VAT_NETTO | Check | "NETTO" IS NOT NULL | ENABLED | NETTO |
PK_OD_FAKTURY_VAT | Primary Key | ENABLED | ID |
Comments |
Partitions |
Redaction Policies |