[ckan-dev] moderated edits c(r)ep. http://trac.ckan.org/ticket/1129

[David Raznick]

On Fri, May 13, 2011 at 4:50 PM, Seb Bacon <seb.bacon at okfn.org> wrote:

> Any chance of an entity diagram of some kind?  Even just a photo of a
> sketch on a bit of paper. I'm having trouble quickly digesting all of
> this.
>
> Thanks,
>
> Seb
>
>
Here is a quick attempt at doing this with inkscape.
http://imgur.com/a/iW4sF.  Click on the images to see them with a white
background!!

They give a schema example based on the many to many example in the thread.

The side with the semicircle is the many side.
A dotted line is not a real foreign key relationship but an implied one.


My new proposed model for revisionining is essentially the same as the
current one but with an expired_id (which is the revision_id of when that
object was not longer the active one).  This removes the need for a deleted
state.

The changeset one uses a json to represent a row in the database instead of
actually having a real database row.

This is kind of tangential to the issue at hand but should shed some light
on the discussion.

David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20110513/a8182b6f/attachment-0001.html>