wiki:DespoinaLog/2010/12/15

Version 12 (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 :

Build index into gcc

Attachments (1)

Download all attachments as: .zip