ispyb / ispyb-database-modeling

4 stars 3 forks source link

Laboratory name issue at MAXIV #75

Open hormiai76 opened 1 year ago

hormiai76 commented 1 year ago

Hi, I'm fixing a problem we have in the syncronization between our User Portal and ISPyB and I realized that we have a varchar(45) name in the Laboratory table and we have 200 characters in the User Portal. Is it possible to update the Laboratory.name column to 200 characters?

A second question is about the organization column. Is the organization the name of the institute the laboratory belong to? If Yes, can I udpate it to 200 character too? If No can you give me some examples to understand this column? In our user portal we have Institute name and Department name. how I should map them in ISPyB Laboratory table?

Regards, Alberto