Hello, after several days of research, I still do not find full documentation on MySQL architecture BOINC.
I am currently in the process of creating a graphical user interface in order to view the mass of data stored.

I would like know if there is a detailed description of the different tables and columns, and their possible status code.

Thank you in advance, and if you need more information, I remain at your disposal.

Dorian

I don't know of any documentation, but the 'schema' files in http://boinc.berkeley.edu/gitweb/?p=boinc-v2.git;a=tree;f=db have the formal code needed to generate the tables and indexes.

Be aware that some fields have been recycled and are no longer used for the purposes their names suggest...

I don't know of any documentation, but the 'schema' files in http://boinc.berkeley.edu/gitweb/?p=boinc-v2.git;a=tree;f=db have the formal code needed to generate the tables and indexes.

Be aware that some fields have been recycled and are no longer used for the purposes their names suggest...

Thank you for your reply.
It looks like it lacks a bit of documentation on this subject, which could be very useful. (Description of columns, return codes...)

http://boinc.berkeley.edu/trac/wiki/DataBase

---

I asked David about this:

- The table definitions (SQL) are in boinc/db/schema.sql
http://boinc.berkeley.edu/gitweb/?p=boinc-v2.git;a=blob;f=db/schema.sql;h=cc4dbcb37b9f8df7484abf10aa0a5e7ff446efa4;hb=master

- The various fields are documented in the corresponding .h file,
boinc/db/boinc_db_types.h:
http://boinc.berkeley.edu/gitweb/?p=boinc-v2.git;a=blob;f=db/boinc_db_types.h;h=22ce07d2e1d1d746400b31705d42a413abf17ae2;hb=master
... and in lib/common_defs.h:
http://boinc.berkeley.edu/gitweb/?p=boinc-v2.git;a=blob;f=lib/common_defs.h;h=cd50472816d93ad307f410c449b31f8a1abe839c;hb=master

---

Thank you for your help!
These documents meet my needs.
If I have enough time to combine these documents, i will do it,it may help.