Table zfindb.informix.lab_address_update_tracking 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
laut_pk_id serial8 19  √ 
laut_lab_zdb_id varchar 50
lab.zdb_id laut_lab_zdb_id_foreign_key C
laut_previous_address lvarchar 450
laut_new_address lvarchar 450

Table contained 253 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
laut_new_address + laut_previous_address + laut_lab_zdb_id Performance Asc/Asc/Asc laut_lab_id_index
laut_new_address + laut_previous_address + laut_pk_id Must be unique Asc/Asc/Asc laut_pk_id_primary_key_index

Close relationships  within of separation: