Column Type Size Nulls Auto Default Children Parents Comments

Membership Id

name VARCHAR 128 null

Name for Membership Status

start_event VARCHAR 12 null

Event when this status starts.

start_event_adjust_unit VARCHAR 8 null

Unit used for adjusting from start_event.

start_event_adjust_interval INT 10 null

Status range begins this many units from start_event.

end_event VARCHAR 12 null

Event after which this status ends.

end_event_adjust_unit VARCHAR 8 null

Unit used for adjusting from the ending event.

end_event_adjust_interval INT 10 null

Status range ends this many units from end_event.

is_current_member TINYINT 3 null

Does this status aggregate to current members (e.g. New, Renewed, Grace might all be TRUE... while Unrenewed, Lapsed, Inactive would be FALSE).

is_admin TINYINT 3 null

Is this status for admin/manual assignment only.

weight INT 10 null
is_default TINYINT 3 null

Assign this status to a membership record if no other status match is found.

is_active TINYINT 3 1

Is this membership_status enabled.

is_reserved TINYINT 3 0

Is this membership_status reserved.

label VARCHAR 128 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views