View Issue Details

IDProjectCategoryView StatusLast Update
0021799mantisbtdocumentationpublic2019-12-09 04:32
Reporteratrol Assigned Todregad  
Status closedResolutionfixed 
Target Version2.23.0Fixed in Version2.23.0 
Summary0021799: Wrong data types in ERD

Some data types are wrong in ERD

At first sight it seems that all I2 (SMALLINT on MySQL) columns (mainly used for all kind of enumerations) are wrong. They are documented as VARCHAR(32)

E.g. check columns priority, severity, ... in mantis_bug_table

TagsNo tags attached.




2019-08-30 11:37

developer   ~0062695

It took me more time than I expected to go over and fix the various discrepancies I found, but hopefully now the diagram matches the schema as generated by current Git HEAD.

Related Changesets

MantisBT: master 80b88ea2

2019-08-30 07:35


Details Diff
Fix incorrect column data types in ERD

The reference database that was used to build the original diagram
(MySQL Workbench reverse engineering feature) was not a fresh install.
As a result, there were discrepancies in some data types (e.g. columns
linked to enums were VARCHAR instead of SMALLINT).

Fixes 0021799

Also added missing relationship between _bugnote_ and _bug_file_ tables
(Issue 0026098).
Affected Issues
0021799, 0026098
mod - docbook/Developers_Guide/en-US/images/erd.png Diff File
mod - docbook/erd/mantisbt.mwb Diff File
add - docbook/erd/mantisbt_2.23.0_210_erd_r2.pdf Diff File