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

termsub_term_zdb_id

varchar

term.term_zdb_id

termsub_term_zdb_id_foreign_key_odc C

termsub_subset_id

int8

ontology_subset.osubset_pk_id

termsub_subset_id_foreign_key_odc C

Table contained 15,579 rows at Tue Nov 10 13:18 PST 2015

Indexes:

Column(s)	Type	Sort	Constraint Name
termsub_term_zdb_id + termsub_subset_id	Must be unique	Asc/Asc	term_subset_primary_key_index
termsub_subset_id	Performance	Asc	term_subset_subset_id_foreign_key_index
termsub_term_zdb_id	Performance	Asc	term_subset_term_zdb_id_foreign_key_index