[NCUC E-team] OffRep/ind members using one single email address - db doesn't like it

[Pranesh Prakash]

Dear Stefania and all,
This problem exists since "primary email address" is currently designated as a unique field.
>    ADD CONSTRAINT ncucers_email_key UNIQUE (email);

The question then arises: Should the same person be in the database twice, once as an individual and once as an org rep?  Should organizational representation subsume individual membership?  I'll raise it as a clarificatory question during tomorrow's EC meeting.

Regards,
Pranesh

"Milan, Stefania" <Stefania.Milan at EUI.eu> [2014-01-26 15:27:32 +0000]:
> Dear e-team
> 
> in adding new members to the bd/website, I encounter a problem (and found a temporary solution to it). I share it here for future reference.
> 
> 
> There appears to be a problem when we try to add a member who intends to use an email address that already exists in the database. This is the case of new individual members who are also the official representative for an organization (and viceversa), and have indicated the same email address twice.
> 
> I found a trick to bypass the problem: insert the email address as "alternative email" [email2 in the database] (leaving the "primary email address" field [email in the database] empty). Might not be perfect but it works.
> 
> 
> Best, Stefania
> 
> 
> The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination, distribution, forwarding, or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited without the express permission of the sender. If you received this communication in error, please contact the sender and delete the material from any computer.



-- 
Pranesh Prakash
Policy Director, Centre for Internet and Society
T: +91 80 40926283 | W: http://cis-india.org
-------------------
Access to Knowledge Fellow, Information Society Project, Yale Law School
M: +1 520 314 7147 | W: http://yaleisp.org
PGP ID: 0x1D5C5F07 | Twitter: https://twitter.com/pranesh_prakash
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <http://lists.ncuc.org/pipermail/e-team/attachments/20140127/245dc223/attachment.sig>