View Issue Details

IDProjectCategoryView StatusLast Update
0020676mantisbtdocumentationpublic2016-03-09 10:59
Reportermikemol Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status newResolutionopen 
Summary0020676: 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:

  • Mandatory on mantis_bug_file_table
  • Not mandatory on mantis_user_table

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.

TagsNo tags attached.

Activities

mikemol

mikemol

2016-03-09 09:29

reporter   ~0052702

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.

mikemol

mikemol

2016-03-09 09:30

reporter   ~0052703

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.

mikemol

mikemol

2016-03-09 09:31

reporter   ~0052704

OK, here's one that isn't a duplicate.

mantis_project_file_table (user_id) should reference mantis_user_table (id).

dregad

dregad

2016-03-09 10:59

developer   ~0052709

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.