Koha E-R diagrams and tables information RFC

From Koha Test Wiki MediaWiki MySQL Binary

= This work has been done and is available from http://wiki.koha-community.org/wiki/DB_Schema

Koha E-R diagrams and tables information

Status

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

Actions

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:

• a general description of the table,
• a specific description of every field (name, lenght, type, data inserted, constrains)
• a specific description of every index
• 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)

Persons

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

Timetable and Tools

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