Schema Version: 1.3 Module: chado

Columns

Columns

Table Type Column Type Size Nulls Default Comments
element_relationship Table type_id int8 19 null
biomaterial_dbxref Table dbxref_id int8 19 null
arraydesign Table manufacturer_id int8 19 null
quantificationprop Table rank int4 10 0
acquisitionprop Table acquisition_id int8 19 null
channel Table name text 2147483647 null
acquisition Table assay_id int8 19 null
control Table control_id bigserial 19 nextval('mage.control_control_id_seq'::regclass)
studydesign Table studydesign_id bigserial 19 nextval('mage.studydesign_studydesign_id_seq'::regclass)
studyprop_feature Table feature_id int8 19 null
arraydesign Table num_grid_columns int4 10 √ null
biomaterial_relationship Table type_id int8 19 null
studyprop Table type_id int8 19 null
control Table value text 2147483647 √ null
assayprop Table assay_id int8 19 null
biomaterial Table dbxref_id int8 19 √ null
elementresult_relationship Table rank int4 10 0
assayprop Table value text 2147483647 √ null
element_relationship Table object_id int8 19 null
arraydesign Table description text 2147483647 √ null
quantificationprop Table value text 2147483647 √ null
element Table feature_id int8 19 √ null
quantification Table protocol_id int8 19 √ null
biomaterial_dbxref Table biomaterial_id int8 19 null
arraydesign Table arraydesign_id bigserial 19 nextval('mage.arraydesign_arraydesign_id_seq'::regclass)
assay Table assaydate timestamp 29 √ now()
studyprop_feature Table studyprop_id int8 19 null
studyfactorvalue Table factorvalue text 2147483647 √ null
elementresult Table element_id int8 19 null
studyfactorvalue Table studyfactorvalue_id bigserial 19 nextval('mage.studyfactorvalue_studyfactorvalue_id_seq'::regclass)
study_assay Table assay_id int8 19 null
element Table arraydesign_id int8 19 null
studyfactorvalue Table studyfactor_id int8 19 null
quantification Table acquisition_id int8 19 null
protocolparam Table value text 2147483647 √ null
studyfactor Table description text 2147483647 √ null
control Table type_id int8 19 null
acquisition_relationship Table object_id int8 19 null
mageml Table mageml_id bigserial 19 nextval('mage.mageml_mageml_id_seq'::regclass)
quantification Table quantification_id bigserial 19 nextval('mage.quantification_quantification_id_seq'::regclass)
biomaterial Table description text 2147483647 √ null
acquisition Table name text 2147483647 √ null
protocolparam Table datatype_id int8 19 √ null
mageml Table mage_ml text 2147483647 null
element Table type_id int8 19 √ null
biomaterialprop Table biomaterial_id int8 19 null
quantification_relationship Table quantification_relationship_id bigserial 19 nextval('mage.quantification_relationship_quantification_relationship_id_seq'::regclass)
biomaterial_treatment Table biomaterial_id int8 19 null
acquisition Table acquisition_id bigserial 19 nextval('mage.acquisition_acquisition_id_seq'::regclass)
studyprop_feature Table studyprop_feature_id bigserial 19 nextval('mage.studyprop_feature_studyprop_feature_id_seq'::regclass)
arraydesignprop Table arraydesignprop_id bigserial 19 nextval('mage.arraydesignprop_arraydesignprop_id_seq'::regclass)
biomaterial Table taxon_id int8 19 √ null
treatment Table treatment_id bigserial 19 nextval('mage.treatment_treatment_id_seq'::regclass)
element_relationship Table rank int4 10 0
assay Table arrayidentifier text 2147483647 √ null
protocol Table protocoldescription text 2147483647 √ null
assay Table dbxref_id int8 19 √ null
studyfactor Table studydesign_id int8 19 null
arraydesign Table platformtype_id int8 19 null
acquisition Table protocol_id int8 19 √ null
assay Table protocol_id int8 19 √ null
assay Table operator_id int8 19 null
protocol Table softwaredescription text 2147483647 √ null
acquisition_relationship Table value text 2147483647 √ null
arraydesign Table num_sub_rows int4 10 √ null
studyprop Table study_id int8 19 null
arraydesign Table substratetype_id int8 19 √ null
biomaterial Table biosourceprovider_id int8 19 √ null
study_assay Table study_id int8 19 null
acquisition_relationship Table acquisition_relationship_id bigserial 19 nextval('mage.acquisition_relationship_acquisition_relationship_id_seq'::regclass)
protocol Table pub_id int8 19 √ null
arraydesign Table num_sub_columns int4 10 √ null
acquisitionprop Table type_id int8 19 null
quantificationprop Table quantificationprop_id bigserial 19 nextval('mage.quantificationprop_quantificationprop_id_seq'::regclass)
magedocumentation Table mageml_id int8 19 null
acquisition_relationship Table subject_id int8 19 null
biomaterial_treatment Table biomaterial_treatment_id bigserial 19 nextval('mage.biomaterial_treatment_biomaterial_treatment_id_seq'::regclass)
treatment Table type_id int8 19 null
magedocumentation Table magedocumentation_id bigserial 19 nextval('mage.magedocumentation_magedocumentation_id_seq'::regclass)
studyprop Table studyprop_id bigserial 19 nextval('mage.studyprop_studyprop_id_seq'::regclass)
biomaterial_relationship Table biomaterial_relationship_id bigserial 19 nextval('mage.biomaterial_relationship_biomaterial_relationship_id_seq'::regclass)
quantification Table name text 2147483647 √ null
arraydesignprop Table value text 2147483647 √ null
treatment Table name text 2147483647 √ null
acquisitionprop Table value text 2147483647 √ null
studyfactorvalue Table assay_id int8 19 null
studyfactorvalue Table rank int4 10 0
assay Table assay_id bigserial 19 nextval('mage.assay_assay_id_seq'::regclass)
quantification_relationship Table object_id int8 19 null
magedocumentation Table mageidentifier text 2147483647 null
protocol Table type_id int8 19 null
studyfactor Table studyfactor_id bigserial 19 nextval('mage.studyfactor_studyfactor_id_seq'::regclass)
elementresult Table signal float8 17 null
studyprop Table value text 2147483647 √ null
assay_biomaterial Table assay_id int8 19 null
studydesignprop Table studydesignprop_id bigserial 19 nextval('mage.studydesignprop_studydesignprop_id_seq'::regclass)
arraydesignprop Table rank int4 10 0
element_relationship Table subject_id int8 19 null
arraydesign Table num_array_rows int4 10 √ null
studydesign Table study_id int8 19 null
elementresult_relationship Table object_id int8 19 null
acquisition Table uri text 2147483647 √ null
studydesignprop Table rank int4 10 0
quantification_relationship Table subject_id int8 19 null
arraydesignprop Table arraydesign_id int8 19 null
treatment Table biomaterial_id int8 19 null
protocolparam Table protocol_id int8 19 null
arraydesignprop Table type_id int8 19 null
studydesignprop Table type_id int8 19 null
assay_project Table assay_id int8 19 null
quantification_relationship Table type_id int8 19 null
quantification Table quantificationdate timestamp 29 √ now()
arraydesign Table element_dimensions text 2147483647 √ null
biomaterial Table name text 2147483647 √ null
acquisition_relationship Table type_id int8 19 null
protocolparam Table protocolparam_id bigserial 19 nextval('mage.protocolparam_protocolparam_id_seq'::regclass)
study_assay Table study_assay_id bigserial 19 nextval('mage.study_assay_study_assay_id_seq'::regclass)
protocol Table hardwaredescription text 2147483647 √ null
assay_project Table project_id int8 19 null
treatment Table rank int4 10 0
biomaterial_dbxref Table biomaterial_dbxref_id bigserial 19 nextval('mage.biomaterial_dbxref_biomaterial_dbxref_id_seq'::regclass)
arraydesign Table array_dimensions text 2147483647 √ null
arraydesign Table protocol_id int8 19 √ null
studyprop_feature Table type_id int8 19 √ null
arraydesign Table num_of_elements int4 10 √ null
control Table row_id int4 10 null
mageml Table mage_package text 2147483647 null
assay_project Table assay_project_id bigserial 19 nextval('mage.assay_project_assay_project_id_seq'::regclass)
arraydesign Table num_grid_rows int4 10 √ null
elementresult Table quantification_id int8 19 null
assay_biomaterial Table rank int4 10 0
biomaterial Table biomaterial_id bigserial 19 nextval('mage.biomaterial_biomaterial_id_seq'::regclass)
assay_biomaterial Table biomaterial_id int8 19 null
assayprop Table rank int4 10 0
biomaterial_relationship Table object_id int8 19 null
elementresult_relationship Table value text 2147483647 √ null
quantification Table operator_id int8 19 √ null
protocolparam Table unittype_id int8 19 √ null
biomaterial_relationship Table subject_id int8 19 null
studyfactorvalue Table name text 2147483647 √ null
biomaterial_treatment Table treatment_id int8 19 null
studydesign Table description text 2147483647 √ null
quantification Table uri text 2147483647 √ null
quantification Table analysis_id int8 19 null
acquisition_relationship Table rank int4 10 0
study Table study_id bigserial 19 nextval('mage.study_study_id_seq'::regclass)
protocol Table uri text 2147483647 √ null
protocol Table protocol_id bigserial 19 nextval('mage.protocol_protocol_id_seq'::regclass)
studydesignprop Table value text 2147483647 √ null
arraydesign Table num_array_columns int4 10 √ null
assayprop Table type_id int8 19 null
studydesignprop Table studydesign_id int8 19 null
control Table rank int4 10 0
studyprop Table rank int4 10 0
biomaterial_treatment Table unittype_id int8 19 √ null
assay Table arraybatchidentifier text 2147483647 √ null
protocolparam Table name text 2147483647 null
control Table tableinfo_id int8 19 null
assay_biomaterial Table assay_biomaterial_id bigserial 19 nextval('mage.assay_biomaterial_assay_biomaterial_id_seq'::regclass)
acquisitionprop Table rank int4 10 0
biomaterial_treatment Table value float4 8 √ null
study Table contact_id int8 19 null
elementresult_relationship Table subject_id int8 19 null
channel Table channel_id bigserial 19 nextval('mage.channel_channel_id_seq'::regclass)
assay Table name text 2147483647 √ null
elementresult_relationship Table elementresult_relationship_id bigserial 19 nextval('mage.elementresult_relationship_elementresult_relationship_id_seq'::regclass)
assay Table description text 2147483647 √ null
arraydesign Table dbxref_id int8 19 √ null
elementresult Table elementresult_id bigserial 19 nextval('mage.elementresult_elementresult_id_seq'::regclass)
protocol Table name text 2147483647 null
channel Table definition text 2147483647 null
biomaterialprop Table type_id int8 19 null
arraydesign Table name text 2147483647 null
biomaterialprop Table value text 2147483647 √ null
arraydesign Table version text 2147483647 √ null
biomaterialprop Table rank int4 10 0
study Table name text 2147483647 null
magedocumentation Table tableinfo_id int8 19 null
quantificationprop Table quantification_id int8 19 null
protocol Table dbxref_id int8 19 √ null
biomaterial_treatment Table rank int4 10 0
assay_biomaterial Table channel_id int8 19 √ null
acquisition Table acquisitiondate timestamp 29 √ now()
elementresult_relationship Table type_id int8 19 null
quantificationprop Table type_id int8 19 null
study Table description text 2147483647 √ null
control Table name text 2147483647 √ null
treatment Table protocol_id int8 19 √ null
element_relationship Table value text 2147483647 √ null
studyfactor Table type_id int8 19 √ null
element_relationship Table element_relationship_id bigserial 19 nextval('mage.element_relationship_element_relationship_id_seq'::regclass)
element Table element_id bigserial 19 nextval('mage.element_element_id_seq'::regclass)
acquisition Table channel_id int8 19 √ null
acquisitionprop Table acquisitionprop_id bigserial 19 nextval('mage.acquisitionprop_acquisitionprop_id_seq'::regclass)
element Table dbxref_id int8 19 √ null
assay Table arraydesign_id int8 19 null
assayprop Table assayprop_id bigserial 19 nextval('mage.assayprop_assayprop_id_seq'::regclass)
study Table pub_id int8 19 √ null
control Table assay_id int8 19 null
protocolparam Table rank int4 10 0
magedocumentation Table row_id int4 10 null
study Table dbxref_id int8 19 √ null
biomaterialprop Table biomaterialprop_id bigserial 19 nextval('mage.biomaterialprop_biomaterialprop_id_seq'::regclass)
studyfactor Table name text 2147483647 null