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>
10 <component>CiviMember
</component>
13 <title>Membership Log ID
</title>
14 <type>int unsigned
</type>
15 <required>true
</required>
23 <autoincrement>true
</autoincrement>
26 <name>membership_id
</name>
27 <title>Membership ID
</title>
28 <type>int unsigned
</type>
29 <required>true
</required>
30 <comment>FK to Membership table
</comment>
32 <label>Membership
</label>
37 <name>membership_id
</name>
38 <table>civicrm_membership
</table>
41 <onDelete>CASCADE
</onDelete>
44 <name>status_id
</name>
45 <title>Membership Status ID
</title>
46 <type>int unsigned
</type>
47 <required>true
</required>
48 <comment>New status assigned to membership by this action. FK to Membership Status
</comment>
50 <label>Membership Status
</label>
55 <name>status_id
</name>
56 <table>civicrm_membership_status
</table>
59 <onDelete>CASCADE
</onDelete>
62 <name>start_date
</name>
63 <title>Membership Log Start Date
</title>
65 <dataPattern>/\d{
4}-?\d{
2}-?\d{
2}/
</dataPattern>
66 <comment>New membership period start date
</comment>
71 <title>Membership Log End Date
</title>
73 <dataPattern>/\d{
4}-?\d{
2}-?\d{
2}/
</dataPattern>
74 <comment>New membership period expiration date.
</comment>
78 <name>modified_id
</name>
79 <title>Modified By Contact ID
</title>
80 <type>int unsigned
</type>
81 <comment>FK to Contact ID of person under whose credentials this data modification was made.
</comment>
83 <label>Modified By
</label>
85 <readonly>true
</readonly>
89 <name>modified_id
</name>
90 <table>civicrm_contact
</table>
93 <onDelete>SET NULL
</onDelete>
96 <name>modified_date
</name>
97 <title>Membership Change Date
</title>
99 <dataPattern>/\d{
4}-?\d{
2}-?\d{
2}/
</dataPattern>
100 <comment>Date this membership modification action was logged.
</comment>
104 <name>membership_type_id
</name>
105 <title>Membership Type ID
</title>
106 <type>int unsigned
</type>
107 <comment>FK to Membership Type.
</comment>
109 <label>Membership Type
</label>
114 <name>membership_type_id
</name>
115 <table>civicrm_membership_type
</table>
118 <onDelete>SET NULL
</onDelete>
121 <name>max_related
</name>
122 <title>Maximum Related Memberships
</title>
124 <comment>Maximum number of related memberships.
</comment>