test_seqware_meta_db.public contains 596 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
workflow_run	host	text	2147483647	√		'sqwprod.hpc.oicr.on.ca'::text
study	project_id	int4	10			0
registration	developer_ml	bool	1			false
registration	lims_admin	bool	1			false
registration	payee	bool	1			false
file	skip	bool	1	√		false
ius	skip	bool	1	√		false
lane	skip	bool	1	√		false
sequencer_run	skip	bool	1	√		false
processing	task_group	bool	1	√		false
registration	user_ml	bool	1			false
expense_attribute	expense_attribute_id	serial	10		√	nextval('expense_attribute_expense_attribute_id_seq'::regclass)
expense	expense_id	serial	10		√	nextval('expense_expense_id_seq'::regclass)
experiment_attribute	experiment_attribute_id	serial	10		√	nextval('experiment_attribute_experiment_attribute_id_seq'::regclass)
experiment	experiment_id	serial	10		√	nextval('experiment_experiment_id_seq'::regclass)
experiment_library_design	experiment_library_design_id	serial	10		√	nextval('experiment_library_design_experiment_library_design_id_seq'::regclass)
experiment_link	experiment_link_id	serial	10		√	nextval('experiment_link_experiment_link_id_seq'::regclass)
experiment_spot_design	experiment_spot_design_id	serial	10		√	nextval('experiment_spot_design_experiment_spot_design_id_seq'::regclass)
experiment_spot_design_read_spec	experiment_spot_design_read_spec_id	serial	10		√	nextval('experiment_spot_design_read_s_experiment_spot_design_read_s_seq'::regclass)
file_attribute	file_attribute_id	serial	10		√	nextval('file_attribute_id_seq'::regclass)
file	file_id	serial	10		√	nextval('file_file_id_seq'::regclass)
file_report	row_id	serial	10		√	nextval('file_report_row_id_seq'::regclass)
file_type	file_type_id	serial	10		√	nextval('file_type_file_type_id_seq'::regclass)
invoice_attribute	invoice_attribute_id	serial	10		√	nextval('invoice_attribute_invoice_attribute_id_seq'::regclass)
invoice	invoice_id	serial	10		√	nextval('invoice_invoice_id_seq'::regclass)
ius_attribute	ius_attribute_id	serial	10		√	nextval('ius_attribute_ius_attribute_id_seq'::regclass)
ius	ius_id	serial	10		√	nextval('ius_ius_id_seq'::regclass)
ius_workflow_runs	ius_workflow_runs_id	serial	10		√	nextval('ius_workflow_runs_ius_workflow_runs_id_seq'::regclass)
lane_attribute	lane_attribute_id	serial	10		√	nextval('lane_attribute_lane_attribute_id_seq'::regclass)
lane	lane_id	serial	10		√	nextval('lane_lane_id_seq'::regclass)
lane_type	lane_type_id	serial	10		√	nextval('lane_type_lane_type_id_seq'::regclass)
lane_workflow_runs	lane_workflow_runs_id	serial	10		√	nextval('lane_workflow_runs_lane_workflow_runs_id_seq'::regclass)
library_selection	library_selection_id	serial	10		√	nextval('library_selection_library_selection_id_seq'::regclass)
library_source	library_source_id	serial	10		√	nextval('library_source_library_source_id_seq'::regclass)
library_strategy	library_strategy_id	serial	10		√	nextval('library_strategy_library_strategy_id_seq'::regclass)
organism	organism_id	serial	10		√	nextval('organism_organism_id_seq'::regclass)
platform	platform_id	serial	10		√	nextval('platform_platform_id_seq'::regclass)
processing_attribute	processing_attribute_id	serial	10		√	nextval('processing_attribute_processing_attribute_id_seq'::regclass)
processing_experiments	processing_experiments_id	serial	10		√	nextval('processing_experiments_processing_experiments_id_seq'::regclass)
processing_files	processing_files_id	serial	10		√	nextval('processing_files_processing_files_id_seq'::regclass)
processing_ius	processing_ius_id	serial	10		√	nextval('processing_ius_processing_ius_id_seq'::regclass)
processing_lanes	processing_lanes_id	serial	10		√	nextval('processing_lanes_processing_lanes_id_seq'::regclass)
processing	processing_id	serial	10		√	nextval('processing_processing_id_seq'::regclass)
processing_relationship	processing_relationship_id	serial	10		√	nextval('processing_relationship_processing_relationship_id_seq'::regclass)
processing_samples	processing_samples_id	serial	10		√	nextval('processing_samples_processing_samples_id_seq'::regclass)
processing_sequencer_runs	processing_sequencer_runs_id	serial	10		√	nextval('processing_sequencer_runs_processing_sequencer_runs_id_seq'::regclass)
processing_studies	processing_studies_id	serial	10		√	nextval('processing_studies_processing_studies_id_seq'::regclass)
registration	registration_id	serial	10		√	nextval('registration_registration_id_seq'::regclass)
sample_attribute	sample_attribute_id	serial	10		√	nextval('sample_attribute_sample_attribute_id_seq'::regclass)
sample_link	sample_link_id	serial	10		√	nextval('sample_link_sample_link_id_seq'::regclass)
sample_relationship	sample_relationship_id	serial	10		√	nextval('sample_relationship_sample_relationship_id_seq'::regclass)
sample_report	row_id	serial	10		√	nextval('sample_report_row_id_seq'::regclass)
sample	sample_id	serial	10		√	nextval('sample_sample_id_seq'::regclass)
sample_search_attribute	sample_search_attribute_id	serial	10		√	nextval('sample_search_attribute_id_seq'::regclass)
sample_search	sample_search_id	serial	10		√	nextval('sample_search_id_seq'::regclass)
sequencer_run_attribute	sequencer_run_attribute_id	serial	10		√	nextval('sequencer_run_attribute_sequencer_run_attribute_id_seq'::regclass)
sequencer_run	sequencer_run_id	serial	10		√	nextval('sequencer_run_sequencer_run_id_seq'::regclass)
share_study	share_study_id	serial	10		√	nextval('share_study_id_seq'::regclass)
share_workflow_run	share_workflow_run_id	serial	10		√	nextval('share_workflow_run_share_workflow_run_id_seq'::regclass)
study_attribute	study_attribute_id	serial	10		√	nextval('study_attribute_study_attribute_id_seq'::regclass)
study_link	study_link_id	serial	10		√	nextval('study_link_study_link_id_seq'::regclass)
study	study_id	serial	10		√	nextval('study_study_id_seq'::regclass)
study_type	study_type_id	serial	10		√	nextval('study_type_study_type_id_seq'::regclass)
expense	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
experiment	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
file	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
invoice	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
ius	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
lane	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
processing	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
processing_experiments	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
processing_ius	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
processing_lanes	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
processing_samples	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
processing_sequencer_runs	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
processing_studies	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
sample	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
sequencer_run	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
share_experiment	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
share_file	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
share_lane	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
share_processing	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
share_sample	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
share_study	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
share_workflow_run	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
study	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
workflow	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
workflow_run	sw_accession	serial	10	√	√	nextval('sw_accession_seq'::regclass)
version	version_id	serial	10		√	nextval('version_version_id_seq'::regclass)
workflow_attribute	workflow_attribute_id	serial	10		√	nextval('workflow_attribute_id_seq'::regclass)
workflow_param_value	workflow_param_value_id	serial	10		√	nextval('workflow_param_value_workflow_param_value_id_seq'::regclass)
workflow_param	workflow_param_id	serial	10		√	nextval('workflow_param_workflow_param_id_seq'::regclass)
workflow_run_attribute	workflow_run_attribute_id	serial	10		√	nextval('workflow_run_attribute_id_seq'::regclass)
workflow_run_param	workflow_run_param_id	serial	10		√	nextval('workflow_run_param_workflow_run_param_id_seq'::regclass)
workflow_run	workflow_run_id	serial	10		√	nextval('workflow_run_workflow_run_id_seq'::regclass)
workflow	workflow_id	serial	10		√	nextval('workflow_workflow_id_seq'::regclass)
study	abstract	text	2147483647	√		null
experiment	accession	text	2147483647	√		null
organism	accession	text	2147483647	√		null
study	accession	text	2147483647	√		null
experiment_spot_design	adapter_spec	text	2147483647	√		null
sample	adapters	text	2147483647	√		null
expense	added_surcharge	numeric	131089	√		null
expense	agent	text	2147483647	√		null
processing	algorithm	text	2147483647	√		null
experiment	alias	text	2147483647	√		null
ius	alias	text	2147483647	√		null
lane	alias	text	2147483647	√		null
sample	alias	text	2147483647	√		null
study	alias	text	2147483647	√		null
processing	ancestor_workflow_run_id	int4	10	√		null
sample	anonymized_name	text	2147483647	√		null
experiment	base_caller	text	2147483647	√		null
sequencer_run	base_caller	text	2147483647	√		null
experiment_spot_design_read_spec	base_coord	int4	10	√		null
workflow	base_ini_file	text	2147483647	√		null
version	bugfix	int4	10	√		null
experiment	center_name	text	2147483647	√		null
study	center_name	text	2147483647
study	center_project_name	text	2147483647
processing_relationship	child_id	int4	10	√		null
sample_relationship	child_id	int4	10	√		null
file_report	child_sample_id	int4	10	√		null
sample_report	child_sample_id	int4	10	√		null
invoice	client_notes	text	2147483647	√		null
workflow	cmd	text	2147483647	√		null
workflow_run	cmd	text	2147483647	√		null
lane_type	code	text	2147483647	√		null
organism	code	text	2147483647
sequencer_run	color_matrix	text	2147483647	√		null
sequencer_run	color_matrix_code	text	2147483647	√		null
sample	common_name	text	2147483647	√		null
experiment_library_design	construction_protocol	text	2147483647	√		null
experiment	create_tstmp	timestamp	29,6
invoice	create_tstmp	timestamp	29,6
ius	create_tstmp	timestamp	29,6
lane	create_tstmp	timestamp	29,6
processing	create_tstmp	timestamp	29,6
registration	create_tstmp	timestamp	29,6
sample	create_tstmp	timestamp	29,6
sample_search	create_tstmp	timestamp	29,6
sequencer_run	create_tstmp	timestamp	29,6
share_experiment	create_tstmp	timestamp	29,6
share_file	create_tstmp	timestamp	29,6
share_lane	create_tstmp	timestamp	29,6
share_processing	create_tstmp	timestamp	29,6
share_sample	create_tstmp	timestamp	29,6
share_study	create_tstmp	timestamp	29,6
share_workflow_run	create_tstmp	timestamp	29,6
study	create_tstmp	timestamp	29,6
workflow	create_tstmp	timestamp	29,6
workflow_run	create_tstmp	timestamp	29,6
workflow	current_working_dir	text	2147483647	√		null
workflow_run	current_working_dir	text	2147483647	√		null
experiment_spot_design_read_spec	cycle_coord	int4	10	√		null
lane	cycle_count	int4	10	√		null
sequencer_run	cycle_count	int4	10	√		null
lane	cycle_descriptor	text	2147483647	√		null
sequencer_run	cycle_descriptor	text	2147483647	√		null
lane	cycle_sequence	text	2147483647	√		null
sequencer_run	cycle_sequence	text	2147483647	√		null
workflow_run	dax	text	2147483647	√		null
invoice	days_until_due	int4	10	√		null
experiment_link	db	text	2147483647	√		null
ius_link	db	text	2147483647	√		null
lane_link	db	text	2147483647	√		null
sample_link	db	text	2147483647	√		null
study_link	db	text	2147483647	√		null
experiment_spot_design	decode_method	int4	10	√		null
workflow_param	default_value	text	2147483647	√		null
expense	description	text	2147483647	√		null
experiment	description	text	2147483647	√		null
experiment_library_design	description	text	2147483647	√		null
file	description	text	2147483647	√		null
ius	description	text	2147483647	√		null
lane	description	text	2147483647	√		null
library_selection	description	text	2147483647	√		null
library_source	description	text	2147483647	√		null
library_strategy	description	text	2147483647	√		null
platform	description	text	2147483647	√		null
processing	description	text	2147483647	√		null
processing_experiments	description	text	2147483647	√		null
processing_ius	description	text	2147483647	√		null
processing_lanes	description	text	2147483647	√		null
processing_samples	description	text	2147483647	√		null
processing_sequencer_runs	description	text	2147483647	√		null
processing_studies	description	text	2147483647	√		null
sample	description	text	2147483647	√		null
sequencer_run	description	text	2147483647	√		null
study	description	text	2147483647	√		null
study_type	description	text	2147483647	√		null
workflow	description	text	2147483647	√		null
workflow_param	display	bool	1	√		null
file_type	display_name	text	2147483647	√		null
workflow_param	display_name	text	2147483647
workflow_param_value	display_name	text	2147483647
registration	email	text	2147483647
share_study	email	text	2147483647
share_workflow_run	email	text	2147483647
invoice	end_date	date	13
study	existing_type	int4	10
processing	exit_status	int4	10	√		null
experiment_spot_design_read_spec	expected_basecall	text	2147483647	√		null
experiment	expected_number_reads	int8	19	√		null
sample	expected_number_reads	int4	10	√		null
experiment	expected_number_runs	int4	10	√		null
sample	expected_number_runs	int4	10	√		null
experiment	expected_number_spots	int8	19	√		null
sample	expected_number_spots	int4	10	√		null
expense	expense_finished_tstmp	timestamp	29,6	√		null
expense_attribute	expense_id	int4	10
expense	expense_type	text	2147483647	√		null
file_provenance_report	experiment_attrs	text	2147483647	√		null
experiment_attribute	experiment_id	int4	10
experiment_link	experiment_id	int4	10
file_report	experiment_id	int4	10	√		null
processing_experiments	experiment_id	int4	10
sample	experiment_id	int4	10	√		null
share_experiment	experiment_id	int4	10
experiment	experiment_library_design_id	int4	10	√		null
file_provenance_report	experiment_name	text	2147483647	√		null
experiment	experiment_spot_design_id	int4	10	√		null
experiment_spot_design_read_spec	experiment_spot_design_id	int4	10	√		null
file_provenance_report	experiment_swa	int4	10	√		null
file_type	extension	text	2147483647	√		null
invoice	external_id	text	2147483647	√		null
file_provenance_report	file_attrs	text	2147483647	√		null
file_provenance_report	file_description	text	2147483647	√		null
file_attribute	file_id	int4	10
file_report	file_id	int4	10	√		null
processing_files	file_id	int4	10
share_file	file_id	int4	10
workflow_run_input_files	file_id	int4	10	√		null
file_provenance_report	file_md5sum	text	2147483647	√		null
file_provenance_report	file_meta_type	text	2147483647	√		null
workflow_param	file_meta_type	text	2147483647	√		null
file	file_path	text	2147483647
file_provenance_report	file_path	text	2147483647	√		null
sequencer_run	file_path	text	2147483647	√		null
file_provenance_report	file_size	int8	19	√		null
file_provenance_report	file_swa	int4	10	√		null
file	file_type_id	int4	10	√		null
invoice	finalized	bool	1	√		null
registration	first_name	text	2147483647
sequencer_run	flow_count	int4	10	√		null
sequencer_run	flow_sequence	text	2147483647	√		null
invoice	fully_paid	bool	1	√		null
workflow	host	text	2147483647	√		null
experiment_link	id	text	2147483647	√		null
ius_link	id	text	2147483647	√		null
lane_link	id	text	2147483647	√		null
sample_link	id	text	2147483647	√		null
study_link	id	text	2147483647	√		null
sample	individual_name	text	2147483647	√		null
workflow_run	ini_file	text	2147483647	√		null
workflow	input_algorithm	text	2147483647	√		null
registration	institution	text	2147483647	√		null
platform	instrument_model	text	2147483647	√		null
sequencer_run	instrument_name	text	2147483647	√		null
registration	invitation_code	text	2147483647	√		null
expense	invoice_id	int4	10
invoice_attribute	invoice_id	int4	10
sample	is_public	bool	1	√		null
file_provenance_report	ius_attrs	text	2147483647	√		null
file_report	ius_id	int4	10	√		null
ius_attribute	ius_id	int4	10
ius_link	ius_id	int4	10
ius_workflow_runs	ius_id	int4	10
processing_ius	ius_id	int4	10
ius_link	ius_link_id	int4	10
file_provenance_report	ius_swa	int4	10	√		null
file_provenance_report	ius_tag	text	2147483647	√		null
workflow_param	key	text	2147483647
workflow_run_param	key	text	2147483647	√		null
experiment_link	label	text	2147483647	√		null
ius_link	label	text	2147483647
lane_link	label	text	2147483647
processing_experiments	label	text	2147483647	√		null
processing_ius	label	text	2147483647	√		null
processing_lanes	label	text	2147483647	√		null
processing_samples	label	text	2147483647	√		null
processing_sequencer_runs	label	text	2147483647	√		null
processing_studies	label	text	2147483647	√		null
sample_link	label	text	2147483647
study_link	label	text	2147483647
file_provenance_report	lane_attrs	text	2147483647	√		null
file_report	lane_id	int4	10	√		null
ius	lane_id	int4	10
lane_attribute	lane_id	int4	10
lane_link	lane_id	int4	10
lane_workflow_runs	lane_id	int4	10
processing_lanes	lane_id	int4	10
share_lane	lane_id	int4	10
lane	lane_index	int4	10	√		null
lane_link	lane_link_id	int4	10
file_provenance_report	lane_name	text	2147483647	√		null
file_provenance_report	lane_number	int4	10	√		null
file_provenance_report	lane_swa	int4	10	√		null
file_provenance_report	last_modified	timestamp	29,6	√		null
registration	last_name	text	2147483647
registration	last_update_tstmp	timestamp	29,6
experiment_library_design	layout	text	2147483647	√		null
experiment_spot_design_read_spec	length	int4	10	√		null
lane	library_selection	int4	10	√		null
lane	library_source	int4	10	√		null
lane	library_strategy	int4	10	√		null
version	major	int4	10	√		null
file	md5sum	text	2147483647	√		null
file	meta_type	text	2147483647	√		null
file_type	meta_type	text	2147483647	√		null
version	minor	int4	10	√		null
experiment	name	text	2147483647	√		null
experiment_library_design	name	text	2147483647	√		null
ius	name	text	2147483647	√		null
lane	name	text	2147483647	√		null
lane_type	name	text	2147483647	√		null
library_selection	name	text	2147483647	√		null
library_source	name	text	2147483647	√		null
library_strategy	name	text	2147483647	√		null
organism	name	text	2147483647	√		null
platform	name	text	2147483647	√		null
sample	name	text	2147483647	√		null
sequencer_run	name	text	2147483647	√		null
study_type	name	text	2147483647
version	name	text	2147483647	√		null
workflow	name	text	2147483647	√		null
workflow_run	name	text	2147483647	√		null
organism	ncbi_taxid	int4	10	√		null
study	new_type	text	2147483647	√		null
experiment_library_design	nominal_length	int4	10	√		null
experiment_library_design	nominal_sdev	float8	17,17	√		null
invoice	notes	text	2147483647	√		null
file_provenance_report	organism_code	text	2147483647	√		null
file_provenance_report	organism_id	int4	10	√		null
lane	organism_id	int4	10	√		null
sample	organism_id	int4	10	√		null
experiment	owner_id	int4	10	√		null
file	owner_id	int4	10	√		null
invoice	owner_id	int4	10
ius	owner_id	int4	10	√		null
lane	owner_id	int4	10	√		null
processing	owner_id	int4	10	√		null
sample	owner_id	int4	10	√		null
sequencer_run	owner_id	int4	10	√		null
study	owner_id	int4	10	√		null
workflow	owner_id	int4	10	√		null
workflow_run	owner_id	int4	10	√		null
invoice	paid_amount	numeric	131089	√		null
sequencer_run	paired_end	bool	1	√		null
sequencer_run	paired_file_path	text	2147483647	√		null
experiment_library_design	paired_orientation	text	2147483647	√		null
processing	parameters	text	2147483647	√		null
processing_relationship	parent_id	int4	10	√		null
sample_hierarchy	parent_id	int4	10	√		null
sample_relationship	parent_id	int4	10	√		null
file_provenance_report	parent_organism_ids	text	2147483647	√		null
workflow_run_param	parent_processing_accession	int4	10	√		null
registration	password	text	2147483647	√		null
registration	password_hint	text	2147483647	√		null
workflow	permanent_bundle_location	text	2147483647	√		null
experiment	platform_id	int4	10	√		null
file_provenance_report	platform_id	int4	10	√		null
sequencer_run	platform_id	int4	10	√		null
file_provenance_report	platform_name	text	2147483647	√		null
expense	price_per_unit	numeric	131089	√		null
sequencer_run	process	bool	1	√		null
processing	process_exit_status	int4	10	√		null
file_provenance_report	processing_algorithm	text	2147483647	√		null
file_provenance_report	processing_attrs	text	2147483647	√		null
file_report	processing_id	int4	10	√		null
processing_attribute	processing_id	int4	10
processing_experiments	processing_id	int4	10
processing_files	processing_id	int4	10
processing_ius	processing_id	int4	10
processing_lanes	processing_id	int4	10
processing_samples	processing_id	int4	10
processing_sequencer_runs	processing_id	int4	10
processing_studies	processing_id	int4	10
share_processing	processing_id	int4	10
file_provenance_report	processing_swa	int4	10	√		null
experiment	quality_multiplier	int4	10	√		null
experiment	quality_number_of_levels	int4	10	√		null
experiment	quality_scorer	text	2147483647	√		null
sequencer_run	quality_scorer	text	2147483647	√		null
experiment	quality_type	text	2147483647	√		null
experiment_spot_design_read_spec	read_class	text	2147483647	√		null
experiment_spot_design_read_spec	read_index	int4	10	√		null
experiment_spot_design_read_spec	read_label	text	2147483647	√		null
experiment_spot_design	read_spec	text	2147483647	√		null
experiment_spot_design_read_spec	read_type	text	2147483647	√		null
experiment_spot_design	reads_per_spot	int4	10	√		null
sequencer_run	ref_lane	int4	10	√		null
lane	regions	text	2147483647	√		null
sample	regions	text	2147483647	√		null
share_experiment	registration_id	int4	10
share_file	registration_id	int4	10
share_lane	registration_id	int4	10
share_processing	registration_id	int4	10
share_sample	registration_id	int4	10
share_study	registration_id	int4	10
share_workflow_run	registration_id	int4	10
processing_relationship	relationship	text	2147483647	√		null
sample_relationship	relationship	text	2147483647	√		null
sequencer_run	run_center	text	2147483647	√		null
processing	run_start_tstmp	timestamp	29,6	√		null
processing	run_stop_tstmp	timestamp	29,6	√		null
file_provenance_report	sample_attrs	text	2147483647	√		null
file_report	sample_id	int4	10	√		null
ius	sample_id	int4	10
lane	sample_id	int4	10	√		null
processing_samples	sample_id	int4	10
sample_attribute	sample_id	int4	10
sample_hierarchy	sample_id	int4	10
sample_link	sample_id	int4	10
sample_search	sample_id	int4	10
sequencer_run_attribute	sample_id	int4	10
share_sample	sample_id	int4	10
file_provenance_report	sample_name	text	2147483647	√		null
file_provenance_report	sample_parent_attrs	text	2147483647	√		null
file_provenance_report	sample_parent_names	text	2147483647	√		null
file_provenance_report	sample_parent_swas	text	2147483647	√		null
sample_search_attribute	sample_search_id	int4	10
file_provenance_report	sample_swa	int4	10	√		null
sample	scientific_name	text	2147483647	√		null
experiment_library_design	selection	int4	10	√		null
experiment	sequence_space	text	2147483647	√		null
file_provenance_report	sequencer_run_attrs	text	2147483647	√		null
lane	sequencer_run_id	int4	10	√		null
processing_sequencer_runs	sequencer_run_id	int4	10
file_provenance_report	sequencer_run_name	text	2147483647	√		null
file_provenance_report	sequencer_run_swa	int4	10	√		null
workflow_run	seqware_revision	text	2147483647	√		null
workflow	seqware_version	text	2147483647	√		null
share_experiment	share_experiment_id	int4	10
share_file	share_file_id	int4	10
share_lane	share_lane_id	int4	10
share_processing	share_processing_id	int4	10
share_sample	share_sample_id	int4	10
file	size	int8	19	√		null
file_provenance_report	skip	bool	1	√		null
sample	skip	bool	1	√		null
sequencer_run	slide_1_file_path	text	2147483647	√		null
sequencer_run	slide_1_lane_count	int4	10	√		null
sequencer_run	slide_2_file_path	text	2147483647	√		null
sequencer_run	slide_2_lane_count	int4	10	√		null
sequencer_run	slide_count	int4	10	√		null
experiment_library_design	source	int4	10	√		null
invoice	start_date	date	13
invoice	state	text	2147483647	√		null
experiment	status	text	2147483647	√		null
processing	status	text	2147483647	√		null
sample_report	status	varchar	255	√		null
sequencer_run	status	text	2147483647	√		null
study	status	text	2147483647	√		null
workflow_run	status	text	2147483647	√		null
workflow_run	status_cmd	text	2147483647	√		null
processing	stderr	text	2147483647	√		null
workflow_run	stderr	text	2147483647	√		null
processing	stdout	text	2147483647	√		null
workflow_run	stdout	text	2147483647	√		null
experiment_library_design	strategy	int4	10	√		null
file_provenance_report	study_attrs	text	2147483647	√		null
experiment	study_id	int4	10
file_report	study_id	int4	10	√		null
processing_studies	study_id	int4	10
sample_report	study_id	int4	10	√		null
share_study	study_id	int4	10
study_attribute	study_id	int4	10
study_link	study_id	int4	10
file_provenance_report	study_swa	int4	10	√		null
file_provenance_report	study_title	text	2147483647	√		null
lane	study_type	int4	10	√		null
expense_attribute	tag	text	2147483647	√		null
experiment_attribute	tag	text	2147483647	√		null
file_attribute	tag	varchar	255
invoice_attribute	tag	text	2147483647	√		null
ius	tag	text	2147483647	√		null
ius_attribute	tag	text	2147483647	√		null
lane_attribute	tag	text	2147483647	√		null
processing_attribute	tag	text	2147483647	√		null
sample_attribute	tag	text	2147483647
sample_search_attribute	tag	varchar	255
sequencer_run_attribute	tag	text	2147483647
study_attribute	tag	text	2147483647
workflow_attribute	tag	varchar	255
workflow_run_attribute	tag	varchar	255
experiment_spot_design	tag_spec	text	2147483647	√		null
lane	tags	text	2147483647	√		null
sample	tags	text	2147483647	√		null
sample	taxon_id	int4	10	√		null
experiment	title	text	2147483647	√		null
sample	title	text	2147483647	√		null
study	title	text	2147483647
expense	total_price	numeric	131089	√		null
expense	total_units	numeric	131089	√		null
file	type	text	2147483647	√		null
lane	type	int4	10	√		null
sample	type	text	2147483647	√		null
version	type	varchar	100	√		null
workflow_param	type	text	2147483647
workflow_run_param	type	text	2147483647	√		null
file_attribute	unit	varchar	255	√		null
workflow_attribute	unit	varchar	255	√		null
workflow_run_attribute	unit	varchar	255	√		null
expense_attribute	units	text	2147483647	√		null
experiment_attribute	units	text	2147483647	√		null
invoice_attribute	units	text	2147483647	√		null
ius_attribute	units	text	2147483647	√		null
lane_attribute	units	text	2147483647	√		null
processing_attribute	units	text	2147483647	√		null
sample_attribute	units	text	2147483647	√		null
sequencer_run_attribute	units	text	2147483647	√		null
study_attribute	units	text	2147483647	√		null
experiment	update_tstmp	timestamp	29,6	√		null
ius	update_tstmp	timestamp	29,6	√		null
lane	update_tstmp	timestamp	29,6	√		null
processing	update_tstmp	timestamp	29,6	√		null
sample	update_tstmp	timestamp	29,6	√		null
sequencer_run	update_tstmp	timestamp	29,6	√		null
share_experiment	update_tstmp	timestamp	29,6	√		null
share_file	update_tstmp	timestamp	29,6	√		null
share_lane	update_tstmp	timestamp	29,6	√		null
share_processing	update_tstmp	timestamp	29,6	√		null
share_sample	update_tstmp	timestamp	29,6	√		null
share_study	update_tstmp	timestamp	29,6	√		null
share_workflow_run	update_tstmp	timestamp	29,6	√		null
study	update_tstmp	timestamp	29,6	√		null
workflow	update_tstmp	timestamp	29,6	√		null
workflow_run	update_tstmp	timestamp	29,6	√		null
experiment_link	url	text	2147483647	√		null
file	url	text	2147483647	√		null
ius_link	url	text	2147483647
lane_link	url	text	2147483647
processing	url	text	2147483647	√		null
processing_experiments	url	text	2147483647	√		null
processing_ius	url	text	2147483647	√		null
processing_lanes	url	text	2147483647	√		null
processing_samples	url	text	2147483647	√		null
processing_sequencer_runs	url	text	2147483647	√		null
processing_studies	url	text	2147483647	√		null
sample_link	url	text	2147483647
study_link	url	text	2147483647
file	url_label	text	2147483647	√		null
processing	url_label	text	2147483647	√		null
sequencer_run	use_ipar_intensities	bool	1	√		null
workflow	username	text	2147483647	√		null
workflow_run	username	text	2147483647	√		null
expense_attribute	value	text	2147483647	√		null
experiment_attribute	value	text	2147483647	√		null
file_attribute	value	varchar	255
invoice_attribute	value	text	2147483647	√		null
ius_attribute	value	text	2147483647	√		null
lane_attribute	value	text	2147483647	√		null
processing_attribute	value	text	2147483647	√		null
sample_attribute	value	text	2147483647
sample_search_attribute	value	varchar	255
sequencer_run_attribute	value	text	2147483647
study_attribute	value	text	2147483647
workflow_attribute	value	varchar	255
workflow_param_value	value	text	2147483647	√		null
workflow_run_attribute	value	varchar	255
workflow_run_param	value	text	2147483647	√		null
processing	version	text	2147483647	√		null
workflow	version	text	2147483647	√		null
workflow	workflow_class	text	2147483647	√		null
workflow	workflow_engine	text	2147483647	√		null
workflow_run	workflow_engine	text	2147483647	√		null
sample_report	workflow_id	int4	10	√		null
workflow_attribute	workflow_id	int4	10
workflow_param	workflow_id	int4	10
workflow_run	workflow_id	int4	10
file_provenance_report	workflow_name	text	2147483647	√		null
workflow_param_value	workflow_param_id	int4	10
expense	workflow_run_id	int4	10	√		null
ius_workflow_runs	workflow_run_id	int4	10
lane_workflow_runs	workflow_run_id	int4	10
processing	workflow_run_id	int4	10	√		null
share_workflow_run	workflow_run_id	int4	10
workflow_run_attribute	workflow_run_id	int4	10
workflow_run_input_files	workflow_run_id	int4	10	√		null
workflow_run_param	workflow_run_id	int4	10
file_provenance_report	workflow_run_name	text	2147483647	√		null
file_provenance_report	workflow_run_status	text	2147483647	√		null
file_provenance_report	workflow_run_swa	int4	10	√		null
file_provenance_report	workflow_swa	int4	10	√		null
workflow	workflow_template	text	2147483647	√		null
workflow_run	workflow_template	text	2147483647	√		null
workflow	workflow_type	text	2147483647	√		null
file_provenance_report	workflow_version	text	2147483647	√		null
share_experiment	active	bool	1	√		true
share_file	active	bool	1	√		true
share_lane	active	bool	1	√		true
share_processing	active	bool	1	√		true
share_sample	active	bool	1	√		true
share_study	active	bool	1	√		true
share_workflow_run	active	bool	1	√		true