wiki:DespoinaLog/2010/12/15

Version 13 (modified by antonak, 13 years ago) (diff)

--

import xls data (bbmri into gcc) :

problem with unrecognized duplicate entries.:

Biobank table

  • Missing from biobank (xls) (but doesn't seem a problem) :
    • publications_id (mref, required)
    • contacts_id (mref, required)

Existing in xls but not in the model

  • person_lastName (Is this the xref to Contact/person Entity)?
  • GWA data n =
  • GWA platform
  • GWA comments

Existing in model but not in the xls

  • ontologyreference_name xref
  • individuals_name mref
  • species_name xref
  • founderpanels_name
  • mref publications_id mref YES (required)
  • enum YES (required)
  • contacts_id mref YES(required)
  • lastupdate date

Person table

there is another entity - contact :

  • address
  • phone
  • email
  • fax
  • tollfreephone

person:

  • model :
    • address
    • phone
    • email
    • fax
    • tollfreephone
    • firstname
    • midinitials
    • lastname (required)
    • affiliation_name
    • roles_name
  • xls:
    • lastname

Ontologyterm

model :

  • id
  • name (required)
  • ontology_id
  • termaccession
  • definition
  • termpath

xls :

  • name

Institute

model :

  • address
  • phone
  • email
  • fax
  • tollfreephone
  • name (required)

xls * name

observablefeature

model

  • name (required) 
  • investigation_name
  • ontologyreference_name

xls  * name

observablefeature

model 

  • name (required)
  • investigation_name
  • ontologyreference_name

xls * name

observedvalue

model

  • investigation_name (required)
  • protocolapplication_name
  • feature_name  (required)
  • target_name (required)
  • ontologyreference_name
  • value
  • relation_name
  • time
  • endtime

xls * target_name 

  • feature_name
  • value
  • investigation_name

investigation

model 

  • name (required)
  • start
  • end
  • description
  • accession

xls * name

observationelement

model 

  • name (required)
  • investigation_name
  • ontologyreference_name

xls * name

  • investigation_name

Build index into gcc

Attachments (1)

Download all attachments as: .zip