transmart.i2b2demodata contains 448 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
archive_observation_fact	archive_upload_id	numeric	22	√		null
archive_observation_fact	concept_cd	varchar	50	√		null
archive_observation_fact	confidence_num	numeric	18,5	√		null
archive_observation_fact	download_date	timestamp	29,6	√		null
archive_observation_fact	encounter_num	numeric	38	√		null
archive_observation_fact	end_date	timestamp	29,6	√		null
archive_observation_fact	import_date	timestamp	29,6	√		null
archive_observation_fact	instance_num	numeric	18	√		null
archive_observation_fact	location_cd	varchar	50	√		null
archive_observation_fact	modifier_cd	varchar	100	√		null
archive_observation_fact	nval_num	numeric	18,5	√		null
archive_observation_fact	observation_blob	text	2147483647	√		null
archive_observation_fact	patient_num	numeric	38	√		null
archive_observation_fact	provider_id	varchar	50	√		null
archive_observation_fact	quantity_num	numeric	18,5	√		null
archive_observation_fact	sourcesystem_cd	varchar	50	√		null
archive_observation_fact	start_date	timestamp	29,6	√		null
archive_observation_fact	tval_char	varchar	255	√		null
archive_observation_fact	units_cd	varchar	50	√		null
archive_observation_fact	update_date	timestamp	29,6	√		null
archive_observation_fact	upload_id	numeric	38	√		null
archive_observation_fact	valtype_cd	varchar	50	√		null
archive_observation_fact	valueflag_cd	varchar	50	√		null
async_job	alt_viewer_url	varchar	4000	√		null
async_job	id	int4	10
async_job	job_inputs_json	text	2147483647	√		null
async_job	job_name	varchar	200	√		null	The job name. e.g. admin-RHeatmap-100448
async_job	job_results	text	2147483647	√		null
async_job	job_status	varchar	200	√		null	The status of the job. [Started|Cancelled|Error|Completed|...]
async_job	job_status_time	timestamp	29,6	√		null	The time when current job_status took place.
async_job	job_type	varchar	20	√		null
async_job	last_run_on	timestamp	29,6	√		null	The start time of the job.
async_job	run_time	varchar	200	√		null
async_job	user_id	varchar	50	√		null	Name of the user.
async_job	viewer_url	varchar	4000	√		null
cd	concept_path	varchar	500	√		null
cd	parent_concept_path	varchar	500	√		null
cd	patient_count	int8	19	√		null
code_lookup	code_cd	varchar	50
code_lookup	column_cd	varchar	100
code_lookup	download_date	timestamp	29,6	√		null
code_lookup	import_date	timestamp	29,6	√		null
code_lookup	lookup_blob	text	2147483647	√		null
code_lookup	name_char	varchar	650	√		null
code_lookup	sourcesystem_cd	varchar	50	√		null
code_lookup	table_cd	varchar	100
code_lookup	update_date	timestamp	29,6	√		null
code_lookup	upload_date	timestamp	29,6	√		null
code_lookup	upload_id	numeric	38	√		null
concept_counts	concept_path	varchar	500	√		null	The concept path to which patient count is bound.
concept_counts	parent_concept_path	varchar	500	√		null	The concept path of the parent.
concept_counts	patient_count	int8	19	√		null	The number of patients for which there are observations for the concept.
concept_dimension	concept_blob	text	2147483647	√		null
concept_dimension	concept_cd	varchar	50				REQUIRED. The code that is used to refer to the concept from observation_fact.
concept_dimension	concept_path	varchar	700				Primary key. The path that uniquely identifies a concept.
concept_dimension	download_date	timestamp	29,6	√		null
concept_dimension	import_date	timestamp	29,6	√		null
concept_dimension	name_char	varchar	2000	√		null	REQUIRED. The name of the concept.
concept_dimension	sourcesystem_cd	varchar	50	√		null
concept_dimension	table_name	varchar	255	√		null
concept_dimension	update_date	timestamp	29,6	√		null
concept_dimension	upload_id	int8	19	√		null
counter	concept_cd	varchar	50
counter	counts	int8	19	√		null
crc_db_lookup	c_change_date	timestamp	29,6	√		null
crc_db_lookup	c_comment	text	2147483647	√		null
crc_db_lookup	c_db_datasource	varchar	255	√		null
crc_db_lookup	c_db_fullschema	varchar	255	√		null
crc_db_lookup	c_db_nicename	varchar	255	√		null
crc_db_lookup	c_db_servertype	varchar	255	√		null
crc_db_lookup	c_db_tooltip	varchar	255	√		null
crc_db_lookup	c_domain_id	varchar	255	√		null
crc_db_lookup	c_entry_date	timestamp	29,6	√		null
crc_db_lookup	c_owner_id	varchar	255	√		null
crc_db_lookup	c_project_path	varchar	255	√		null
crc_db_lookup	c_status_cd	bpchar	1	√		null
datamart_report	report_date	timestamp	29,6	√		null
datamart_report	total_event	numeric	38	√		null
datamart_report	total_observationfact	numeric	38	√		null
datamart_report	total_patient	numeric	38	√		null
dimloader	c_basecode	varchar	50	√		null
dimloader	c_columndatatype	varchar	50	√		null
dimloader	c_columnname	varchar	50	√		null
dimloader	c_comment	text	2147483647	√		null
dimloader	c_dimcode	varchar	900	√		null
dimloader	c_facttablecolumn	varchar	50	√		null
dimloader	c_fullname	varchar	900	√		null
dimloader	c_hlevel	int8	19	√		null
dimloader	c_metadataxml	text	2147483647	√		null
dimloader	c_name	varchar	2000	√		null
dimloader	c_operator	varchar	10	√		null
dimloader	c_synonym_cd	bpchar	1	√		null
dimloader	c_tablename	varchar	50	√		null
dimloader	c_tooltip	varchar	900	√		null
dimloader	c_totalnum	int8	19	√		null
dimloader	c_visualattributes	bpchar	3	√		null
dimloader	download_date	timestamp	29,6	√		null
dimloader	import_date	timestamp	29,6	√		null
dimloader	sourcesystem_cd	varchar	50	√		null
dimloader	update_date	timestamp	29,6	√		null
dimloader	valuetype_cd	varchar	50	√		null
encounter_mapping	download_date	timestamp	29,6	√		null
encounter_mapping	encounter_ide	varchar	200
encounter_mapping	encounter_ide_source	varchar	50
encounter_mapping	encounter_ide_status	varchar	50	√		null
encounter_mapping	encounter_num	int4	10
encounter_mapping	import_date	timestamp	29,6	√		null
encounter_mapping	patient_ide	varchar	200	√		null
encounter_mapping	patient_ide_source	varchar	50	√		null
encounter_mapping	sourcesystem_cd	varchar	50	√		null
encounter_mapping	update_date	timestamp	29,6	√		null
encounter_mapping	upload_date	timestamp	29,6	√		null
encounter_mapping	upload_id	numeric	38	√		null
hilosequences	highvalues	int8	19
hilosequences	sequencename	varchar	50
jms_messages	destination	varchar	255
jms_messages	messageblob	text	2147483647	√		null
jms_messages	messageid	int8	19
jms_messages	txid	int8	19	√		null
jms_messages	txop	bpchar	1	√		null
jms_roles	roleid	varchar	32
jms_roles	userid	varchar	32
jms_subscriptions	clientid	varchar	128
jms_subscriptions	selector	varchar	255	√		null
jms_subscriptions	subname	varchar	128
jms_subscriptions	topic	varchar	255
jms_transactions	txid	int8	19	√		null
jms_users	clientid	varchar	128	√		null
jms_users	passwd	varchar	32
jms_users	userid	varchar	32
linked_file_collection	id	int4	10
linked_file_collection	name	varchar	900	√		null	Name of the collection.
linked_file_collection	source_system_id	int4	10				The universally unique identifier on the storage system.
linked_file_collection	study_id	int4	10				Points to the study the file associated with.
linked_file_collection	uuid	varchar	50	√		null
map	smaple_id	varchar	100	√		null
map	subject_id	varchar	100	√		null
modifier_dimension	download_date	timestamp	29,6	√		null
modifier_dimension	import_date	timestamp	29,6	√		null
modifier_dimension	modifier_blob	text	2147483647	√		null
modifier_dimension	modifier_cd	varchar	50	√		null	The code that is used to refer to the modifier from obervation_fact. However, it is nullable.
modifier_dimension	modifier_level	int8	19	√		null
modifier_dimension	modifier_node_type	varchar	10	√		null
modifier_dimension	modifier_path	varchar	700				Primary key. The path that uniquely identifies a modifier.
modifier_dimension	name_char	varchar	2000	√		null	The name of the modifier.
modifier_dimension	sourcesystem_cd	varchar	50	√		null
modifier_dimension	update_date	timestamp	29,6	√		null
modifier_dimension	upload_id	int8	19	√		null
modifier_dimension_view	download_date	timestamp	29,6	√		null
modifier_dimension_view	import_date	timestamp	29,6	√		null
modifier_dimension_view	modifier_blob	text	2147483647	√		null
modifier_dimension_view	modifier_cd	varchar	50	√		null
modifier_dimension_view	modifier_level	int8	19	√		null
modifier_dimension_view	modifier_node_type	varchar	10	√		null
modifier_dimension_view	modifier_path	varchar	700	√		null
modifier_dimension_view	name_char	varchar	2000	√		null
modifier_dimension_view	sourcesystem_cd	varchar	50	√		null
modifier_dimension_view	std_units	varchar	50	√		null
modifier_dimension_view	update_date	timestamp	29,6	√		null
modifier_dimension_view	upload_id	int8	19	√		null
modifier_dimension_view	valtype_cd	varchar	10	√		null
modifier_dimension_view	visit_ind	bpchar	1	√		null
modifier_metadata	modifier_cd	varchar	50	√		null
modifier_metadata	std_units	varchar	50	√		null
modifier_metadata	valtype_cd	varchar	10	√		null
modifier_metadata	visit_ind	bpchar	1	√		null
news_updates	commentfield	varchar	200	√		null
news_updates	datasetname	varchar	200	√		null
news_updates	newsid	int4	10	√		null
news_updates	operation	varchar	200	√		null
news_updates	ranbyuser	varchar	200	√		null
news_updates	rowsaffected	int4	10	√		null
news_updates	updatedate	timestamp	29,6	√		null
observation_fact	concept_cd	varchar	50				Primary key. Refers to concept_cd in concept_dimension.
observation_fact	confidence_num	numeric	18,5	√		null
observation_fact	download_date	timestamp	29,6	√		null
observation_fact	encounter_num	int4	10				Primary key. Refers to encounter_num in visit_dimension.
observation_fact	end_date	timestamp	29,6	√		null	The end date-time of the observation
observation_fact	import_date	timestamp	29,6	√		null
observation_fact	instance_num	numeric	18				Primary key. Default: 1.
observation_fact	location_cd	varchar	50	√		null
observation_fact	modifier_cd	varchar	100				Primary key. Refers to modifier_cd in modifier_dimension. Default: @. Highdim values: [TRANSMART:HIGHDIM:GENE EXPRESSION, TRANSMART:HIGHDIM:RNASEQ_TRANSCRIPT], original variable: [TRANSMART:ORIGINAL_VARIABLE], sample type: [TNS:SMPL].
observation_fact	nval_num	numeric	29,16	√		null	Used in conjunction with valtype_cd = N to store a numerical value
observation_fact	observation_blob	text	2147483647	√		null
observation_fact	patient_num	numeric	38				Primary key. Refers to patient_num in patient_dimension.
observation_fact	provider_id	varchar	50				Primary key. Refers to provider_id in provider_dimension.
observation_fact	quantity_num	numeric	18,5	√		null
observation_fact	sample_cd	varchar	200	√		null	Deprecated. Refers to the sample_dimension table.
observation_fact	sourcesystem_cd	varchar	50	√		null	Deprecated. Is currently being ignored.
observation_fact	start_date	timestamp	29,6				Primary key. Starting date-time of the observation. Default: 0001-01-01 00:00:00.
observation_fact	trial_visit_num	numeric	38	√		null	Refers to the new trial_visit dimension. Is not part of the primary key to make the primary key of observation_fact identical with that used by i2b2.
observation_fact	tval_char	varchar	255	√		null	If valtype_cd is T, the observations text value. If valtype_cd is N, an i2b2 supported operator [E = Equals, NE = Not equal, L = Less than, LE = Less than or Equal to, G = Greater than, GE = Greater than or Equal to]
observation_fact	units_cd	varchar	50	√		null
observation_fact	update_date	timestamp	29,6	√		null
observation_fact	upload_id	numeric	38	√		null
observation_fact	valtype_cd	varchar	50	√		null	T for string, N for numeric, B for raw text and D for date values.
observation_fact	valueflag_cd	varchar	50	√		null
patient_dimension	age_in_years_num	numeric	38	√		null
patient_dimension	birth_date	timestamp	29,6	√		null
patient_dimension	death_date	timestamp	29,6	√		null
patient_dimension	download_date	timestamp	29,6	√		null
patient_dimension	import_date	timestamp	29,6	√		null
patient_dimension	income_cd	varchar	50	√		null
patient_dimension	language_cd	varchar	50	√		null
patient_dimension	marital_status_cd	varchar	50	√		null
patient_dimension	patient_blob	text	2147483647	√		null
patient_dimension	patient_num	numeric	38				Primary key. Id of the patient.
patient_dimension	race_cd	varchar	50	√		null
patient_dimension	religion_cd	varchar	50	√		null
patient_dimension	sex_cd	varchar	50	√		null	One of [Male, Female, Unknown].
patient_dimension	sourcesystem_cd	varchar	107	√		null
patient_dimension	statecityzip_path	varchar	700	√		null
patient_dimension	update_date	timestamp	29,6	√		null
patient_dimension	upload_id	numeric	38	√		null
patient_dimension	vital_status_cd	varchar	50	√		null
patient_dimension	zip_cd	varchar	50	√		null
patient_mapping	download_date	timestamp	29,6	√		null
patient_mapping	import_date	timestamp	29,6	√		null
patient_mapping	patient_ide	varchar	200				Primary key. Subject identifier associated with a patient.
patient_mapping	patient_ide_source	varchar	50				Primary key. Source of the subject identifier.
patient_mapping	patient_ide_status	varchar	50	√		null
patient_mapping	patient_num	numeric	38				The id of the patient in TranSMART. Refers to patient_num in patient_dimension.
patient_mapping	sourcesystem_cd	varchar	50	√		null
patient_mapping	update_date	timestamp	29,6	√		null
patient_mapping	upload_date	timestamp	29,6	√		null
patient_mapping	upload_id	numeric	38	√		null
patient_trial	patient_num	numeric	131089	√		null	Id that links to the patient_num of the patient_dimension table.
patient_trial	secure_obj_token	varchar	50	√		null	Token referring to bio_data_unique_id in searchapp.search_secure_object. E.g., PUBLIC or EXP:GSE8581.
patient_trial	trial	varchar	30	√		null	Name of the trial.
provider_dimension	download_date	timestamp	29,6	√		null
provider_dimension	import_date	timestamp	29,6	√		null
provider_dimension	name_char	varchar	850	√		null	The name of the provider.
provider_dimension	provider_blob	text	2147483647	√		null
provider_dimension	provider_id	varchar	50				Primary key.
provider_dimension	provider_path	varchar	700				Primary key. A path that identifies a provider.
provider_dimension	sourcesystem_cd	varchar	50	√		null
provider_dimension	update_date	timestamp	29,6	√		null
provider_dimension	upload_id	numeric	38	√		null
qt_analysis_plugin	command_line	text	2147483647	√		null
qt_analysis_plugin	commandoption_cd	text	2147483647	√		null
qt_analysis_plugin	create_date	timestamp	29,6	√		null
qt_analysis_plugin	description	varchar	2000	√		null
qt_analysis_plugin	group_id	varchar	50	√		null
qt_analysis_plugin	parameter_info	text	2147483647	√		null
qt_analysis_plugin	parameter_info_xsd	text	2147483647	√		null
qt_analysis_plugin	plugin_icon	text	2147483647	√		null
qt_analysis_plugin	plugin_id	numeric	10
qt_analysis_plugin	plugin_name	varchar	2000	√		null
qt_analysis_plugin	status_cd	varchar	50	√		null
qt_analysis_plugin	update_date	timestamp	29,6	√		null
qt_analysis_plugin	user_id	varchar	50	√		null
qt_analysis_plugin	version_cd	varchar	50	√		null
qt_analysis_plugin	working_folder	text	2147483647	√		null
qt_analysis_plugin_result_type	plugin_id	numeric	10
qt_analysis_plugin_result_type	result_type_id	numeric	10
qt_breakdown_path	create_date	timestamp	29,6	√		null
qt_breakdown_path	name	varchar	100	√		null
qt_breakdown_path	update_date	timestamp	29,6	√		null
qt_breakdown_path	user_id	varchar	50	√		null
qt_breakdown_path	value	varchar	2000	√		null
qt_patient_enc_collection	encounter_num	numeric	10	√		null
qt_patient_enc_collection	patient_enc_coll_id	numeric	10		√	nextval('i2b2demodata.qt_sq_qper_pecid'::regclass)
qt_patient_enc_collection	patient_num	numeric	10	√		null
qt_patient_enc_collection	result_instance_id	numeric	5	√		null
qt_patient_enc_collection	set_index	numeric	10	√		null
qt_patient_sample_collection	patient_id	int8	19	√		null
qt_patient_sample_collection	result_instance_id	int8	19	√		null
qt_patient_sample_collection	sample_id	int8	19	√		null
qt_patient_set_collection	patient_num	numeric	10	√		null
qt_patient_set_collection	patient_set_coll_id	numeric	10		√	nextval('i2b2demodata.qt_sq_qpr_pcid'::regclass)
qt_patient_set_collection	result_instance_id	numeric	5	√		null
qt_patient_set_collection	set_index	numeric	10	√		null
qt_pdo_query_master	create_date	timestamp	29,6
qt_pdo_query_master	group_id	varchar	50
qt_pdo_query_master	i2b2_request_xml	text	2147483647	√		null
qt_pdo_query_master	query_master_id	numeric	5		√	nextval('i2b2demodata.qt_sq_pqm_qmid'::regclass)
qt_pdo_query_master	request_xml	text	2147483647	√		null
qt_pdo_query_master	user_id	varchar	50
qt_privilege	dataprot_cd	varchar	1000	√		null
qt_privilege	hivemgmt_cd	varchar	1000	√		null
qt_privilege	plugin_id	numeric	10	√		null
qt_privilege	protection_label_cd	varchar	1500	√		null
qt_query_instance	batch_mode	varchar	50	√		null
qt_query_instance	delete_flag	varchar	3	√		null
qt_query_instance	end_date	timestamp	29,6	√		null
qt_query_instance	group_id	varchar	50
qt_query_instance	message	text	2147483647	√		null
qt_query_instance	query_instance_id	numeric	5		√	nextval('i2b2demodata.qt_sq_qi_qiid'::regclass)
qt_query_instance	query_master_id	numeric	5	√		null
qt_query_instance	start_date	timestamp	29,6
qt_query_instance	status_type_id	numeric	5	√		null
qt_query_instance	user_id	varchar	50
qt_query_master	api_version	text	2147483647	√		null
qt_query_master	create_date	timestamp	29,6
qt_query_master	delete_date	timestamp	29,6	√		null
qt_query_master	delete_flag	varchar	3	√		null
qt_query_master	generated_sql	text	2147483647	√		null
qt_query_master	group_id	varchar	50
qt_query_master	i2b2_request_xml	text	2147483647	√		null
qt_query_master	master_type_cd	varchar	2000	√		null
qt_query_master	name	varchar	250
qt_query_master	plugin_id	numeric	10	√		null
qt_query_master	query_master_id	numeric	5		√	nextval('i2b2demodata.qt_sq_qm_qmid'::regclass)
qt_query_master	request_constraints	text	2147483647	√		null
qt_query_master	request_xml	text	2147483647	√		null
qt_query_master	user_id	varchar	50
qt_query_result_instance	delete_flag	varchar	3	√		null
qt_query_result_instance	description	varchar	200	√		null
qt_query_result_instance	end_date	timestamp	29,6	√		null
qt_query_result_instance	message	text	2147483647	√		null
qt_query_result_instance	obfusc_method	varchar	500	√		null
qt_query_result_instance	query_instance_id	numeric	5	√		null
qt_query_result_instance	real_set_size	numeric	10	√		null
qt_query_result_instance	result_instance_id	numeric	5		√	nextval('i2b2demodata.qt_sq_qri_qriid'::regclass)
qt_query_result_instance	result_type_id	numeric	3
qt_query_result_instance	set_size	numeric	10	√		null
qt_query_result_instance	start_date	timestamp	29,6
qt_query_result_instance	status_type_id	numeric	3
qt_query_result_type	description	varchar	200	√		null
qt_query_result_type	display_type_id	varchar	500	√		null
qt_query_result_type	name	varchar	100	√		null
qt_query_result_type	result_type_id	numeric	3		√	nextval('i2b2demodata.qt_sq_qr_qrid'::regclass)
qt_query_result_type	visual_attribute_type_id	varchar	3	√		null
qt_query_status_type	description	varchar	200	√		null
qt_query_status_type	name	varchar	100	√		null
qt_query_status_type	status_type_id	numeric	3		√	nextval('i2b2demodata.qt_sq_qs_qsid'::regclass)
qt_xml_result	result_instance_id	numeric	5	√		null
qt_xml_result	xml_result_id	numeric	5		√	nextval('i2b2demodata.qt_sq_qxr_xrid'::regclass)
qt_xml_result	xml_value	varchar	4000	√		null
relation	biological	bool	1	√		null	Specifies whether relation biological.
relation	left_subject_id	numeric	38				Id of the left subject in the relation.
relation	relation_type_id	int4	10				Relation type id.
relation	right_subject_id	numeric	38				Id of the right subject in the relation.
relation	share_household	bool	1	√		null	Specifies whether subjects share household.
relation_type	biological	bool	1	√		null	Whether relation is biological. e.g. "parent of" is biological. "spouse of" is not.
relation_type	description	text	2147483647	√		null	Detailed description of the relation.
relation_type	id	serial	10		√	nextval('i2b2demodata.relation_type_id_seq'::regclass)
relation_type	label	varchar	200				Short unique name of the relation.
relation_type	symmetrical	bool	1	√		null	Whether relation is symmetrical. e.g. "sibling of" is symmetrical. "parent of" is not.
ricerca	concept_cd	varchar	50
ricerca	concept_path	varchar	700
sample_categories	biobank	varchar	3	√		null
sample_categories	data_types	varchar	2000	√		null
sample_categories	disease	varchar	2000	√		null
sample_categories	field1	varchar	200	√		null
sample_categories	field10	varchar	200	√		null
sample_categories	field11	varchar	200	√		null
sample_categories	field12	varchar	200	√		null
sample_categories	field13	varchar	200	√		null
sample_categories	field14	varchar	200	√		null
sample_categories	field15	varchar	200	√		null
sample_categories	field2	varchar	200	√		null
sample_categories	field3	varchar	200	√		null
sample_categories	field4	varchar	200	√		null
sample_categories	field5	varchar	200	√		null
sample_categories	field6	varchar	200	√		null
sample_categories	field7	varchar	200	√		null
sample_categories	field8	varchar	200	√		null
sample_categories	field9	varchar	200	√		null
sample_categories	sample_cd	varchar	200	√		null
sample_categories	sample_id	varchar	250	√		null
sample_categories	sample_treatment	varchar	2000	√		null
sample_categories	source_organism	varchar	255	√		null
sample_categories	subject_treatment	varchar	2000	√		null
sample_categories	timepoint	varchar	250	√		null
sample_categories	tissue_state	varchar	2000	√		null
sample_categories	tissue_type	varchar	2000	√		null
sample_categories	treatment	varchar	255	√		null
sample_categories	trial_cd	varchar	200	√		null
sample_categories	trial_name	varchar	100	√		null
sample_dimension	sample_cd	varchar	200
set_type	create_date	timestamp	29,6	√		null
set_type	id	serial	10		√	nextval('i2b2demodata.sq_up_patdim_patientnum'::regclass)
set_type	name	varchar	500	√		null
set_upload_status	deleted_record	numeric	131089	√		null
set_upload_status	end_date	timestamp	29,6	√		null
set_upload_status	input_file_name	text	2147483647	√		null
set_upload_status	load_date	timestamp	29,6
set_upload_status	load_status	varchar	100	√		null
set_upload_status	loaded_record	numeric	131089	√		null
set_upload_status	log_file_name	text	2147483647	√		null
set_upload_status	message	text	2147483647	√		null
set_upload_status	no_of_record	numeric	131089	√		null
set_upload_status	set_type_id	int4	10
set_upload_status	source_cd	varchar	50
set_upload_status	transform_name	varchar	500	√		null
set_upload_status	upload_id	numeric	131089
source_master	create_date	timestamp	29,6	√		null
source_master	description	varchar	300	√		null
source_master	source_cd	varchar	50
storage_system	id	int4	10
storage_system	name	varchar	50	√		null	Name of the system.
storage_system	single_file_collections	bool	1	√		null	True for systems where collection=one file, false for those where collection=file tree (like Arvados Keep)
storage_system	system_type	varchar	50	√		null	Storage system type. e.g. Arvados
storage_system	system_version	varchar	50	√		null	Version of the storage system, used for formulating requests by the frontend.
storage_system	url	varchar	900	√		null	URL of the instance.
study	bio_experiment_id	int8	19	√		null	Foreign key: bio_experiment_id in bio_experiment.
study	secure_obj_token	varchar	200				Token needed for access to the study. E.g., ?PUBLIC? or ?EXP:GSE8581?.
study	study_blob	text	2147483647	√		null	Stores arbitrary information about the study
study	study_id	varchar	100				Unique study name. E.g., GSE8581.
study	study_num	numeric	38		√	nextval('i2b2demodata.study_num_seq'::regclass)	Primary key.
supported_workflow	arvados_instance_url	varchar	900	√		null
supported_workflow	arvados_version	varchar	50	√		null
supported_workflow	default_params	text	2147483647	√		null
supported_workflow	description	varchar	900	√		null	The workflow description.
supported_workflow	id	int4	10
supported_workflow	name	varchar	500	√		null	The workflow name.
supported_workflow	uuid	varchar	50				The universally unique identifier of the workflow.
timers	info	text	2147483647	√		null
timers	initialdate	timestamp	29,6
timers	instancepk	text	2147483647	√		null
timers	targetid	varchar	250
timers	timerid	varchar	80
timers	timerinterval	int8	19	√		null
trial_visit_dimension	rel_time_label	varchar	900	√		null	Descriptive name. E.g., Baseline, Week 1.
trial_visit_dimension	rel_time_num	numeric	38	√		null	E.g., 1 (for Week 1).
trial_visit_dimension	rel_time_unit_cd	varchar	50	√		null	The unit in which rel_time_num is expressed. E.g., Week, Day, Visit.
trial_visit_dimension	study_num	numeric	38				Foreign key to study_num in study.
trial_visit_dimension	trial_visit_num	numeric	38		√	nextval('i2b2demodata.trial_visit_num_seq'::regclass)	Primary key.
upload_status	deleted_record	numeric	131089	√		null
upload_status	end_date	timestamp	29,6	√		null
upload_status	input_file_name	text	2147483647	√		null
upload_status	load_date	timestamp	29,6
upload_status	load_status	varchar	100	√		null
upload_status	loaded_record	numeric	131089	√		null
upload_status	log_file_name	text	2147483647	√		null
upload_status	message	text	2147483647	√		null
upload_status	no_of_record	numeric	131089	√		null
upload_status	source_cd	varchar	50
upload_status	transform_name	varchar	500	√		null
upload_status	upload_id	numeric	38		√	nextval('i2b2demodata.sq_uploadstatus_uploadid'::regclass)
upload_status	upload_label	varchar	500
upload_status	user_id	varchar	100
visit_dimension	active_status_cd	varchar	50	√		null
visit_dimension	download_date	timestamp	29,6	√		null
visit_dimension	encounter_num	serial	10		√	nextval('i2b2demodata.visit_dimension_encounter_num_seq'::regclass)	Primary key. Id of the visit. Referred to by the encounter_num column of observation_fact.
visit_dimension	end_date	timestamp	29,6	√		null	End date and time of the visit.
visit_dimension	import_date	timestamp	29,6	√		null
visit_dimension	inout_cd	varchar	50	√		null
visit_dimension	length_of_stay	numeric	38	√		null
visit_dimension	location_cd	varchar	50	√		null
visit_dimension	location_path	varchar	900	√		null
visit_dimension	patient_num	numeric	38				Foreign key. Id linking to patient_num in the patient_dimension.
visit_dimension	sourcesystem_cd	varchar	50	√		null
visit_dimension	start_date	timestamp	29,6	√		null	Start date and time of the visit.
visit_dimension	update_date	timestamp	29,6	√		null
visit_dimension	upload_id	numeric	38	√		null
visit_dimension	visit_blob	text	2147483647	√		null