FacilityCycle

[Steve Fisher]

Does anybody use FacilityCycle? I am trying to remove unwanted bits from the schema.

Steve

[tom.g...@stfc.ac.uk]

Hi Steve,

Yes, this is used quite a lot by ISIS as mirrors the way data used to be access (is stored on disk).

People’s habits are hard to change and they still like to browse data by cycle.

 

Best,
Tom

--
http://groups.google.com/group/icat-developers

--
Scanned by iCritical.

[Steve Fisher]

It is a problem because Investigations are currently identified by name, visitId, facilityCycle, instrument where both facilityCycle and instrument may be null. I need to get rid of constraints with nullable fields as database support is very poor.

I would like to change it to being identified just by facility and name. This also makes it clean for the icat data server. However as both diamond and isis use the combination of name and visitid to make it unique this is not practical. So instead I propose that Investigations have uniqueness constraints on facility, name, visitid

this implies that visitids must non-nullable

Steve

--
http://groups.google.com/group/icat-developers