Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table MGINWE | Next Table |
Comment |
---|
glowna tabela dla inwentaryzacji |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_INWE | NUMBER(8) | Y | inwentaryzacja (PK) | |
2 | NR_INWE | NUMBER(8) | kolejny numer inwentaryzacji | ||
3 | OPIS | VARCHAR2(80 BYTE) | |||
4 | MAGAZYN | NUMBER(3) | |||
5 | DT_INWE | DATE | |||
6 | DT_AKCEPT | DATE | |||
7 | STAN | CHAR(1 BYTE) | '1' | ||
8 | DT_ROZP | DATE | |||
9 | DT_ZAK | DATE | |||
10 | PWI | NUMBER | |||
11 | RWI | NUMBER |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | INDX_MGINWE_PWI | NORMAL | PWI | <none> | ||||
NON-UNIQUE | INDX_MGINWE_RWI | NORMAL | RWI | <none> | ||||
NON-UNIQUE | IX_MGINWE_MAGAZYN | NORMAL | MAGAZYN | <none> | ||||
UNIQUE | PK_MGINWE | NORMAL | ID_INWE | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_MGINWE_MAGAZYNY | MAGAZYN | F_54 | MAGAZYNY | MAGAZYN | NO ACTION | ENABLED | No | No |
SYS_C0058802 | PWI | F_54 | MAG_DOWODY | ID_DOWODU | NO ACTION | ENABLED | No | No |
SYS_C0058803 | RWI | F_54 | MAG_DOWODY | ID_DOWODU | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
PK_MGINWE | Primary Key | ENABLED | ID_INWE |
Partitions |
Redaction Policies |