search

ispyb / ispyb-database-modeling

4 stars 3 forks source link

New table BeamCalendar #31

Closed KarlLevik closed 5 years ago

KarlLevik commented 6 years ago

We would like to have a table for the "beam calendar":

CREATE TABLE BeamCalendar (
    beamCalendarId int(10) unsigned auto_increment,
    run varchar(7) NOT NULL COMMENT 'e.g. "2016-04", same as the run column in v_run',
    beamStatus varchar(24) NOT NULL COMMENT 'e.g. "User Mode", "UM Special Beam", "Start up/Machine dev", "Shutdown", ...',
    startDate datetime NOT NULL,
    endDate dateTime NOT NULL,
    PRIMARY KEY (beamCalendarId)
);

I realize this probably isn't needed at synchrotrons that integrate the ISPyB web application with SMIS or similar, but we do need this at Diamond and elsewhere that don't do this.

KarlLevik commented 5 years ago

There was agreement at the ISPyB meeting in Trieste that this could be implemented.

KarlLevik commented 5 years ago

Closing, see https://github.com/ispyb/ISPyB/pull/366