SchemaSpy - Table transmart.tm_lz.lt_src_clinical

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	25	√	null
site_id	varchar	50	√	null
subject_id	varchar	100	√	null
visit_name	varchar	100	√	null
sample_type	varchar	100	√	null
data_label	varchar	500	√	null
data_value	varchar	500	√	null
category_cd	varchar	250	√	null
data_label_ctrl_vocab_code	varchar	200	√	null
data_value_ctrl_vocab_code	varchar	500	√	null
data_label_components	varchar	1000	√	null
units_cd	varchar	50	√	null
visit_date	varchar	200	√	null
link_type	varchar	20	√	null
link_value	varchar	200	√	null
end_date	varchar	50	√	null
visit_reference	varchar	100	√	null
date_ind	bpchar	1	√	null
obs_string	varchar	100	√	null
valuetype_cd	varchar	50	√	null
date_timestamp	timestamp	29,6	√	null
ctrl_vocab_code	varchar	200	√	null
modifier_cd	varchar	100	√	null
sample_cd	varchar	200	√	null

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