Koha E-R diagrams and tables information

It is not easy to understand the Koha 3.0 DB structure. In fact you need to read the Koha code to understand all tables .CILEA wants to improve the situation by writing more technical documentation about the Koha 3.0 DB

Starting from all documentation avaible from wiki and koha-dev list we start to write complete E-R diagrams for Koha DB and a specific document for every table We write:

1. a general description of the table,
2. a specific description of every field (name, lenght, type, data inserted, constrains)
3. a specific description of every index
4. a list of the foreign keys of the table

We drow also a general E-R schema of the DB The informatiom will be update to version 3.0 stable (3.00.00.107)

The person who will do the Job is Matteo Romanello <http://www.linkedin.com/pub/dir/matteo/romanello> with Zeno Tajoli as tutor

The work will start at 15 novembere 2008, it will probably finish at may 2009 The instrument used will be OpenOfficeOrg Calc.