Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_membership.membership_type_id FK_civicrm_membership_membership_type_id C
civicrm_membership_block.membership_type_default FK_civicrm_membership_block_membership_type_default R
civicrm_membership_log.membership_type_id FK_civicrm_membership_log_membership_type_id N
civicrm_price_field_value.membership_type_id FK_civicrm_price_field_value_membership_type_id N

Membership Id

domain_id INT UNSIGNED 10 null FK_civicrm_membership_type_domain_id R

Which Domain is this match entry for

member_of_contact_id INT UNSIGNED 10 null FK_civicrm_membership_type_member_of_contact_id R

Owner organization for this membership type. FK to Contact ID

financial_type_id INT UNSIGNED 10 null FK_civicrm_membership_type_financial_type_id R

If membership is paid by a contribution - what financial type should be used. FK to

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

Table contained 0 rows


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