Table zfindb.public.xpat_exp_details_generated 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
xedg_pk_id int8 19
xedg_zdb_id text 2147483647
xedg_fig_zdb_id text 2147483647
xedg_assay_name text 2147483647
xedg_probe_feature_zdb_id text 2147483647  √  null
xedg_gene_zdb_id text 2147483647  √  null
xedg_direct_submission_date timestamp 29,6 now()
xedg_dblink_zdb_id text 2147483647  √  null
xedg_genox_zdb_id text 2147483647  √  null
xedg_atb_zdb_id text 2147483647  √  null

Table contained 142,611 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name
xedg_assay_name Performance Asc xedg_assay_name_foreign_ky_index
xedg_atb_zdb_id Performance Asc xedg_atb_zdb_id_index
xedg_dblink_zdb_id Performance Asc xedg_dblink_foreign_ky
xedg_genox_zdb_id Performance Asc xedg_featexp_zdb_id_foreign_ky_index
xedg_gene_zdb_id Performance Asc xedg_gene_zdb_id_foreign_ky_index
xedg_probe_feature_zdb_id Performance Asc xedg_marker_foreign_ky_index
xedg_fig_zdb_id Performance Asc xedg_source_foreign_ky_index