opentrials / cochrane-schizophrenia-data

Cleaned data from the Cochrane schizophrenia database
5 stars 3 forks source link

Ideal data model missing: reviewer? #18

Open roll opened 9 years ago

roll commented 9 years ago

Background Related to #21 issue.

Topic Cochrane database has an entity Reviewer. Reviewer reviews Report (m2m relation). I guess Report is a Review (ResultsDoc) on our language. Example value:

35;"Dr";"Bernardo";"Garcia de Oliveira Soares";"";"BGOS";"";"Universidade Federal de Pelotas";"Evidence Based Medicine Center";"";"mslima@nutecnet.com.br";"";"Av. Duque de Caxias, 250";"";"Pelotas";"RS";"BRAZIL";"96100";"Rua Quinze de Novembro 1081";"";"Pelotas";"RS";"BRAZIL";"96015-000";"+55 532 221739";"+55 53 9810298";"";"";"";"";"+55 532 712645";"";"";"";"";FALSE;FALSE;"2001-02-13 00:00:00";"2003-03-06 00:00:00";"";"012"
danfowler commented 9 years ago

@roll A Review is a Systematic Review, a meta-analysis of a collection of "studies" in tblStudy. These are in tblReview not tblReport. Reviews can provide the "risk of bias" score mentioned in the trial page mock.