1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Member
</base>
5 <class>MembershipLog
</class>
6 <name>civicrm_membership_log
</name>
8 <comment>Logs actions which affect a Membership record (signup, status override, renewal, etc.)
</comment>
12 <type>int unsigned
</type>
13 <required>true
</required>
18 <autoincrement>true
</autoincrement>
21 <name>membership_id
</name>
22 <type>int unsigned
</type>
23 <required>true
</required>
24 <comment>FK to Membership table
</comment>
28 <name>membership_id
</name>
29 <table>civicrm_membership
</table>
32 <onDelete>CASCADE
</onDelete>
35 <name>status_id
</name>
36 <title>Membership Status
</title>
37 <type>int unsigned
</type>
38 <required>true
</required>
39 <comment>New status assigned to membership by this action. FK to Membership Status
</comment>
43 <name>status_id
</name>
44 <table>civicrm_membership_status
</table>
47 <onDelete>CASCADE
</onDelete>
50 <name>start_date
</name>
52 <dataPattern>/\d{
4}-?\d{
2}-?\d{
2}/
</dataPattern>
53 <comment>New membership period start date
</comment>
59 <dataPattern>/\d{
4}-?\d{
2}-?\d{
2}/
</dataPattern>
60 <comment>New membership period expiration date.
</comment>
64 <name>modified_id
</name>
65 <type>int unsigned
</type>
66 <comment>FK to Contact ID of person under whose credentials this data modification was made.
</comment>
70 <name>modified_id
</name>
71 <table>civicrm_contact
</table>
74 <onDelete>SET NULL
</onDelete>
77 <name>modified_date
</name>
78 <title>Membership Change Date
</title>
80 <dataPattern>/\d{
4}-?\d{
2}-?\d{
2}/
</dataPattern>
81 <comment>Date this membership modification action was logged.
</comment>
85 <name>membership_type_id
</name>
86 <type>int unsigned
</type>
87 <comment>FK to Membership Type.
</comment>
91 <name>membership_type_id
</name>
92 <table>civicrm_membership_type
</table>
95 <onDelete>SET NULL
</onDelete>
98 <name>max_related
</name>
100 <comment>Maximum number of related memberships.
</comment>