SchemaSpy - Table transmart.tm_lz.lt_src_study

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
study_id	varchar	100	√	null
title	varchar	1000	√	null
description	varchar	4000	√	null
design	varchar	2000	√	null
start_date	varchar	50	√	null
completion_date	varchar	50	√	null
primary_investigator	varchar	400	√	null
contact_field	varchar	400	√	null
status	varchar	100	√	null
overall_design	varchar	2000	√	null
institution	varchar	100	√	null
country	varchar	50	√	null
biomarker_type	varchar	255	√	null
target	varchar	255	√	null
access_type	varchar	100	√	null
study_owner	varchar	510	√	null
study_phase	varchar	100	√	null
blinding_procedure	varchar	1000	√	null
studytype	varchar	510	√	null
duration_of_study_weeks	varchar	200	√	null
number_of_patients	varchar	200	√	null
number_of_sites	varchar	200	√	null
route_of_administration	varchar	510	√	null
dosing_regimen	varchar	3500	√	null
group_assignment	varchar	510	√	null
type_of_control	varchar	510	√	null
primary_end_points	varchar	2000	√	null
secondary_end_points	varchar	3500	√	null
inclusion_criteria	varchar	4000	√	null
exclusion_criteria	varchar	4000	√	null
subjects	varchar	2000	√	null
gender_restriction_mfb	varchar	510	√	null
min_age	varchar	100	√	null
max_age	varchar	100	√	null
secondary_ids	varchar	510	√	null
development_partner	varchar	100	√	null
geo_platform	varchar	100	√	null
main_findings	varchar	2000	√	null
search_area	varchar	100	√	null
compound	varchar	1000	√	null
disease	varchar	1000	√	null
pubmed_ids	varchar	4000	√	null
organism	varchar	200	√	null
study_title	varchar	500	√	null
study_date	varchar	50	√	null
study_institution	varchar	500	√	null
study_country	varchar	500	√	null
study_related_publication	varchar	500	√	null
study_description	varchar	2000	√	null
study_access_type	varchar	500	√	null
study_objective	varchar	2000	√	null
study_biomarker_type	varchar	500	√	null
study_compound	varchar	500	√	null
study_design_factors	varchar	2000	√	null
study_nbr_subjects	varchar	20	√	null
study_organism	varchar	500	√	null

Table contained 0 rows at Wed Jun 26 00:11 CEST 2019