Table zfindb.public.probe_library 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
probelib_zdb_id text 2147483647
zdb_active_data.zactvd_zdb_id probelib_zdb_id_foreign_key C
probelib_name text 2147483647  √  null
probelib_url text 2147483647  √  null
probelib_species text 2147483647
organism.organism_species probelib_species_foreign_key R
probelib_non_zfin_strain_name text 2147483647  √  null
probelib_strain_zdb_id text 2147483647  √  null
genotype.geno_zdb_id probelib_strain_foreign_key_odc C
probelib_sex text 2147483647  √  null
probelib_non_zfin_tissue_name text 2147483647  √  null
probelib_tissue_zdb_id text 2147483647  √  null
term.term_zdb_id probelib_tissue_zdb_id_foreign_key R
probelib_non_zfin_stg_name text 2147483647  √  null
probelib_stg_zdb_id text 2147483647  √  null
stage.stg_zdb_id probelib_stg_zdb_id_foreign_key R
probelib_host text 2147483647  √  null
probelib_restriction_sites text 2147483647  √  null
probelib_term_zdb_id text 2147483647  √  null

Table contained 103 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name Anomalies
probelib_zdb_id Primary key Asc probe_library_primary_key  
probelib_name Must be unique Asc probelib_name_index This unique column is also nullable
probelib_species Performance Asc probelib_species_index  
probelib_stg_zdb_id Performance Asc probelib_stg_zdb_id_index  
probelib_strain_zdb_id Performance Asc probelib_strain_zdb_id_index  
probelib_tissue_zdb_id Performance Asc probelib_tissue_zdb_id_index  

Close relationships  within of separation: