Membership Management System

List of entities

Name	Primary key constraint name	Number of columns	Comment
account	PK_account	7
account_type		3
action		3	Actions defined in Symfony framework. Used in the development of context sensitive menus. Examples: new:Corresponding to executeNew edit:Corresponding to executeEdit
analysis	PK_analysis	7	Used to hold analysis values within symfony
analysis_cls	PK_analysis_cls	4	Used to establish a hierarchy of analysis
analysis_division	PK_analysis_division	5	Analysis details across functional divisions.
analysis_finance		5
analysis_geographic	PK_analysis_geographic	7	Analysis details across geographic divisions.
analysis_type	PK_analysis_type	4	Various types of analysis used within the organization
association	PK_association	3
attendee		3
attendee_type		4
blacklist_email		2
blacklist_ip		2
breadcrumb		4
bulkpost	PK_bulkpost	2	aka bulkpost stations
bulkpost_prefix	PK_bulkpost_prefix	2	Bulk post zip prefixes.
ccprocessed	PK_ccprocessed	6
ccprocessor	PK_ccprocessor	5
certification	PK_certification	5	Professional credentials
certified	PK_certified	5
channel	PK_channel	4
city	PK_city	3
complaint	PK_complaint	8
country	PK_country	2
delivery	PK_delivery	4	aka magazine delivery
delivery_batch	PK_delivery_batch	4	Record of new delivery processing
delivery_cls	PK_delivery_cls	3
division	PK_division	12
division_access	PK_division_access	2
division_cls	PK_division_cls	2
division_cls_access		2
division_status	PK_division_status	3
election	PK_election	5
election_candidates	PK_election_candidates	7
election_detail	PK_election_detail	4
election_notes	PK_election_notes	3
election_validate		5
election_votes	PK_election_votes	6
email	PK_email	4
entity		2	This table provides a timestamp (created_at) and a unique id (entity_id) to indicate when a new organization or person is inserted into the system.
entity_location	PK_entity_location	3
event		7
event_type		3
expense	PK_expense	5
expense_detail	PK_expense_detail	8
expense_note	PK_expense_note	3
file_count	PK_file_count	3
file_detail	PK_file_detail	6	See description of "signature"
frequency		3
frm	PK_frm	10	Info directly from on-line form.
frm_email		4
frm_loc1		7
frm_loc2		11
frm_org		6
frm_person		10
frm_phone		6
grade	PK_grade	7
grade_cls		3
heading		4
help		5
inventory	PK_inventory	5
invoice	PK_invoice	8
invoice_line	PK_invoice_line	7
issue	PK_issue	4
item	PK_item	4
location	PK_location	4
log_module	PK_log_module	6
log_online	PK_log_online	5
mail		4
mail_batch	PK_mail_batch	4
mail_cls		3
manager	PK_manager	3	managers of members account.
member	PK_member	3
membership	PK_membership	4
member_card	PK_member_card	3
member_grade	PK_member_grade	5
member_note	PK_member_note	3
menu		10
notification	PK_notification	4
notified	PK_notified	4
notify	PK_notify	3
office	PK_office	4	e.g. president, vp, secretary
officer	PK_officer	4	List of all officers
officer_emeritus	PK_officer_emeritus	5
office_contact		4
org	PK_org	5
org_cls	PK_org_cls	2
paymethod	PK_paymethod	2	Paymethods. Typically cash or credit card.
person	PK_person	10
phone	PK_phone	4
postal_city	PK_postal_city	4
process	PK_process	4	Processing from invoice to receipt
project	PK_project	7
receipt	PK_receipt	8	paidby_id alias for entity_id
receipt_detail	PK_receipt_detail	7
receipt_note	PK_receipt_note	3
region		4
resolution		8
secure_group		4
secure_group_module		3
secure_module		4
secure_remember_key		4
secure_user		10
secure_user_group		2
state	PK_state	4
status		2
subscription	PK_subscription	3	aka magazine subscription
subscription_hold	PK_subscription_hold	3
sysdata	PK_sysdata	3
sysname		4
task	PK_task	7
task_cls	PK_task_cls	3
task_worker	PK_task_worker	4
unit	PK_unit	2	Units refers to units of measure such as lb, minute, etc.
worker	PK_worker	5
worker_cls	PK_worker_cls	3