View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0020676 | mantisbt | documentation | public | 2016-03-09 09:11 | 2016-03-09 10:59 |
Reporter | mikemol | Assigned To | |||
Priority | normal | Severity | minor | Reproducibility | have not tried |
Status | new | Resolution | open | ||
Summary | 0020676: MantisBT schema ERD missing a connection | ||||
Description | There is a user_id field in mantis_bug_file_table that should have a link to the mantis_user_table. I think it should be:
No idea if it should be an identifying relation or not; I don't know what that means or its purpose. | ||||
Additional Information | I was building an ERD in MySQL Workbench to help me chart queries for my own purposes, and needed to look up what a field was intended for. I prefer the "Connect to Columns" relationship notation, so I can see what actually binds two tables together in a diagram. When I discovered https://www.mantisbt.org/docs/master-1.2.x/en/developers/dev.database.html , I started using that to audit my own diagram, since the Mantis docs don't use a relationship notation that identifies what columns go to what. | ||||
Tags | No tags attached. | ||||
Another connection missing. mantis_bug_file_table (user_id) should reference mantis_user_table (id). Don't know what should be mandatory, and what shouldn't. |
|
Er. Nevermind. That's the same connection as I already mentioned. Just came across it from the other direction as I was continuing my work. |
|
OK, here's one that isn't a duplicate. mantis_project_file_table (user_id) should reference mantis_user_table (id). |
|
I probably just forgot to add them when I created the diagram. bug_file and project_file tables basically have the same behavior. It's a (1,1):(0,N) type relationship. Feel free to submit a pull request with an updated MWB. |
|