Table zfindb.public.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 text 2147483647
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 text 2147483647  √  null
figure.fig_zdb_id image_fig_foreign_key_odc C
img_label text 2147483647  √  null
img_comments text 2147483647  √  null
img_annotation text 2147483647  √  null
img_width int4 10
img_height int4 10
img_view text 2147483647
image_view.imgview_name img_view_foreign_key R
img_direction text 2147483647
image_direction.imgdir_name img_direction_foreign_key R
img_form text 2147483647
image_form.imgform_name img_form_foreign_key R
img_preparation text 2147483647
image_preparation.imgprep_name img_preparation_foreign_key R
img_owner_zdb_id text 2147483647
person.zdb_id img_owner_zdb_id_foreign_key R
img_external_name text 2147483647  √  null
img_image text 2147483647
img_image_with_annotation text 2147483647  √  null
img_thumbnail text 2147483647
img_is_video_still bool 1 false
img_inserted_date date 13  √  now()
img_updated_date date 13  √  now
img_inserted_by text 2147483647  √  null
img_updated_by text 2147483647  √  null
img_medium text 2147483647  √  null
img_image_with_annotation_medium text 2147483647  √  null

Table contained 132,299 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
img_zdb_id Primary key Asc image_primary_key
img_fig_zdb_id Performance Asc image_figure_foreign_key_index
img_image Performance Asc image_img_image_index
img_direction Performance Asc img_direction_index
img_form Performance Asc img_form_index
img_owner_zdb_id Performance Asc img_owner_zdb_id_index
img_preparation Performance Asc img_preparation_index
img_view Performance Asc img_view_index

Close relationships  within of separation: