search

ispyb / ispyb-database-modeling

4 stars 3 forks source link

A role column for ProposalHasPerson #11

Open KarlLevik opened 7 years ago

KarlLevik commented 7 years ago

At Diamond we need a role column for the ProposalHasPerson table, similar to how we have a role column in Session_has_Person.

ALTER TABLE ProposalHasPerson
  ADD role enum('Co-Investigator','Principal Investigator','Alternate Contact');

Does this look sensible? (NULL is implicitly allowed as an option in the enum.)

ispyb commented 6 years ago

Hi @KarlLevik,

We wonder what it is the use case. Are there specific actions that are restricted or allowed per role?

KarlLevik commented 5 years ago

It's been a while since I created this ticket, so struggling to remember the use case. One use case may be that we simply want to display the roles in the application.

KarlLevik commented 5 years ago

Agreed at VC today - Karl to commit script