Table d47civi_0z3xa.civicrm_membership_log Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
membership_id int unsigned 10
civicrm_membership.id FK_civicrm_membership_log_membership_id C
FK to Membership table
status_id int unsigned 10
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 30 rows at mer. avr. 13 16:52 EDT 2016

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

Close relationships  within of separation: