Table d44civi_9xzwf.civicrm_membership_type 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.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
civicrm_domain.id FK_civicrm_membership_type_domain_id R
Which Domain is this match entry for
name varchar 128  √  null Name of Membership Type
description varchar 255  √  null Description of Membership Type
member_of_contact_id int unsigned 10
civicrm_contact.id 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
civicrm_financial_type.id FK_civicrm_membership_type_financial_type_id R
If membership is paid by a contribution - what financial type should be used. FK to civicrm_financial_type.id
minimum_fee decimal 20,2  √  0.00 Minimum fee for this membership (0 for free/complimentary memberships).
duration_unit enum 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 enum 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

Table contained 3 rows at Wed Nov 11 17:14 EST 2015

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

Close relationships  within of separation: