SchemaSpy - Table transmart.searchapp.search

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

keyword

varchar

400

√

null

bio_data_id

int8

√

null

unique_id

varchar

500

search_keyword_id

int8

bio_analysis_attribute_lineage.ancestor_search_keyword_id	fk_baal_search_keyword R
search_keyword_term.search_keyword_id	search_kw_fk R
search_taxonomy.search_keyword_id	fk_search_tax_search_keyword R
solr_keywords_lineage.search_keyword_id	Implied Constraint R

data_category

varchar

200

source_code

varchar

100

√

null

display_data_category

varchar

200

√

null

owner_auth_user_id

int8

√

null

Table contained 105,716 rows at Wed Jun 26 00:11 CEST 2019

Indexes:

Column(s)	Type	Sort	Constraint Name
search_keyword_id	Primary key	Asc	search_kw_pk
keyword	Performance	Asc	search_keyword_index1
bio_data_id	Performance	Asc	search_keyword_index2
owner_auth_user_id	Performance	Asc	search_keyword_index3
unique_id + data_category	Must be unique	Asc/Asc	search_keyword_uk