Table zfindb.informix.curator_session 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
cs_pk_id serial8 19  √ 
cs_person_zdb_id varchar 50
person.zdb_id curator_session_person_zdb_id_foreign_key_odc C
cs_data_zdb_id varchar 50  √  null
cs_field_name varchar 100
cs_field_name_value lvarchar 1000

Table contained 69,251 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
cs_field_name_value + cs_pk_id Must be unique Asc/Asc cs_pk_id_index
cs_field_name_value + cs_person_zdb_id Performance Asc/Asc curator_session_person_zdb_id_foreign_key_index
cs_field_name_value + cs_person_zdb_id + cs_data_zdb_id + cs_field_name Must be unique Asc/Asc/Asc/Asc curator_session_primary_key_index

Close relationships  within of separation: