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 <title>Membership Log ID
</title>
13 <type>int unsigned
</type>
14 <required>true
</required>
19 <autoincrement>true
</autoincrement>
22 <name>membership_id
</name>
23 <title>Membership ID
</title>
24 <type>int unsigned
</type>
25 <required>true
</required>
26 <comment>FK to Membership table
</comment>
30 <name>membership_id
</name>
31 <table>civicrm_membership
</table>
34 <onDelete>CASCADE
</onDelete>
37 <name>status_id
</name>
38 <title>Membership Status
</title>
39 <type>int unsigned
</type>
40 <required>true
</required>
41 <comment>New status assigned to membership by this action. FK to Membership Status
</comment>
45 <name>status_id
</name>
46 <table>civicrm_membership_status
</table>
49 <onDelete>CASCADE
</onDelete>
52 <name>start_date
</name>
53 <title>Membership Log Start Date
</title>
55 <dataPattern>/\d{
4}-?\d{
2}-?\d{
2}/
</dataPattern>
56 <comment>New membership period start date
</comment>
61 <title>Membership Log End Date
</title>
63 <dataPattern>/\d{
4}-?\d{
2}-?\d{
2}/
</dataPattern>
64 <comment>New membership period expiration date.
</comment>
68 <name>modified_id
</name>
69 <title>Membership Log modified By
</title>
70 <type>int unsigned
</type>
71 <comment>FK to Contact ID of person under whose credentials this data modification was made.
</comment>
75 <name>modified_id
</name>
76 <table>civicrm_contact
</table>
79 <onDelete>SET NULL
</onDelete>
82 <name>modified_date
</name>
83 <title>Membership Change Date
</title>
85 <dataPattern>/\d{
4}-?\d{
2}-?\d{
2}/
</dataPattern>
86 <comment>Date this membership modification action was logged.
</comment>
90 <name>membership_type_id
</name>
91 <title>Membership Type ID
</title>
92 <type>int unsigned
</type>
93 <comment>FK to Membership Type.
</comment>
97 <name>membership_type_id
</name>
98 <table>civicrm_membership_type
</table>
101 <onDelete>SET NULL
</onDelete>
104 <name>max_related
</name>
105 <title>Maximum Related Memberships
</title>
107 <comment>Maximum number of related memberships.
</comment>