SchemaSpy - Table zfindb.public.figure

Generated by
SchemaSpy

Legend:

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

fig_zdb_id

text

2147483647

construct_figure.consfig_fig_zdb_id	construct_figure_fig_zdb_id_foreign_key_odc C
genotype_figure_fast_search.gffs_fig_zdb_id	gffs_fig_zdb_id_foreign_key C
image.img_fig_zdb_id	image_fig_foreign_key_odc C
phenotype_experiment.phenox_fig_zdb_id	phenox_fig_foreign_key_odc C
tmp_fish_thatfitthebill.fig_zdb_id	Implied Constraint R
tmp_fishnoeap.fig_zdb_id	Implied Constraint R

zdb_active_data.zactvd_zdb_id

fx_figure_zdb_id_active_data_foreign_key C

fig_source_zdb_id

text

2147483647

zdb_active_source.zactvs_zdb_id

figure_source_foreign_key_odc C

fig_caption

text

2147483647

√

null

fig_comments

text

2147483647

√

null

fig_label

text

2147483647

√

null

fig_full_label

text

2147483647

√

null

fig_inserted_date

date

√

now()

fig_updated_date

date

√

now()

fig_inserted_by

text

2147483647

√

null

fig_updated_by

text

2147483647

√

null

Table contained 128,304 rows at Wed Sep 15 00:41 PDT 2021

Indexes:

Column(s)	Type	Sort	Constraint Name
fig_zdb_id	Primary key	Asc	fx_figure_primary_key_constraint
fig_label	Performance	Asc	fig_label_index
fig_source_zdb_id	Performance	Asc	figure_source_foreign_key_index