OpenHDS Data Model

Ime Asangansi

unread,

Dec 6, 2010, 1:33:11 PM12/6/10

to hmwa...@ihi.or.tz, akako...@ihi.or.tz, Brian Njamwea, Bruce MacLeod, OpenHDS Users

Hi Brian,

Thanks for this.

I have tried to document the latest (just did a dump this morning) database structure here:
http://openhds.rcg.usm.maine.edu/wiki/display/openhds/Data+Schema

It would a longer time to make the visual schema, so I just decided to create these html tables and pasted to the wiki.

Also find it attached here.

Thanks for asking and hope we get feedback and discussions following.

Cheers,
Ime

PS: Please note that while I had solved some of the issues raised at Niarobi, some are just being added to the issues tracker for resolution. So, don't be surprised to find them still there.

--- On Mon, 12/6/10, Brian Njamwea <bray...@gmail.com> wrote:

From: Brian Njamwea <bray...@gmail.com>
Subject: Database Model
To: "Ime Asangansi" <asan...@yahoo.com>, hmwa...@ihi.or.tz, akako...@ihi.or.tz
Date: Monday, December 6, 2010, 8:08 AM

Hi guys,

How is the team doing? Trust all is well. The team here is interested in reviewing the database model used. I wanted to use an updated database model.

Pls confirm we have the lateset model at the following link - http://openhds.rcg.usm.maine.edu/wiki/display/openhds/Data+Model

If it is not the latest DB model, pls send me the latest model or update the linked diagram.

Asante.

openhds_schema.htm

Brian Njamwea

unread,

Dec 6, 2010, 11:39:46 PM12/6/10

to Ime Asangansi, hmwa...@ihi.or.tz, akako...@ihi.or.tz, Bruce MacLeod, OpenHDS Users

Asante sana.

Francis(INDEPTH)

unread,

Dec 13, 2010, 10:29:23 AM12/13/10

to openhd...@googlegroups.com

Dear All,
I want to suggest this. Can we put the issues in categories and tackle them.
For example all interface issues can be addressed together as front end issue. All issues about data models is more of a back end issue so we can put all backend issues together and tackle them.
May be from what is going on so far let us start with back end issues.
If my categorization is too broad, we can have other smaller categorization if any.

Wish all Christians, Merry Xmas in advance
Francis

For a start let us look at all back end issues.

--
You received this message because you are subscribed to the Google Groups "openhds-users" group.
To post to this group, send email to openhd...@googlegroups.com.
To unsubscribe from this group, send email to openhds-user...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/openhds-users?hl=en.

-- 
===========================
Francis A. Ameni
ICT Officer
INDEPTH Network
11 Mensah wood street
East legon
P.O.Box KD213
Kanda, Accra
Tel. 233 21 519394
     233 21 521671
Fax:233 21 519395
Email:franci...@indepth-network.org
website: www.indepth-network.org

This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice of its status. Please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any other person: to do so could constitute a breach of confidence. Thank you for your cooperation.

David Roberge

unread,

Dec 14, 2010, 10:45:45 AM12/14/10

to openhd...@googlegroups.com

Hello All, my name is Dave and I'm one of the developers on the OpenHDS. I just wanted to say thank you for the feedback on the system; it is greatly appreciated.

I agree with Francis that having the issues categorized would be helpful. I will begin to set up the categories on the Redmine site.

I would like to add one thing about making changes to OpenHDS. I think before we make any changes, we should have an open discussion as to what problem the changes are addressing, and how they will improve the system. I believe collaboration on these issues will bring forward the best results.

Again, thank you everyone.

Dave

Peter WONTUO

unread,

Dec 15, 2010, 5:46:24 AM12/15/10

to openhd...@googlegroups.com

Dear All,

That is a good point Francis but that again could be subtitled as the issues may look broad and wide. In view of that, I wish to suggest for instance with regards to the front end issues, we look at each interface. For instance I would wish we do some re-arrangement as below. The flow from Baseline->Update->Amendments is very important.

OpenHDS Home Page:

HOME

BASELINE

UPDATE

AMENDMENTS

REPORTS

Utilities Routines

Developers

I hope this is not a very re-coding task.

Regards

Peter

David Roberge

unread,

Dec 15, 2010, 1:52:38 PM12/15/10

to openhd...@googlegroups.com

I completely agree with you on this one Peter. I will mark this down as an issue unless anyone else has further opinions on this? This will require very little coding to complete.