SchemaSpy - Table zfindb.informix.term

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

termrel_zdb_id

varchar

zdb_active_data.zactvd_zdb_id

termrel_zactvd_foreign_key_odc C

termrel_term_1_zdb_id

varchar

term.term_zdb_id

termrel_term_1_zdb_id_foreign_key_to_term_odc C

termrel_term_2_zdb_id

varchar

term.term_zdb_id

termrel_term_2_zdb_id_foreign_key_to_term_odc C

termrel_type

varchar

100

rermrel_type_foreign_key_to_term R

Table contained 372,623 rows at Thu Jun 22 08:42 PDT 2017

Indexes:

Column(s)	Type	Sort	Constraint Name
termrel_term_1_zdb_id + termrel_term_2_zdb_id + termrel_type	Must be unique	Asc/Asc/Asc	term_relationship_alternate_key_index
termrel_zdb_id	Must be unique	Asc	term_relationship_primary_key_index
termrel_term_1_zdb_id	Performance	Asc	tmrel_term_1_foreign_key_to_term_index
termrel_term_2_zdb_id	Performance	Asc	tmrel_term_2_foreign_key_to_term_index
termrel_type	Performance	Asc	tmrel_type_foreign_key_to_term_index