Forums / General / Datamodel documentation

Datamodel documentation

Author Message

Luc Chase

Wednesday 28 March 2007 8:49:16 am

Just downloaded 3.9.1 and was looking for a .png image of the whole db schema. Only found multi-language-datamodel.png which only details ten tables. Where can I find the db schema of the entire ezp db schema?

The Web Application Service Provider

Kristof Coomans

Wednesday 28 March 2007 10:35:54 am

Hi Luc

I'm not sure it's a complete, but here's one: http://ez.no/community/forum/general/ez_publish_datamodel

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Luc Chase

Thursday 29 March 2007 8:23:33 am

Kristof,
thanks but that does not seem to show any relationships, at least not on my screen -- just a large group of tables.

The Web Application Service Provider

Kristof Coomans

Thursday 29 March 2007 11:42:00 pm

Idd. I think this model was auto-generated from the database, but there are no foreign keys defined in there (because this isn't supported by all eZ-supported DBMS).

There's another one out there, it's older but it shows relations: http://ez.no/ezpublish/documentation/reference/database_diagram

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Luc Chase

Friday 30 March 2007 2:38:57 am

Thing is, I'm quite sure that in earlier versions of EZP a full schema diagram was always included, but now it seems that only the arear relating to the new multi-lingual features are present.

The Web Application Service Provider