Table zfindb.informix.withdrawn_data Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
wd_pk_id serial8 19  √ 
wd_old_zdb_id varchar 50
wd_new_zdb_id varchar 50
wd_display_note lvarchar 2048  √  null

Table contained 7,651 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
wd_display_note + wd_pk_id Must be unique Asc/Asc 289_407
wd_display_note + wd_new_zdb_id Performance Asc/Asc wd_new_zdb_id_index
wd_display_note + wd_old_zdb_id + wd_new_zdb_id Must be unique Asc/Asc/Asc withdrawn_data__primary_key_index