search

lukefitzwolfgang / icatproject

Automatically exported from code.google.com/p/icatproject
0 stars 0 forks source link

Inconsistent/confusing column names in the database #118

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
The USER and GROUP tables are joined on GROUP.USER_NAME = USER.ID
USER.ID is the primary key (autogenerated) of the USER table

This is confusing as USER has a different attribute called USER_NAME
USER.USER_NAME is the qualified logon name of the user

The attribute in GROUP should ideally be changed to USER_ID

Not really an API user issue, but could cause confusion in the codebase.

Original issue reported on code.google.com by tom.grif...@stfc.ac.uk on 18 Apr 2013 at 9:11

GoogleCodeExporter commented 9 years ago 
This is a relic from when the user and group tables did not have an ID. It is 
now fixed in the source code but not checked in.

Original comment by dr.s.m.f...@gmail.com on 29 Apr 2013 at 2:52

GoogleCodeExporter commented 9 years ago 
This will need to be included in the update script.

Original comment by dr.s.m.f...@gmail.com on 29 Apr 2013 at 3:03

GoogleCodeExporter commented 9 years ago

Original comment by dr.s.m.f...@gmail.com on 29 Apr 2013 at 3:04

GoogleCodeExporter commented 9 years ago

Original comment by dr.s.m.f...@gmail.com on 22 Aug 2013 at 1:45

GoogleCodeExporter commented 9 years ago 
The change for this is done now.

Original comment by dr.s.m.f...@gmail.com on 25 Oct 2013 at 10:07