civicrm_membership

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_membership.owner_membership_id FK_civicrm_membership_owner_membership_idN
civicrm_membership_log.membership_id FK_civicrm_membership_log_membership_idC
civicrm_membership_payment.membership_id FK_civicrm_membership_payment_membership_idC

Membership Id
contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_membership_contact_idC

FK to Contact ID
membership_type_id INT UNSIGNED 10 null
civicrm_membership_type.id FK_civicrm_membership_membership_type_idC

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 null
civicrm_membership_status.id FK_civicrm_membership_status_idC

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_idN

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_idN

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_idN

The campaign for which this membership is attached.
status_override_end_date DATE 10 √ null

The end date of membership status override if (Override until selected date) override type is selected.

Indexes

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

Relationships

Close relationships within degrees of separation