search

ispyb / ispyb-database-modeling

4 stars 3 forks source link

State of a proposal #36

Closed KarlLevik closed 5 years ago

KarlLevik commented 5 years ago

I'd like to propose a state column for the Proposal table:

ALTER TABLE Proposal
    ADD state enum('Open', 'Closed', 'Cancelled') NULL DEFAULT 'Open';

This way the ISPyB applications can prevent users from e.g. uploading shipments to proposals that are not open.

antolinos commented 5 years ago

It is fine with us. Our states are slightly different but not sure how we are going to use it.