civicrm_membership_status

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_membership.status_id FK_civicrm_membership_status_idC
civicrm_membership_log.status_id FK_civicrm_membership_log_status_idC

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_en_US VARCHAR 128 null
label_fr_CA VARCHAR 128 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships