Table d45civi_b72v5.civicrm_membership Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_membership.owner_membership_id FK_civicrm_membership_owner_membership_id N
civicrm_membership_log.membership_id FK_civicrm_membership_log_membership_id C
civicrm_membership_payment.membership_id FK_civicrm_membership_payment_membership_id C
Membership Id
contact_id int unsigned 10
civicrm_contact.id FK_civicrm_membership_contact_id C
FK to Contact ID
membership_type_id int unsigned 10
civicrm_membership_type.id FK_civicrm_membership_membership_type_id C
FK to Membership Type
join_date date 10  √  null Beginning of initial membership period (member since...).
start_date date 10  √  null Beginning of current uninterrupted membership period.
end_date date 10  √  null Current membership period expire date.
source varchar 128  √  null
status_id int unsigned 10
civicrm_membership_status.id FK_civicrm_membership_status_id C
FK to Membership Status
is_override tinyint 3  √  null Admin users may set a manual status which overrides the calculated status. When this flag is true, automated status update scripts should NOT modify status for the record.
owner_membership_id int unsigned 10  √  null
civicrm_membership.id FK_civicrm_membership_owner_membership_id N
Optional FK to Parent Membership.
max_related int 10  √  null Maximum number of related memberships (membership_type override).
is_test tinyint 3  √  0
is_pay_later tinyint 3  √  0
contribution_recur_id int unsigned 10  √  null
civicrm_contribution_recur.id FK_civicrm_membership_contribution_recur_id N
Conditional foreign key to civicrm_contribution_recur id. Each membership in connection with a recurring contribution carries a foreign key to the recurring contribution record. This assumes we can track these processor initiated events.
campaign_id int unsigned 10  √  null
civicrm_campaign.id FK_civicrm_membership_campaign_id N
The campaign for which this membership is attached.

Table contained 30 rows at Wed Nov 11 17:12 EST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
campaign_id Performance Asc FK_civicrm_membership_campaign_id
contact_id Performance Asc FK_civicrm_membership_contact_id
contribution_recur_id Performance Asc FK_civicrm_membership_contribution_recur_id
membership_type_id Performance Asc FK_civicrm_membership_membership_type_id
status_id Performance Asc FK_civicrm_membership_status_id
owner_membership_id Performance Asc index_owner_membership_id

Close relationships  within of separation: