associating contact roles with a project?

[bradfordcondon]

Hello,

I'm mapping out a module that would integrate drupal users with chado contacts. Part of that is I would like to assign users to different roles for different subsets of chado data. The most obvious way to do that to me is to use the chado.project_contact table. However that table only has contact_id and project_id: how can i specify that user X is the admin for a project and user Y has read access, and user Z has write access?

I would think either a) type_id for project_contact or b) project_contactprop. Either approach would involve adding to Chado. there's always c) do it my own way and/or not in Chado. i can see how this isnt strictly biological data and therefore i should have, instead, a public linker table for users and projects where i can specify the role as its own column.

Any thoughts/experience on this?