previously, we had the idea of an election candidate:<\/p>\n
\r\ncreate table election_candidate (\r\n id serial unique not null,\r\n election_position_id int not null,\r\n approved boolean,\r\n member_id int not null,\r\n spiel text,\r\n CONSTRAINT \"election_candidate_pkey\" PRIMARY KEY (id),\r\n CONSTRAINT \"election_candidate_election_position_id_fkey\" FOREIGN KEY (org_id) references election_position(id) on update restrict,\r\n CONSTRAINT \"election_candidate_member_id\" FOREIGN KEY (member-id) references current_memberships(id)\r\n -- FIXME: need constraint that member is a member of the correct org.\r\n );\r\n<\/pre>\nnow, that’s all fine and good… but we need the whole nominations thing to work.<\/p>\n
so what about something like this:<\/p>\n
\r\ncreate table election_candidate_nomination (\r\n when timestamp not null default now(),\r\n election_position_id int not null,\r\n from_member_id int not null, -- member doing the nominating\r\n for_member_id int not null, -- the member being nominated,\r\n reason text,\r\n CONSTRAINT \"nomination_from_member_id_fkey\" FOREIGN KEY (from_member_id) references members(id) on update restrict,\r\n CONSTRAINT \"nomination_for_member_id_fkey\" FOREIGN KEY (for_member_id) references members(id) on update restrict,\r\n CONSTRAINT \"election_candidate_election_position_id_fkey\" FOREIGN KEY (org_id) references election_position(id) on update restrict,\r\n\r\n);\r\n<\/pre>\nthis should be adequate to keep track of nominations. When enough nominations are gathered and the candidate accepts, then we can create an entry in election_candidate.<\/p>\n","protected":false},"excerpt":{"rendered":"
previously, we had the idea of an election candidate: create table election_candidate ( id serial unique not null, election_position_id int not null, approved boolean, member_id int not null, spiel text, CONSTRAINT “election_candidate_pkey” PRIMARY KEY (id), CONSTRAINT “election_candidate_election_position_id_fkey” FOREIGN KEY (org_id) … Continue reading