Feature Request
Added by Christopher Lilienthal almost 6 years ago
Hello,
I was inspecting the database to try and write a script to create a report with all the projects, the owners of those projects, the sessions associated with those projects and the user that collected each session. While I was looking at the relationships in the database I noticed a couple things and figured I'd mention them.
Would it be a good idea to make the SessionData name field a unique index so one could reliably lookup a session by the name and know that there could not be two with the same name?
I was also thinking that making the projects name field a unique index would also be beneficial.
Let me know if there is somewhere else I should make this suggestion.
Replies (1)
RE: Feature Request - Added by Anchi Cheng almost 6 years ago
If users are not changing the default name while setting up leginon or appion upload session, they are unique since I did have a check on existing name in providing the default. Enforcing it at the database schema will be a good idea, too, for query purpose. I will look into that, as well as for project name purpose.
Thanks.