Table zfindb.informix.probe_library Generated by
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 varchar 50
zdb_active_data.zactvd_zdb_id probelib_zdb_id_foreign_key C
probelib_name varchar 80  √  null
probelib_url varchar 100  √  null
probelib_species varchar 60
organism.organism_species probelib_species_foreign_key R
probelib_non_zfin_strain_name varchar 100  √  null
probelib_strain_zdb_id varchar 50  √  null
genotype.geno_zdb_id probelib_strain_foreign_key_odc C
probelib_sex varchar 15  √  null
probelib_non_zfin_tissue_name varchar 150  √  null
probelib_tissue_zdb_id varchar 50  √  null
term.term_zdb_id probelib_tissue_zdb_id_foreign_key R
probelib_non_zfin_stg_name varchar 80  √  null
probelib_stg_zdb_id varchar 50  √  null
stage.stg_zdb_id probelib_stg_zdb_id_foreign_key R
probelib_host varchar 100  √  null
probelib_restriction_sites varchar 80  √  null
probelib_term_zdb_id varchar 50  √  null

Table contained 103 rows at Thu Jun 22 08:42 PDT 2017

Column(s) Type Sort Constraint Name Anomalies
probelib_zdb_id Must be unique Asc probe_library_primary_key_index  
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: