Authorship

[netbofia]

The way authorship is arranged it is limited to the trial. Therefore the studies inharite authorship from their trial.

This is ok untill we face the fact that studies might have differente authorships.

Compatibility issue between: studies/ and trials/ call.
Since authorship is now an array in trials authorship could pass to study.

[DanFaria]

Right now, looking at the database schema, we have authorship at 3 levels:

• Program - leadPerson
• ObservationVariable - scientist
• Observation - operator; uploadedBy

Looking at the current trials and studies calls, it seems that neither of these levels are adequate, as they refer to contacts for the study and trial. We cannot assume that the contacts for the study are the people involved in the observations, nor can we assume that the contacts for the trial are the same as the contacts for the study.

Solution: Create two connection tables, TrialContacts and StudyContacts, that link respectively the Trial and Study tables to the Person table to capture the contact information.

[netbofia]

A solution was modeled in DBdesigner where it stays ate a trial level but each Datasetauthorship is link to a Trial.

https://app.dbdesigner.net/designer/schema/245190