civicrm_membership


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_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 null
civicrm_contact.id FK_civicrm_membership_contact_id C

FK to Contact ID

membership_type_id INT UNSIGNED 10 null
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 null
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 0 rows

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