Comment for Table MGINWE
Comment
glowna tabela dla inwentaryzacji

Columns of Table MGINWE
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      

Indexes on Table MGINWE
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>        

Foreign Key Constraints on Table MGINWE
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

PK, UK, & Check Constraints on Table MGINWE
Constraint Name Type Condition Status Columns
PK_MGINWE Primary Key   ENABLED ID_INWE

Table MGINWE does not have...
Partitions
Redaction Policies