civicrm_membership_log


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_id C

FK to Membership table

status_id INT UNSIGNED 10 null
civicrm_membership_status.id FK_civicrm_membership_log_status_id C

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_id N

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_id N

FK to Membership Type.

max_related INT 10 null

Maximum number of related memberships.

Table contained 0 rows

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