civicrm_membership_log

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
membership_id INT UNSIGNED 10 null
civicrm_membership.id FK_civicrm_membership_log_membership_idC

FK to Membership table
status_id INT UNSIGNED 10 null
civicrm_membership_status.id FK_civicrm_membership_log_status_idC

New status assigned to membership by this action. FK to Membership Status
start_date DATE 10 √ null

New membership period start date
end_date DATE 10 √ null

New membership period expiration date.
modified_id INT UNSIGNED 10 √ null
civicrm_contact.id FK_civicrm_membership_log_modified_idN

FK to Contact ID of person under whose credentials this data modification was made.
modified_date DATE 10 √ null

Date this membership modification action was logged.
membership_type_id INT UNSIGNED 10 √ null
civicrm_membership_type.id FK_civicrm_membership_log_membership_type_idN

FK to Membership Type.
max_related INT 10 √ null

Maximum number of related memberships.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_membership_log_membership_id Performance Asc membership_id
FK_civicrm_membership_log_membership_type_id Performance Asc membership_type_id
FK_civicrm_membership_log_modified_id Performance Asc modified_id
FK_civicrm_membership_log_status_id Performance Asc status_id

Relationships

Close relationships within degrees of separation