SchemaSpy - Table zfindb.informix.run

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

runcan_zdb_id

varchar

blast_query.bqry_runcan_zdb_id

bqry_runcan_zdb_id_foreign_key_odc C

runcan_run_zdb_id

varchar

run.run_zdb_id

runcan_run_zdb_id_foreign_key_odc C

runcan_cnd_zdb_id

varchar

candidate.cnd_zdb_id

runcan_cnd_zdb_id_foreign_key_odc C

runcan_done

boolean

runcan_locked_by

varchar

√

null

runcan_occurrence_order

int

Table contained 5,127 rows at Thu Jun 22 08:42 PDT 2017

Indexes:

Column(s)	Type	Sort	Constraint Name
runcan_done + runcan_zdb_id	Must be unique	Asc/Asc	run_candidate_primary_key_index
runcan_done + runcan_cnd_zdb_id	Performance	Asc/Asc	runcan_cnd_zdb_id_foreign_key_index
runcan_done + runcan_run_zdb_id	Performance	Asc/Asc	runcan_run_zdb_id_foreign_key_index