Table zfindb.informix.image 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
img_zdb_id varchar 50
image_stage.imgstg_img_zdb_id imgstg_img_zdb_id_foregin_key C
int_image_term.iit_img_zdb_id iit_img_zdb_id_foreign_key R
video.video_image_still_zdb_id video_image_still_zdb_id_foreign_key R
zdb_active_data.zactvd_zdb_id img_zdb_id_foreign_key_odc C
img_fig_zdb_id varchar 50  √  null
figure.fig_zdb_id image_fig_foreign_key_odc C
img_label varchar 200  √  null
img_comments lvarchar 2048  √  null
img_annotation lvarchar 2048  √  null
img_width int 10
img_height int 10
img_view varchar 20
image_view.imgview_name img_view_foreign_key R
img_direction varchar 30
image_direction.imgdir_name img_direction_foreign_key R
img_form varchar 15
image_form.imgform_name img_form_foreign_key R
img_preparation varchar 15
image_preparation.imgprep_name img_preparation_foreign_key R
img_owner_zdb_id varchar 50
person.zdb_id img_owner_zdb_id_foreign_key R
img_external_name varchar 100  √  null
img_image varchar 150
img_image_with_annotation varchar 150  √  null
img_thumbnail varchar 150
img_is_video_still boolean 1 f

Table contained 103,203 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
img_annotation + img_comments + img_is_video_still + img_fig_zdb_id Performance Asc/Asc/Asc/Asc image_figure_foreign_key_index
img_annotation + img_comments + img_is_video_still + img_image Performance Asc/Asc/Asc/Asc image_img_image_index
img_annotation + img_comments + img_is_video_still + img_zdb_id Must be unique Asc/Asc/Asc/Asc image_primary_key_index
img_annotation + img_comments + img_is_video_still + img_direction Performance Asc/Asc/Asc/Asc img_direction_index
img_annotation + img_comments + img_is_video_still + img_form Performance Asc/Asc/Asc/Asc img_form_index
img_annotation + img_comments + img_is_video_still + img_owner_zdb_id Performance Asc/Asc/Asc/Asc img_owner_zdb_id_index
img_annotation + img_comments + img_is_video_still + img_preparation Performance Asc/Asc/Asc/Asc img_preparation_index
img_annotation + img_comments + img_is_video_still + img_view Performance Asc/Asc/Asc/Asc img_view_index

Close relationships  within of separation: