Comment for Table USL_PISMA_ESIGNUM_KORESP
Comment
tabelka mapująca kontrahentow na kor_id (id korespondenta) w systemie eSignum

Columns of Table USL_PISMA_ESIGNUM_KORESP
Column ID Column Name Datatype Not Null Data Default Comments
1 ID NUMBER Y   PK
2 NR_KONTR NUMBER Y   FK do KDO_WEW
3 KOR_ID VARCHAR2(128 BYTE) Y   id korespondenta z systemu eSignum

Indexes on Table USL_PISMA_ESIGNUM_KORESP
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE PK_USL_PISMA_ESIGNUM_KORESP NORMAL ID <none>        
UNIQUE UQ_USL_PISMA_ESIGNUM_KORES_KDO NORMAL NR_KONTR <none>        

Foreign Key Constraints on Table USL_PISMA_ESIGNUM_KORESP
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_USL_PISMA_ESIG_KOR_KDO NR_KONTR F_54 KDO_WEW NR_KONTR NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table USL_PISMA_ESIGNUM_KORESP
Constraint Name Type Condition Status Columns
NN_USL_PISMAESIGKOR_ID Check "ID" IS NOT NULL ENABLED ID
NN_USL_PISMAESIGKOR_KOD_ID Check "KOR_ID" IS NOT NULL ENABLED KOR_ID
NN_USL_PISMAESIGKOR_NR_KONTR Check "NR_KONTR" IS NOT NULL ENABLED NR_KONTR
PK_USL_PISMA_ESIGNUM_KORESP Primary Key   ENABLED ID
UQ_USL_PISMA_ESIGNUM_KORES_KDO Unique   ENABLED NR_KONTR

Table USL_PISMA_ESIGNUM_KORESP does not have...
Partitions
Redaction Policies