Member module : database schema

The member module defines the following tables.

Member

A member.

• cid (integer) The member's ID from the Contact Module.

Plan

A membership plan.

• pid (integer) The unique ID of the membership plan.
• name (string) The name of the membership plan.
• price (string) The price of the membership plan (e.g. "39.00")
• active (integer) 1 if the plan is still open for members to sign up.
• voting (integer) 1 if the plan allows members to vote.

Membership

Represents a specific member signed up to a specific plan at a specific time.

• sid (integer) A unique ID.
• cid (integer) The unique ID of the member from the Contact Module.
• pid (integer) The unique ID of the membership plan.
• start (date) The date the member signed up for the plan
• end (date) The date the member cancelled the plan (or NULL if they haven't yet)