SchemaSpy Analysis of test_seqware_meta_db.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Mar 31 13:20 EDT 2014
Legend:
Primary key columns
Columns with indexes
 

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