This is a question Jason asked on 6/15/19 as an alternative to the Manifest record.
In addition to identifying member/artists, the Manifest record serves as the basis for assigning/revoking management rights and linking manager permissions. So elimination with a flag can't work and the flag seemed unnecessary.
However, without a flag in the member record there is no way to identify which members are artists without a second query to determine if the member has an attached manifest.
139 is already proposing a new member column to track a manager_id traceable back to another registered system user.
It may be helpful to add an artist flag to the record also to simplify the initial identification of these records.
With these fields, in combination with the member-type column, a flat query of member would provide enough information to determine the role of each member in the system.
This is a question Jason asked on 6/15/19 as an alternative to the Manifest record.
In addition to identifying member/artists, the Manifest record serves as the basis for assigning/revoking management rights and linking manager permissions. So elimination with a flag can't work and the flag seemed unnecessary.
However, without a flag in the member record there is no way to identify which members are artists without a second query to determine if the member has an attached manifest.
139 is already proposing a new member column to track a manager_id traceable back to another registered system user.
It may be helpful to add an artist flag to the record also to simplify the initial identification of these records.
With these fields, in combination with the member-type column, a flat query of
memberwould provide enough information to determine the role of each member in the system.