SchemaSpy - Table zfindb.public.expression

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

xpatex_zdb_id

text

2147483647

expression_experiment.xpatex_zdb_id	Implied Constraint R
expression_experiment_bkup.xpatex_zdb_id	Implied Constraint R
expression_experiment_temp.xpatex_zdb_id	Implied Constraint R
expression_figure_stage.efs_xpatex_zdb_id	efs_xpatex_zdb_id_fk_odc C

zdb_active_data.zactvd_zdb_id

expression_experiment2_zdb_active_data_foreign_key C

xpatex_assay_name

text

2147483647

expression_pattern_assay.xpatassay_name

xpatex2_assay_foregin_key R

xpatex_probe_feature_zdb_id

text

2147483647

√

null

marker.mrkr_zdb_id

expression_experiment2_probe_feature_foreign_key C

xpatex_gene_zdb_id

text

2147483647

√

null

marker.mrkr_zdb_id

xpatex2_gene_zdb_id_foreign_key R

xpatex_direct_submission_date

timestamp

29,6

now()

xpatex_dblink_zdb_id

text

2147483647

√

null

db_link.dblink_zdb_id

expression_experiment2_dblink_foreign_key R

xpatex_genox_zdb_id

text

2147483647

√

null

fish_experiment.genox_zdb_id

xpatex2_genox_foreign_key R

xpatex_atb_zdb_id

text

2147483647

√

null

antibody.atb_zdb_id

xpatex2_atb_zdb_id_foreign_key C

xpatex_source_zdb_id

text

2147483647

√

null

publication.zdb_id

expression_experiment2_source_foreign_key C

Table contained 159,244 rows at Wed Sep 15 00:41 PDT 2021

Indexes:

Column(s)	Type	Sort	Constraint Name
xpatex_zdb_id	Primary key	Asc	expression_experiment2_primary_key
xpatex_source_zdb_id + xpatex_genox_zdb_id + xpatex_assay_name + xpatex_probe_feature_zdb_id + xpatex_gene_zdb_id + xpatex_dblink_zdb_id + xpatex_atb_zdb_id	Must be unique	Asc/Asc/Asc/Asc/Asc/Asc/Asc	expression_experiment2_alternate_key_index
xpatex_assay_name	Performance	Asc	expression_experiment2_assay_name_foreign_key_index
xpatex_probe_feature_zdb_id	Performance	Asc	expression_experiment2_marker_foreign_key_index
xpatex_source_zdb_id	Performance	Asc	expression_experiment2_source_foreign_key_index
xpatex_dblink_zdb_id	Performance	Asc	fx_expression_experiment2_dblink_foreign_key
xpatex_atb_zdb_id	Performance	Asc	xpatex2_atb_zdb_id_index
xpatex_gene_zdb_id	Performance	Asc	xpatex2_gene_zdb_id_foreign_key_index
xpatex_genox_zdb_id	Performance	Asc	xpatex_genox_zdb_id_foreign_key_index