civicrm_membership_type

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_membership.membership_type_id FK_civicrm_membership_membership_type_idC
civicrm_membership_block.membership_type_default FK_civicrm_membership_block_membership_type_defaultR
civicrm_membership_log.membership_type_id FK_civicrm_membership_log_membership_type_idN
civicrm_price_field_value.membership_type_id FK_civicrm_price_field_value_membership_type_idN

Membership Id
domain_id INT UNSIGNED 10 null
civicrm_domain.id FK_civicrm_membership_type_domain_idR

Which Domain is this match entry for
member_of_contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_membership_type_member_of_contact_idR

Owner organization for this membership type. FK to Contact ID
financial_type_id INT UNSIGNED 10 null
civicrm_financial_type.id FK_civicrm_membership_type_financial_type_idR

If membership is paid by a contribution - what financial type should be used. FK to civicrm_financial_type.id
minimum_fee DECIMAL 18,9 √ 0.000000000

Minimum fee for this membership (0 for free/complimentary memberships).
duration_unit VARCHAR 8 √ null

Unit in which membership period is expressed.
duration_interval INT 10 √ null

Number of duration units in membership period (e.g. 1 year, 12 months).
period_type VARCHAR 8 √ null

Rolling membership period starts on signup date. Fixed membership periods start on fixed_period_start_day.
fixed_period_start_day INT 10 √ null

For fixed period memberships, month and day (mmdd) on which subscription/membership will start. Period start is back-dated unless after rollover day.
fixed_period_rollover_day INT 10 √ null

For fixed period memberships, signups after this day (mmdd) rollover to next period.
relationship_type_id VARCHAR 64 √ null

FK to Relationship Type ID
relationship_direction VARCHAR 128 √ null
max_related INT 10 √ null

Maximum number of related memberships.
visibility VARCHAR 64 √ null
weight INT 10 √ null
receipt_text_signup VARCHAR 255 √ null

Receipt Text for membership signup
receipt_text_renewal VARCHAR 255 √ null

Receipt Text for membership renewal
auto_renew TINYINT 3 √ 0

0 = No auto-renew option; 1 = Give option, but not required; 2 = Auto-renew required;
is_active TINYINT 3 √ 1

Is this membership_type enabled
name_en_US VARCHAR 128 √ null
description_en_US VARCHAR 255 √ null
name_fr_CA VARCHAR 128 √ null
description_fr_CA VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_membership_type_domain_id Performance Asc domain_id
FK_civicrm_membership_type_financial_type_id Performance Asc financial_type_id
FK_civicrm_membership_type_member_of_contact_id Performance Asc member_of_contact_id
index_relationship_type_id Performance Asc relationship_type_id

Relationships

Close relationships within degrees of separation