Eventum MySQL Database Table Relation diagrams

[tugrulcan]

Hi,
Is there any wiki pages about table relations of default database scheme?

[glensc]

not that i know, but should be possible to create with mysql workbench. altho there are currently no external keys defined, so it would be just standalone tables...

[glensc]

but eventum table schema has following convention:

• each field in table is prefixed with three letter abbreviation of the table
• each external reference prefixes the external table abbreviation

so therefore:

• issue.iss_id - primary key
• issue_history.his_id - primary key
• issue_history.his_iss_id - relates to issue.iss_id

[tugrulcan]

Thanks for answer!

How can I retrieve the value for a customized field of an issue?
e.g. Lets say "Severity" is a customized field and can be set between 2 different values. Which tables and keys should I use for inner join to get Severity value of issue (ID=1)?