SchemaSpy - View transmart.biomart.vw_faceted

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
analysis_id	int8	19	√	null
study	int8	19	√	null
study_id	int8	19	√	null
analyses	varchar	200	√	null
data_type	varchar	50	√	null
platform	varchar	20	√	null
platform_description	varchar	2000	√	null
platform_vendor	varchar	200	√	null
platform_name	varchar	200	√	null
observation	text	2147483647	√	null
study_title	varchar	1000	√	null
study_description	varchar	4000	√	null
study_design	varchar	2000	√	null
study_primary_inv	varchar	400	√	null
study_contact_field	varchar	400	√	null
study_overall_design	varchar	2000	√	null
study_institution	varchar	400	√	null
study_accession	varchar	100	√	null
study_country	varchar	1000	√	null
study_biomarker_type	varchar	255	√	null
study_target	varchar	255	√	null
study_access_type	varchar	100	√	null
analysis_name	varchar	500	√	null
analysis_description_s	varchar	510	√	null
analysis_description_l	varchar	4000	√	null
analysis_type	varchar	200	√	null
analysis_analyst_name	varchar	250	√	null
analysis_method	varchar	50	√	null
analysis_data_type	varchar	50	√	null
analysis_qa_criteria	varchar	4000	√	null
model_name	varchar	100	√	null
model_description	varchar	500	√	null
research_unit	varchar	500	√	null
facet_id	int8	19	√	null

Analyzed at Wed Jun 26 00:10 CEST 2019