Comment for Table SL_DOKMAG
Comment
slownik dokumentow magazynowych

Columns of Table SL_DOKMAG
Column ID Column Name Datatype Not Null Data Default Comments
1 DOWOD VARCHAR2(3 BYTE) Y   identyfikator dowodu
2 NAZWA VARCHAR2(40 BYTE)     nazwa dokumentu
3 TYP CHAR(1 BYTE)     typ
4 KONTO VARCHAR2(32 BYTE)     konto
5 ID_REGULY NUMBER(8)     id reguly ksiegowania
6 KOREKTA CHAR(1 BYTE)   'N' czy dokument jest korekta
7 DOWOD_K VARCHAR2(3 BYTE)     jaki dokument koryguje jesli ten dokument jest korekta

Indexes on Table SL_DOKMAG
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX_SLDOKMSLDOK_DOWODK NORMAL DOWOD_K <none>        
NON-UNIQUE IX_SLDOKMSLDOK_IDREGULY NORMAL ID_REGULY <none>        
UNIQUE PK_SLDOKMAG NORMAL DOWOD <none>        

Foreign Key Constraints on Table SL_DOKMAG
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_DOKMAG_DOKMAG DOWOD_K F_54 SL_DOKMAG DOWOD NO ACTION ENABLED No No
FK_DOKMAG_REGULYKS ID_REGULY F_54 REGULY_KS ID_REGULY NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table SL_DOKMAG
Constraint Name Type Condition Status Columns
PK_SLDOKMAG Primary Key   ENABLED DOWOD

Table SL_DOKMAG does not have...
Partitions
Redaction Policies