SchemaSpy Analysis of transmart.i2b2demodata - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Jun 26 00:11 CEST 2019 |
| ||||||
|
transmart.i2b2demodata contains 448 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
visit_dimension | active_status_cd | varchar | 50 | √ | null | ||
patient_dimension | age_in_years_num | numeric | 38 | √ | null | ||
async_job | alt_viewer_url | varchar | 4000 | √ | null | ||
qt_query_master | api_version | text | 2147483647 | √ | null | ||
archive_observation_fact | archive_upload_id | numeric | 22 | √ | null | ||
supported_workflow | arvados_instance_url | varchar | 900 | √ | null | ||
supported_workflow | arvados_version | varchar | 50 | √ | null | ||
qt_query_instance | batch_mode | varchar | 50 | √ | null | ||
study | bio_experiment_id | int8 | 19 | √ | null | Foreign key: bio_experiment_id in bio_experiment. | |
sample_categories | biobank | varchar | 3 | √ | null | ||
relation | biological | bool | 1 | √ | null | Specifies whether relation biological. | |
relation_type | biological | bool | 1 | √ | null | Whether relation is biological. e.g. "parent of" is biological. "spouse of" is not. | |
patient_dimension | birth_date | timestamp | 29,6 | √ | null | ||
dimloader | c_basecode | varchar | 50 | √ | null | ||
crc_db_lookup | c_change_date | timestamp | 29,6 | √ | null | ||
dimloader | c_columndatatype | varchar | 50 | √ | null | ||
dimloader | c_columnname | varchar | 50 | √ | null | ||
crc_db_lookup | c_comment | text | 2147483647 | √ | null | ||
dimloader | 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 | ||
dimloader | c_dimcode | varchar | 900 | √ | null | ||
crc_db_lookup | c_domain_id | varchar | 255 | √ | null | ||
crc_db_lookup | c_entry_date | timestamp | 29,6 | √ | 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 | ||
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 | ||
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 | ||
jms_users | clientid | varchar | 128 | √ | null | ||
qt_analysis_plugin | command_line | text | 2147483647 | √ | null | ||
qt_analysis_plugin | commandoption_cd | text | 2147483647 | √ | null | ||
news_updates | commentfield | varchar | 200 | √ | null | ||
concept_dimension | concept_blob | text | 2147483647 | √ | null | ||
archive_observation_fact | concept_cd | varchar | 50 | √ | null | ||
cd | concept_path | varchar | 500 | √ | null | ||
concept_counts | concept_path | varchar | 500 | √ | null | The concept path to which patient count is bound. | |
archive_observation_fact | confidence_num | numeric | 18,5 | √ | null | ||
observation_fact | confidence_num | numeric | 18,5 | √ | null | ||
counter | counts | int8 | 19 | √ | null | ||
qt_analysis_plugin | create_date | timestamp | 29,6 | √ | null | ||
qt_breakdown_path | create_date | timestamp | 29,6 | √ | null | ||
set_type | create_date | timestamp | 29,6 | √ | null | ||
source_master | create_date | timestamp | 29,6 | √ | null | ||
sample_categories | data_types | varchar | 2000 | √ | null | ||
qt_privilege | dataprot_cd | varchar | 1000 | √ | null | ||
news_updates | datasetname | varchar | 200 | √ | null | ||
patient_dimension | death_date | timestamp | 29,6 | √ | null | ||
supported_workflow | default_params | text | 2147483647 | √ | null | ||
qt_query_master | delete_date | timestamp | 29,6 | √ | null | ||
qt_query_instance | delete_flag | varchar | 3 | √ | null | ||
qt_query_master | delete_flag | varchar | 3 | √ | null | ||
qt_query_result_instance | delete_flag | varchar | 3 | √ | null | ||
set_upload_status | deleted_record | numeric | 131089 | √ | null | ||
upload_status | deleted_record | numeric | 131089 | √ | null | ||
qt_analysis_plugin | description | varchar | 2000 | √ | null | ||
qt_query_result_instance | description | varchar | 200 | √ | null | ||
qt_query_result_type | description | varchar | 200 | √ | null | ||
qt_query_status_type | description | varchar | 200 | √ | null | ||
relation_type | description | text | 2147483647 | √ | null | Detailed description of the relation. | |
source_master | description | varchar | 300 | √ | null | ||
supported_workflow | description | varchar | 900 | √ | null | The workflow description. | |
sample_categories | disease | varchar | 2000 | √ | null | ||
qt_query_result_type | display_type_id | varchar | 500 | √ | null | ||
archive_observation_fact | download_date | timestamp | 29,6 | √ | null | ||
code_lookup | download_date | timestamp | 29,6 | √ | null | ||
concept_dimension | download_date | timestamp | 29,6 | √ | null | ||
dimloader | download_date | timestamp | 29,6 | √ | null | ||
encounter_mapping | download_date | timestamp | 29,6 | √ | null | ||
modifier_dimension | download_date | timestamp | 29,6 | √ | null | ||
modifier_dimension_view | download_date | timestamp | 29,6 | √ | null | ||
observation_fact | download_date | timestamp | 29,6 | √ | null | ||
patient_dimension | download_date | timestamp | 29,6 | √ | null | ||
patient_mapping | download_date | timestamp | 29,6 | √ | null | ||
provider_dimension | download_date | timestamp | 29,6 | √ | null | ||
visit_dimension | download_date | timestamp | 29,6 | √ | null | ||
encounter_mapping | encounter_ide_status | varchar | 50 | √ | null | ||
archive_observation_fact | encounter_num | numeric | 38 | √ | null | ||
qt_patient_enc_collection | encounter_num | numeric | 10 | √ | null | ||
archive_observation_fact | end_date | timestamp | 29,6 | √ | null | ||
observation_fact | end_date | timestamp | 29,6 | √ | null | The end date-time of the observation | |
qt_query_instance | end_date | timestamp | 29,6 | √ | null | ||
qt_query_result_instance | end_date | timestamp | 29,6 | √ | null | ||
set_upload_status | end_date | timestamp | 29,6 | √ | null | ||
upload_status | end_date | timestamp | 29,6 | √ | null | ||
visit_dimension | end_date | timestamp | 29,6 | √ | null | End date and time of the visit. | |
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 | ||
qt_query_master | generated_sql | text | 2147483647 | √ | null | ||
qt_analysis_plugin | group_id | varchar | 50 | √ | null | ||
qt_privilege | hivemgmt_cd | varchar | 1000 | √ | null | ||
qt_pdo_query_master | i2b2_request_xml | text | 2147483647 | √ | null | ||
qt_query_master | i2b2_request_xml | text | 2147483647 | √ | null | ||
archive_observation_fact | import_date | timestamp | 29,6 | √ | null | ||
code_lookup | import_date | timestamp | 29,6 | √ | null | ||
concept_dimension | import_date | timestamp | 29,6 | √ | null | ||
dimloader | import_date | timestamp | 29,6 | √ | null | ||
encounter_mapping | import_date | timestamp | 29,6 | √ | null | ||
modifier_dimension | import_date | timestamp | 29,6 | √ | null | ||
modifier_dimension_view | import_date | timestamp | 29,6 | √ | null | ||
observation_fact | import_date | timestamp | 29,6 | √ | null | ||
patient_dimension | import_date | timestamp | 29,6 | √ | null | ||
patient_mapping | import_date | timestamp | 29,6 | √ | null | ||
provider_dimension | import_date | timestamp | 29,6 | √ | null | ||
visit_dimension | import_date | timestamp | 29,6 | √ | null | ||
patient_dimension | income_cd | varchar | 50 | √ | null | ||
timers | info | text | 2147483647 | √ | null | ||
visit_dimension | inout_cd | varchar | 50 | √ | null | ||
set_upload_status | input_file_name | text | 2147483647 | √ | null | ||
upload_status | input_file_name | text | 2147483647 | √ | null | ||
archive_observation_fact | instance_num | numeric | 18 | √ | null | ||
timers | instancepk | text | 2147483647 | √ | null | ||
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 | ||
patient_dimension | language_cd | varchar | 50 | √ | null | ||
async_job | last_run_on | timestamp | 29,6 | √ | null | The start time of the job. | |
visit_dimension | length_of_stay | numeric | 38 | √ | null | ||
set_upload_status | load_status | varchar | 100 | √ | null | ||
upload_status | load_status | varchar | 100 | √ | null | ||
set_upload_status | loaded_record | numeric | 131089 | √ | null | ||
upload_status | loaded_record | numeric | 131089 | √ | null | ||
archive_observation_fact | location_cd | varchar | 50 | √ | null | ||
observation_fact | location_cd | varchar | 50 | √ | null | ||
visit_dimension | location_cd | varchar | 50 | √ | null | ||
visit_dimension | location_path | varchar | 900 | √ | null | ||
set_upload_status | log_file_name | text | 2147483647 | √ | null | ||
upload_status | log_file_name | text | 2147483647 | √ | null | ||
code_lookup | lookup_blob | text | 2147483647 | √ | null | ||
patient_dimension | marital_status_cd | varchar | 50 | √ | null | ||
qt_query_master | master_type_cd | varchar | 2000 | √ | null | ||
qt_query_instance | message | text | 2147483647 | √ | null | ||
qt_query_result_instance | message | text | 2147483647 | √ | null | ||
set_upload_status | message | text | 2147483647 | √ | null | ||
upload_status | message | text | 2147483647 | √ | null | ||
jms_messages | messageblob | text | 2147483647 | √ | null | ||
modifier_dimension | modifier_blob | text | 2147483647 | √ | null | ||
modifier_dimension_view | modifier_blob | text | 2147483647 | √ | null | ||
archive_observation_fact | modifier_cd | varchar | 100 | √ | 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_view | modifier_cd | varchar | 50 | √ | null | ||
modifier_metadata | modifier_cd | varchar | 50 | √ | null | ||
modifier_dimension | modifier_level | int8 | 19 | √ | null | ||
modifier_dimension_view | modifier_level | int8 | 19 | √ | null | ||
modifier_dimension | modifier_node_type | varchar | 10 | √ | null | ||
modifier_dimension_view | modifier_node_type | varchar | 10 | √ | null | ||
modifier_dimension_view | modifier_path | varchar | 700 | √ | null | ||
linked_file_collection | name | varchar | 900 | √ | null | Name of the collection. | |
qt_breakdown_path | name | varchar | 100 | √ | null | ||
qt_query_result_type | name | varchar | 100 | √ | null | ||
qt_query_status_type | name | varchar | 100 | √ | null | ||
set_type | name | varchar | 500 | √ | null | ||
storage_system | name | varchar | 50 | √ | null | Name of the system. | |
supported_workflow | name | varchar | 500 | √ | null | The workflow name. | |
code_lookup | name_char | varchar | 650 | √ | null | ||
concept_dimension | name_char | varchar | 2000 | √ | null | REQUIRED. The name of the concept. | |
modifier_dimension | name_char | varchar | 2000 | √ | null | The name of the modifier. | |
modifier_dimension_view | name_char | varchar | 2000 | √ | null | ||
provider_dimension | name_char | varchar | 850 | √ | null | The name of the provider. | |
news_updates | newsid | int4 | 10 | √ | null | ||
set_upload_status | no_of_record | numeric | 131089 | √ | null | ||
upload_status | no_of_record | numeric | 131089 | √ | null | ||
archive_observation_fact | nval_num | numeric | 18,5 | √ | null | ||
observation_fact | nval_num | numeric | 29,16 | √ | null | Used in conjunction with valtype_cd = N to store a numerical value | |
qt_query_result_instance | obfusc_method | varchar | 500 | √ | null | ||
archive_observation_fact | observation_blob | text | 2147483647 | √ | null | ||
observation_fact | observation_blob | text | 2147483647 | √ | null | ||
news_updates | operation | varchar | 200 | √ | null | ||
qt_analysis_plugin | parameter_info | text | 2147483647 | √ | null | ||
qt_analysis_plugin | parameter_info_xsd | text | 2147483647 | √ | null | ||
cd | parent_concept_path | varchar | 500 | √ | null | ||
concept_counts | parent_concept_path | varchar | 500 | √ | null | The concept path of the parent. | |
patient_dimension | patient_blob | text | 2147483647 | √ | null | ||
cd | patient_count | int8 | 19 | √ | null | ||
concept_counts | patient_count | int8 | 19 | √ | null | The number of patients for which there are observations for the concept. | |
qt_patient_sample_collection | patient_id | int8 | 19 | √ | null | ||
encounter_mapping | patient_ide | varchar | 200 | √ | null | ||
encounter_mapping | patient_ide_source | varchar | 50 | √ | null | ||
patient_mapping | patient_ide_status | varchar | 50 | √ | null | ||
archive_observation_fact | patient_num | numeric | 38 | √ | null | ||
patient_trial | patient_num | numeric | 131089 | √ | null | Id that links to the patient_num of the patient_dimension table. | |
qt_patient_enc_collection | patient_num | numeric | 10 | √ | null | ||
qt_patient_set_collection | patient_num | numeric | 10 | √ | null | ||
qt_analysis_plugin | plugin_icon | text | 2147483647 | √ | null | ||
qt_privilege | plugin_id | numeric | 10 | √ | null | ||
qt_query_master | plugin_id | numeric | 10 | √ | null | ||
qt_analysis_plugin | plugin_name | varchar | 2000 | √ | null | ||
qt_privilege | protection_label_cd | varchar | 1500 | √ | null | ||
provider_dimension | provider_blob | text | 2147483647 | √ | null | ||
archive_observation_fact | provider_id | varchar | 50 | √ | null | ||
archive_observation_fact | quantity_num | numeric | 18,5 | √ | null | ||
observation_fact | quantity_num | numeric | 18,5 | √ | null | ||
qt_query_result_instance | query_instance_id | numeric | 5 | √ | null | ||
qt_query_instance | query_master_id | numeric | 5 | √ | null | ||
patient_dimension | race_cd | varchar | 50 | √ | null | ||
news_updates | ranbyuser | varchar | 200 | √ | null | ||
qt_query_result_instance | real_set_size | numeric | 10 | √ | 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. | |
patient_dimension | religion_cd | varchar | 50 | √ | null | ||
datamart_report | report_date | timestamp | 29,6 | √ | null | ||
qt_query_master | request_constraints | text | 2147483647 | √ | null | ||
qt_pdo_query_master | request_xml | text | 2147483647 | √ | null | ||
qt_query_master | request_xml | text | 2147483647 | √ | null | ||
qt_patient_enc_collection | result_instance_id | numeric | 5 | √ | null | ||
qt_patient_sample_collection | result_instance_id | int8 | 19 | √ | null | ||
qt_patient_set_collection | result_instance_id | numeric | 5 | √ | null | ||
qt_xml_result | result_instance_id | numeric | 5 | √ | null | ||
news_updates | rowsaffected | int4 | 10 | √ | null | ||
async_job | run_time | varchar | 200 | √ | null | ||
observation_fact | sample_cd | varchar | 200 | √ | null | Deprecated. Refers to the sample_dimension table. | |
sample_categories | sample_cd | varchar | 200 | √ | null | ||
qt_patient_sample_collection | sample_id | int8 | 19 | √ | null | ||
sample_categories | sample_id | varchar | 250 | √ | null | ||
sample_categories | sample_treatment | varchar | 2000 | √ | null | ||
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. | |
jms_subscriptions | selector | varchar | 255 | √ | null | ||
qt_patient_enc_collection | set_index | numeric | 10 | √ | null | ||
qt_patient_set_collection | set_index | numeric | 10 | √ | null | ||
qt_query_result_instance | set_size | numeric | 10 | √ | null | ||
patient_dimension | sex_cd | varchar | 50 | √ | null | One of [Male, Female, Unknown]. | |
relation | share_household | bool | 1 | √ | null | Specifies whether subjects share household. | |
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) | |
map | smaple_id | varchar | 100 | √ | null | ||
sample_categories | source_organism | varchar | 255 | √ | null | ||
archive_observation_fact | sourcesystem_cd | varchar | 50 | √ | null | ||
code_lookup | sourcesystem_cd | varchar | 50 | √ | null | ||
concept_dimension | sourcesystem_cd | varchar | 50 | √ | null | ||
dimloader | sourcesystem_cd | varchar | 50 | √ | null | ||
encounter_mapping | sourcesystem_cd | varchar | 50 | √ | null | ||
modifier_dimension | sourcesystem_cd | varchar | 50 | √ | null | ||
modifier_dimension_view | sourcesystem_cd | varchar | 50 | √ | null | ||
observation_fact | sourcesystem_cd | varchar | 50 | √ | null | Deprecated. Is currently being ignored. | |
patient_dimension | sourcesystem_cd | varchar | 107 | √ | null | ||
patient_mapping | sourcesystem_cd | varchar | 50 | √ | null | ||
provider_dimension | sourcesystem_cd | varchar | 50 | √ | null | ||
visit_dimension | sourcesystem_cd | varchar | 50 | √ | null | ||
archive_observation_fact | start_date | timestamp | 29,6 | √ | null | ||
visit_dimension | start_date | timestamp | 29,6 | √ | null | Start date and time of the visit. | |
patient_dimension | statecityzip_path | varchar | 700 | √ | null | ||
qt_analysis_plugin | status_cd | varchar | 50 | √ | null | ||
qt_query_instance | status_type_id | numeric | 5 | √ | null | ||
modifier_dimension_view | std_units | varchar | 50 | √ | null | ||
modifier_metadata | std_units | varchar | 50 | √ | null | ||
study | study_blob | text | 2147483647 | √ | null | Stores arbitrary information about the study | |
map | subject_id | varchar | 100 | √ | null | ||
sample_categories | subject_treatment | varchar | 2000 | √ | null | ||
relation_type | symmetrical | bool | 1 | √ | null | Whether relation is symmetrical. e.g. "sibling of" is symmetrical. "parent of" is not. | |
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. | |
concept_dimension | table_name | varchar | 255 | √ | null | ||
sample_categories | timepoint | varchar | 250 | √ | null | ||
timers | timerinterval | int8 | 19 | √ | null | ||
sample_categories | tissue_state | varchar | 2000 | √ | null | ||
sample_categories | tissue_type | varchar | 2000 | √ | null | ||
datamart_report | total_event | numeric | 38 | √ | null | ||
datamart_report | total_observationfact | numeric | 38 | √ | null | ||
datamart_report | total_patient | numeric | 38 | √ | null | ||
set_upload_status | transform_name | varchar | 500 | √ | null | ||
upload_status | transform_name | varchar | 500 | √ | null | ||
sample_categories | treatment | varchar | 255 | √ | null | ||
patient_trial | trial | varchar | 30 | √ | null | Name of the trial. | |
sample_categories | trial_cd | varchar | 200 | √ | null | ||
sample_categories | trial_name | varchar | 100 | √ | null | ||
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. | |
archive_observation_fact | tval_char | varchar | 255 | √ | null | ||
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] | |
jms_messages | txid | int8 | 19 | √ | null | ||
jms_transactions | txid | int8 | 19 | √ | null | ||
jms_messages | txop | bpchar | 1 | √ | null | ||
archive_observation_fact | units_cd | varchar | 50 | √ | null | ||
observation_fact | units_cd | varchar | 50 | √ | null | ||
archive_observation_fact | update_date | timestamp | 29,6 | √ | null | ||
code_lookup | update_date | timestamp | 29,6 | √ | null | ||
concept_dimension | update_date | timestamp | 29,6 | √ | null | ||
dimloader | update_date | timestamp | 29,6 | √ | null | ||
encounter_mapping | update_date | timestamp | 29,6 | √ | null | ||
modifier_dimension | update_date | timestamp | 29,6 | √ | null | ||
modifier_dimension_view | update_date | timestamp | 29,6 | √ | null | ||
observation_fact | update_date | timestamp | 29,6 | √ | null | ||
patient_dimension | update_date | timestamp | 29,6 | √ | null | ||
patient_mapping | update_date | timestamp | 29,6 | √ | null | ||
provider_dimension | update_date | timestamp | 29,6 | √ | null | ||
qt_analysis_plugin | update_date | timestamp | 29,6 | √ | null | ||
qt_breakdown_path | update_date | timestamp | 29,6 | √ | null | ||
visit_dimension | update_date | timestamp | 29,6 | √ | null | ||
news_updates | updatedate | timestamp | 29,6 | √ | null | ||
code_lookup | upload_date | timestamp | 29,6 | √ | null | ||
encounter_mapping | upload_date | timestamp | 29,6 | √ | null | ||
patient_mapping | upload_date | timestamp | 29,6 | √ | null | ||
archive_observation_fact | upload_id | numeric | 38 | √ | null | ||
code_lookup | upload_id | numeric | 38 | √ | null | ||
concept_dimension | upload_id | int8 | 19 | √ | null | ||
encounter_mapping | upload_id | numeric | 38 | √ | null | ||
modifier_dimension | upload_id | int8 | 19 | √ | null | ||
modifier_dimension_view | upload_id | int8 | 19 | √ | null | ||
observation_fact | upload_id | numeric | 38 | √ | null | ||
patient_dimension | upload_id | numeric | 38 | √ | null | ||
patient_mapping | upload_id | numeric | 38 | √ | null | ||
provider_dimension | upload_id | numeric | 38 | √ | null | ||
visit_dimension | upload_id | numeric | 38 | √ | null | ||
storage_system | url | varchar | 900 | √ | null | URL of the instance. | |
async_job | user_id | varchar | 50 | √ | null | Name of the user. | |
qt_analysis_plugin | user_id | varchar | 50 | √ | null | ||
qt_breakdown_path | user_id | varchar | 50 | √ | null | ||
linked_file_collection | uuid | varchar | 50 | √ | null | ||
archive_observation_fact | valtype_cd | varchar | 50 | √ | null | ||
modifier_dimension_view | valtype_cd | varchar | 10 | √ | null | ||
modifier_metadata | valtype_cd | varchar | 10 | √ | null | ||
observation_fact | valtype_cd | varchar | 50 | √ | null | T for string, N for numeric, B for raw text and D for date values. | |
qt_breakdown_path | value | varchar | 2000 | √ | null | ||
archive_observation_fact | valueflag_cd | varchar | 50 | √ | null | ||
observation_fact | valueflag_cd | varchar | 50 | √ | null | ||
dimloader | valuetype_cd | varchar | 50 | √ | null | ||
qt_analysis_plugin | version_cd | varchar | 50 | √ | null | ||
async_job | viewer_url | varchar | 4000 | √ | null | ||
visit_dimension | visit_blob | text | 2147483647 | √ | null | ||
modifier_dimension_view | visit_ind | bpchar | 1 | √ | null | ||
modifier_metadata | visit_ind | bpchar | 1 | √ | null | ||
qt_query_result_type | visual_attribute_type_id | varchar | 3 | √ | null | ||
patient_dimension | vital_status_cd | varchar | 50 | √ | null | ||
qt_analysis_plugin | working_folder | text | 2147483647 | √ | null | ||
qt_xml_result | xml_value | varchar | 4000 | √ | null | ||
patient_dimension | zip_cd | varchar | 50 | √ | null | ||
jms_subscriptions | clientid | varchar | 128 | ||||
code_lookup | code_cd | varchar | 50 | ||||
code_lookup | column_cd | varchar | 100 | ||||
concept_dimension | concept_cd | varchar | 50 | REQUIRED. The code that is used to refer to the concept from observation_fact. | |||
counter | concept_cd | varchar | 50 | ||||
observation_fact | concept_cd | varchar | 50 | Primary key. Refers to concept_cd in concept_dimension. | |||
ricerca | concept_cd | varchar | 50 | ||||
concept_dimension | concept_path | varchar | 700 | Primary key. The path that uniquely identifies a concept. | |||
ricerca | concept_path | varchar | 700 | ||||
qt_pdo_query_master | create_date | timestamp | 29,6 | ||||
qt_query_master | create_date | timestamp | 29,6 | ||||
jms_messages | destination | varchar | 255 | ||||
encounter_mapping | encounter_ide | varchar | 200 | ||||
encounter_mapping | encounter_ide_source | varchar | 50 | ||||
encounter_mapping | encounter_num | int4 | 10 | ||||
observation_fact | encounter_num | int4 | 10 | Primary key. Refers to encounter_num in visit_dimension. | |||
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. | |
qt_pdo_query_master | group_id | varchar | 50 | ||||
qt_query_instance | group_id | varchar | 50 | ||||
qt_query_master | group_id | varchar | 50 | ||||
hilosequences | highvalues | int8 | 19 | ||||
async_job | id | int4 | 10 | ||||
linked_file_collection | id | int4 | 10 | ||||
relation_type | id | serial | 10 | √ | nextval('i2b2demodata.relation_type_id_seq'::regclass) | ||
set_type | id | serial | 10 | √ | nextval('i2b2demodata.sq_up_patdim_patientnum'::regclass) | ||
storage_system | id | int4 | 10 | ||||
supported_workflow | id | int4 | 10 | ||||
timers | initialdate | timestamp | 29,6 | ||||
observation_fact | instance_num | numeric | 18 | Primary key. Default: 1. | |||
relation_type | label | varchar | 200 | Short unique name of the relation. | |||
relation | left_subject_id | numeric | 38 | Id of the left subject in the relation. | |||
set_upload_status | load_date | timestamp | 29,6 | ||||
upload_status | load_date | timestamp | 29,6 | ||||
jms_messages | messageid | int8 | 19 | ||||
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]. | |||
modifier_dimension | modifier_path | varchar | 700 | Primary key. The path that uniquely identifies a modifier. | |||
qt_query_master | name | varchar | 250 | ||||
jms_users | passwd | varchar | 32 | ||||
qt_patient_enc_collection | patient_enc_coll_id | numeric | 10 | √ | nextval('i2b2demodata.qt_sq_qper_pecid'::regclass) | ||
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. | |||
observation_fact | patient_num | numeric | 38 | Primary key. Refers to patient_num in patient_dimension. | |||
patient_dimension | patient_num | numeric | 38 | Primary key. Id of the patient. | |||
patient_mapping | patient_num | numeric | 38 | The id of the patient in TranSMART. Refers to patient_num in patient_dimension. | |||
visit_dimension | patient_num | numeric | 38 | Foreign key. Id linking to patient_num in the patient_dimension. | |||
qt_patient_set_collection | patient_set_coll_id | numeric | 10 | √ | nextval('i2b2demodata.qt_sq_qpr_pcid'::regclass) | ||
qt_analysis_plugin | plugin_id | numeric | 10 | ||||
qt_analysis_plugin_result_type | plugin_id | numeric | 10 | ||||
observation_fact | provider_id | varchar | 50 | Primary key. Refers to provider_id in provider_dimension. | |||
provider_dimension | provider_id | varchar | 50 | Primary key. | |||
provider_dimension | provider_path | varchar | 700 | Primary key. A path that identifies a provider. | |||
qt_query_instance | query_instance_id | numeric | 5 | √ | nextval('i2b2demodata.qt_sq_qi_qiid'::regclass) | ||
qt_pdo_query_master | query_master_id | numeric | 5 | √ | nextval('i2b2demodata.qt_sq_pqm_qmid'::regclass) | ||
qt_query_master | query_master_id | numeric | 5 | √ | nextval('i2b2demodata.qt_sq_qm_qmid'::regclass) | ||
relation | relation_type_id | int4 | 10 | Relation type id. | |||
qt_query_result_instance | result_instance_id | numeric | 5 | √ | nextval('i2b2demodata.qt_sq_qri_qriid'::regclass) | ||
qt_analysis_plugin_result_type | result_type_id | numeric | 10 | ||||
qt_query_result_instance | result_type_id | numeric | 3 | ||||
qt_query_result_type | result_type_id | numeric | 3 | √ | nextval('i2b2demodata.qt_sq_qr_qrid'::regclass) | ||
relation | right_subject_id | numeric | 38 | Id of the right subject in the relation. | |||
jms_roles | roleid | varchar | 32 | ||||
sample_dimension | sample_cd | varchar | 200 | ||||
study | secure_obj_token | varchar | 200 | Token needed for access to the study. E.g., ?PUBLIC? or ?EXP:GSE8581?. | |||
hilosequences | sequencename | varchar | 50 | ||||
set_upload_status | set_type_id | int4 | 10 | ||||
set_upload_status | source_cd | varchar | 50 | ||||
source_master | source_cd | varchar | 50 | ||||
upload_status | source_cd | varchar | 50 | ||||
linked_file_collection | source_system_id | int4 | 10 | The universally unique identifier on the storage system. | |||
observation_fact | start_date | timestamp | 29,6 | Primary key. Starting date-time of the observation. Default: 0001-01-01 00:00:00. | |||
qt_query_instance | start_date | timestamp | 29,6 | ||||
qt_query_result_instance | start_date | timestamp | 29,6 | ||||
qt_query_result_instance | status_type_id | numeric | 3 | ||||
qt_query_status_type | status_type_id | numeric | 3 | √ | nextval('i2b2demodata.qt_sq_qs_qsid'::regclass) | ||
linked_file_collection | study_id | int4 | 10 | Points to the study the file associated with. | |||
study | study_id | varchar | 100 | Unique study name. E.g., GSE8581. | |||
study | study_num | numeric | 38 | √ | nextval('i2b2demodata.study_num_seq'::regclass) | Primary key. | |
trial_visit_dimension | study_num | numeric | 38 | Foreign key to study_num in study. | |||
jms_subscriptions | subname | varchar | 128 | ||||
code_lookup | table_cd | varchar | 100 | ||||
timers | targetid | varchar | 250 | ||||
timers | timerid | varchar | 80 | ||||
jms_subscriptions | topic | varchar | 255 | ||||
trial_visit_dimension | trial_visit_num | numeric | 38 | √ | nextval('i2b2demodata.trial_visit_num_seq'::regclass) | Primary key. | |
set_upload_status | upload_id | numeric | 131089 | ||||
upload_status | upload_id | numeric | 38 | √ | nextval('i2b2demodata.sq_uploadstatus_uploadid'::regclass) | ||
upload_status | upload_label | varchar | 500 | ||||
qt_pdo_query_master | user_id | varchar | 50 | ||||
qt_query_instance | user_id | varchar | 50 | ||||
qt_query_master | user_id | varchar | 50 | ||||
upload_status | user_id | varchar | 100 | ||||
jms_roles | userid | varchar | 32 | ||||
jms_users | userid | varchar | 32 | ||||
supported_workflow | uuid | varchar | 50 | The universally unique identifier of the workflow. | |||
qt_xml_result | xml_result_id | numeric | 5 | √ | nextval('i2b2demodata.qt_sq_qxr_xrid'::regclass) |