Table zfindb.informix.construct 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
construct_zdb_id varchar 50
construct_figure.consfig_construct_zdb_id construct_figure_construct_zdb_id_foreign_key_odc C
construct_marker_relationship.conmrkrrel_construct_zdb_id cmr_construct_fk_odc C
zdb_active_data.zactvd_zdb_id construct_zdb_active_data_foreign_key_odc C
construct_name varchar 255
construct_date_inserted datetime year to second 19 current
construct_date_modified datetime year to second 19  √  current
construct_type varchar 10
marker_types.marker_type construct_type_foreign_key R
construct_owner_zdb_id varchar 50
person.zdb_id construct_owner_zdb_id R
construct_comments lvarchar 2048  √  null

Table contained 3,080 rows at Tue Nov 10 13:18 PST 2015

Indexes:
Column(s) Type Sort Constraint Name
construct_comments + construct_type Performance Asc/Asc 5433_97873
construct_comments + construct_owner_zdb_id Performance Asc/Asc 5433_97874
construct_comments + construct_name Must be unique Asc/Asc construct_name_alternate_key_index
construct_comments + construct_zdb_id Must be unique Asc/Asc construct_pk_index

Close relationships  within of separation: