Membership Management System
Project details
ER diagram
Entities
Attributes
Relationships
Views
Procedures
List of relationships
Relationship details
Name
Relationship type
Parent
Child
Cardinality
account_analysis_finance
Identifying
account
analysis_finance
Zero Or More
account_expense_detail
Identifying
account
expense_detail
Zero Or More
account_invoice_line
Identifying
account
invoice_line
Zero Or More
account_receipt_detail
Identifying
account
receipt_detail
Zero Or More
account_type_account
Non Identifying
account_type
account
Zero Or More
action_log_module
Non Identifying
action
log_module
Zero Or More
action_menu
Non Identifying
action
menu
Zero Or More
analysis_analysis_division
Identifying
analysis
analysis_division
Zero Or More
analysis_analysis_finance
Identifying
analysis
analysis_finance
Zero Or More
analysis_analysis_geographic
Identifying
analysis
analysis_geographic
Zero Or More
analysis_cls_analysis
Non Identifying
analysis_cls
analysis
Zero Or More
analysis_type_analysis_division
Identifying
analysis_type
analysis_division
Zero Or More
analysis_type_analysis_geographic
Identifying
analysis_type
analysis_geographic
Zero Or More
attendee_type_attendee
Identifying
attendee_type
attendee
Zero Or More
bulkpost_bulkpost_prefix
Identifying
bulkpost
bulkpost_prefix
Zero Or More
ccprocessor_ccprocessed
Non Identifying
ccprocessor
ccprocessed
Zero Or More
certification_certified
Identifying
certification
certified
Zero Or More
channel_invoice
Non Identifying
channel
invoice
Zero Or More
channel_receipt
Non Identifying
channel
receipt
Zero Or More
city_postal_city
Non Identifying
city
postal_city
Zero Or More
complaint_resolution
Non Identifying
complaint
resolution
Zero Or One
country_state
Identifying
country
state
Zero Or More
delivery_batch_delivery
Identifying
delivery_batch
delivery
Zero Or More
delivery_cls_delivery
Identifying
delivery_cls
delivery
Zero Or More
division_account
Non Identifying
division
account
Zero Or More
division_analysis_division
Identifying
division
analysis_division
Zero Or More
division_cls_attendee_type
Non Identifying
division_cls
attendee_type
Zero Or More
division_cls_division
Non Identifying
division_cls
division
Zero Or More
division_cls_division_cls_access
Identifying
division_cls
division_cls_access
Zero Or One
division_cls_item
Non Identifying
division_cls
item
Zero Or More
division_cls_office
Non Identifying
division_cls
office
Zero Or More
division_division_access
Identifying
division
division_access
Zero Or More
division_division_status
Identifying
division
division_status
Zero Or More
division_election_detail
Identifying
division
election_detail
Zero Or More
division_election_validate
Identifying
division
election_validate
Zero Or More
division_event
Non Identifying
division
event
Zero Or More
division_inventory
Non Identifying
division
inventory
Zero Or More
division_officer
Identifying
division
officer
Zero Or More
division_officer_emeritus
Identifying
division
officer_emeritus
Zero Or More
division_office_contact
Identifying
division
office_contact
Zero Or More
division_project
Non Identifying
division
project
Zero Or More
division_task
Identifying
division
task
Zero Or More
division_task_worker
Identifying
division
task_worker
Zero Or More
division_worker
Identifying
division
worker
Zero Or More
election_detail_election_candidates
Identifying
election_detail
election_candidates
Zero Or More
election_detail_election_votes
Identifying
election_detail
election_votes
Zero Or More
election_election_detail
Identifying
election
election_detail
Zero Or More
election_election_notes
Identifying
election
election_notes
Zero Or More
election_election_validate
Identifying
election
election_validate
Zero Or More
event_attendee
Identifying
event
attendee
Zero Or More
event_type_event
Non Identifying
event_type
event
Zero Or More
expense_expense_detail
Identifying
expense
expense_detail
Zero Or More
expense_expense_note
Identifying
expense
expense_note
Zero Or More
file_count_file_detail
Identifying
file_count
file_detail
Zero Or More
frequency_notify
Non Identifying
frequency
notify
One Or More
frm_frm_email
Identifying
frm
frm_email
Zero Or One
frm_frm_loc1
Identifying
frm
frm_loc1
Zero Or One
frm_frm_loc2
Identifying
frm
frm_loc2
Zero Or One
frm_frm_org
Identifying
frm
frm_org
Zero Or One
frm_frm_phone
Identifying
frm
frm_phone
Zero Or One
frm_invoice_line
Identifying
frm
invoice_line
Zero Or More
grade_analysis_division
Identifying
grade
analysis_division
Zero Or More
grade_analysis_geographic
Identifying
grade
analysis_geographic
Zero Or More
grade_cls_grade
Non Identifying
grade_cls
grade
Zero Or More
grade_member_grade
Identifying
grade
member_grade
Zero Or More
heading_menu
Non Identifying
heading
menu
Zero Or More
help_menu
Non Identifying
help
menu
Zero Or More
inventory_invoice_line
Non Identifying
inventory
invoice_line
Zero Or More
invoice_frm
Identifying
invoice
frm
Zero Or More
invoice_receipt
Non Identifying
invoice
receipt
Zero Or More
issue_complaint
Non Identifying
issue
complaint
Zero Or More
item_expense_detail
Identifying
item
expense_detail
Zero Or More
location_entity_location
Identifying
location
entity_location
Zero Or More
log_online_log_module
Identifying
log_online
log_module
Zero Or More
mail_batch_mail
Identifying
mail_batch
mail
Zero Or More
mail_cls_mail
Identifying
mail_cls
mail
Zero Or More
member_certified
Identifying
member
certified
Zero Or More
member_election_candidates
Identifying
member
election_candidates
Zero Or More
member_election_validate
Identifying
member
election_validate
Zero Or More
member_election_votes
Identifying
member
election_votes
Zero Or More
member_entity_location
Identifying
member
entity_location
Zero Or More
member_mail
Identifying
member
mail
Zero Or More
member_manager
Identifying
member
manager
Zero Or More
member_membership
Identifying
member
membership
Zero Or More
member_member_card
Identifying
member
member_card
Zero Or More
member_member_grade
Identifying
member
member_grade
Zero Or More
member_member_note
Identifying
member
member_note
Zero Or More
member_notify
Identifying
member
notify
Zero Or More
member_org
Identifying
member
org
Zero Or One
member_person
Identifying
member
person
Zero Or One
member_subscription
Identifying
member
subscription
Zero Or More
member_subscription_hold
Identifying
member
subscription_hold
Zero Or More
member_task_worker
Identifying
member
task_worker
Zero Or More
member_worker
Identifying
member
worker
Zero Or More
menu_breadcrumb
Non Identifying
menu
breadcrumb
Zero Or One
notification_notify
Identifying
notification
notify
Zero Or More
notify_notified
Identifying
notify
notified
Zero Or More
office_officer
Identifying
office
officer
Zero Or More
office_officer_emeritus
Identifying
office
officer_emeritus
Zero Or More
org_association
Identifying
org
association
Zero Or More
org_cls_frm_org
Non Identifying
org_cls
frm_org
Zero Or More
org_cls_org
Non Identifying
org_cls
org
One Or More
paymethod_receipt
Non Identifying
paymethod
receipt
Zero Or More
person_association
Identifying
person
association
Zero Or More
person_complaint
Non Identifying
person
complaint
Zero Or More
person_email
Identifying
person
email
Zero Or More
person_manager
Identifying
person
manager
Zero Or More
person_officer
Identifying
person
officer
Zero Or More
person_officer_emeritus
Identifying
person
officer_emeritus
Zero Or More
person_phone
Identifying
person
phone
Zero Or More
person_receipt
Non Identifying
person
receipt
Zero Or More
person_receipt_detail
Identifying
person
receipt_detail
Zero Or More
postal_city_location
Non Identifying
postal_city
location
Zero Or More
process_member_card
Identifying
process
member_card
Zero Or More
process_receipt
Non Identifying
process
receipt
Zero Or More
project_analysis_finance
Identifying
project
analysis_finance
Zero Or One
project_expense
Non Identifying
project
expense
Zero Or More
project_receipt
Non Identifying
project
receipt
Zero Or More
receipt_ccprocessed
Identifying
receipt
ccprocessed
Zero Or More
receipt_receipt_detail
Identifying
receipt
receipt_detail
Zero Or More
receipt_receipt_note
Identifying
receipt
receipt_note
Zero Or More
region_division
Non Identifying
region
division
Zero Or More
secure_group_secure_group_module
Identifying
secure_group
secure_group_module
Zero Or More
secure_group_secure_user_group
Identifying
secure_group
secure_user_group
Zero Or More
secure_module_log_module
Non Identifying
secure_module
log_module
Zero Or More
secure_module_menu
Non Identifying
secure_module
menu
Zero Or More
secure_module_secure_group_module
Identifying
secure_module
secure_group_module
Zero Or More
secure_module_sysname
Non Identifying
secure_module
sysname
Zero Or More
secure_user_breadcrumb
Non Identifying
secure_user
breadcrumb
Zero Or More
secure_user_division_access
Identifying
secure_user
division_access
Zero Or More
secure_user_division_cls_access
Identifying
secure_user
division_cls_access
Zero Or One
secure_user_log_online
Non Identifying
secure_user
log_online
Zero Or More
secure_user_secure_remember_key
Identifying
secure_user
secure_remember_key
Zero Or More
secure_user_secure_user_group
Identifying
secure_user
secure_user_group
Zero Or More
secure_user_sysdata
Identifying
secure_user
sysdata
Zero Or More
state_analysis_geographic
Identifying
state
analysis_geographic
Zero Or More
state_division
Non Identifying
state
division
Zero Or More
state_postal_city
Non Identifying
state
postal_city
Zero Or More
status_division_status
Identifying
status
division_status
Zero Or More
subscription_delivery
Identifying
subscription
delivery
Zero Or More
task_cls_task
Non Identifying
task_cls
task
Zero Or More
task_task_worker
Identifying
task
task_worker
Zero Or More
unit_expense_detail
Non Identifying
unit
expense_detail
Zero Or More
unit_invoice_line
Non Identifying
unit
invoice_line
Zero Or More
unit_receipt_detail
Non Identifying
unit
receipt_detail
Zero Or More
worker_cls_worker
Identifying
worker_cls
worker
Zero Or More