Column Type Size Nulls Auto Default Children Parents Comments

Membership Id

domain_id INT UNSIGNED 10 null

Which Domain is this match entry for

member_of_contact_id INT UNSIGNED 10 null

Owner organization for this membership type. FK to Contact ID

financial_type_id INT UNSIGNED 10 null

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 VARCHAR 128 null
description VARCHAR 255 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views