Current state of clean database REVIEW-1

roll commented 9 years ago

Background I was working on weekend (no chance to get a feedback) so our clean data model now is kinda unsynced with the ideal data model. But we can quickly to fix it. Also it's a very raw in terms of field types, constraints etc.

Clean SQL dump https://github.com/okfn/opentrials-cochrane-schizophrenia-data/blob/master/archive/clean/sql/database.sql

ER-diagrams

real clean database with data inside
first version of ideal database model

TODO

[x] change Review.central_id to integer type
[x] change central_date to date type
please add in comments

People

@pwalsh
@danfowler
@kravets-levko

roll commented 9 years ago

Please post any changes you want to apply. May be naming conventions, changing entity names etc.

roll commented 9 years ago

So we need to agree here to close #2

opentrials / cochrane-schizophrenia-data

Current state of clean database REVIEW-1 #20