Changes between Version 8 and Version 9 of DespoinaLog/2010/12/09


Ignore:
Timestamp:
2010-12-09T13:02:28+01:00 (14 years ago)
Author:
antonak
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DespoinaLog/2010/12/09

    v8 v9  
    1 
    21== Inconsistency with biobank table (pheno & gcc project) ==
    32== problem: ==
    … …  
    87 * create new table biobank from pheno project as follows:
    98
    10   mysql> create  table biobank_new select Acronym, Category, Type, Size, !LastUpdate     , Description, id from biobank ;
     9  mysql> create  table biobank_new select Acronym, Category, Type, Size, !LastUpdate      , Description, id from biobank ;
    1110
    1211  (only fields that exist in biobank in gcc project)
    … …  
    2928'''!ObservationElement''' ON (Biobank.id = !ObservationElement.id) LEFT JOIN
    3029
    31   '''  Investigation'''   AS xref_Investigation  ON xref_Investigation.id = !ObservationElement  .Investigation LEFT JOIN
     30  '''   Investigation'''    AS xref_Investigation  ON xref_Investigation.id = !ObservationElement   .Investigation LEFT JOIN
    3231
    3332'''!OntologyTerm''' AS xref_ontologyReference  ON xref_ontologyReference.id = !ObservationElement.ontologyReference LEFT JOIN
    … …  
    4039
    4140== Approach 3) Fix the xls data file according to the consistencies between these entities. ==
    42 xls colums : 
    43 
     41xls colums :
    4442
    4543{{{
    4644Name    Type    Acronym category_term   topics_term     institutes_name contacts_lastName       size    materials_term  GWA data n =    GWA platform    GWA comments    description
    4745}}}
     46