xml/schema/Member/MembershipStatus.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Member</base>
   5   <class>MembershipStatus</class>
   6   <name>civicrm_membership_status</name>
   7   <comment>Membership Status stores admin configurable rules for assigning status to memberships.</comment>
   8   <add>1.5</add>
   9   <log>true</log>
  10   <field>
  11       <name>id</name>
  12       <type>int unsigned</type>
  13       <required>true</required>
  14       <comment>Membership Id</comment>
  15       <add>1.5</add>
  16   </field>
  17   <primaryKey>
  18        <name>id</name>
  19        <autoincrement>true</autoincrement>
  20   </primaryKey>
  21   <field>
  22        <name>name</name>
  23        <uniqueName>membership_status</uniqueName>
  24        <title>Membership Status</title>
  25        <type>varchar</type>
  26        <import>true</import>
  27        <length>128</length>
  28        <comment>Name for Membership Status</comment>
  29        <add>1.5</add>
  30   </field>
  31   <field>
  32        <name>label</name>
  33        <type>varchar</type>
  34        <length>128</length>
  35        <localizable>true</localizable>
  36        <comment>Label for Membership Status</comment>
  37        <add>3.2</add>
  38   </field>
  39   <field>
  40        <name>start_event</name>
  41        <type>varchar</type>
  42        <length>12</length>
  43        <comment>Event when this status starts.</comment>
  44        <pseudoconstant>
  45          <callback>CRM_Core_SelectValues::eventDate</callback>
  46        </pseudoconstant>
  47        <add>1.5</add>
  48        <html>
  49          <type>Select</type>
  50        </html>
  51   </field>
  52   <field>
  53       <name>start_event_adjust_unit</name>
  54       <type>varchar</type>
  55       <length>8</length>
  56       <comment>Unit used for adjusting from start_event.</comment>
  57       <pseudoconstant>
  58         <callback>CRM_Core_SelectValues::unitList</callback>
  59       </pseudoconstant>
  60       <add>1.5</add>
  61       <html>
  62         <type>Select</type>
  63       </html>
  64   </field>
  65   <field>
  66       <name>start_event_adjust_interval</name>
  67       <type>int</type>
  68       <comment>Status range begins this many units from start_event.</comment>
  69       <add>1.5</add>
  70   </field>
  71   <field>
  72       <name>end_event</name>
  73       <type>varchar</type>
  74       <length>12</length>
  75       <comment>Event after which this status ends.</comment>
  76       <pseudoconstant>
  77         <callback>CRM_Core_SelectValues::eventDate</callback>
  78       </pseudoconstant>
  79       <add>1.5</add>
  80       <html>
  81         <type>Select</type>
  82       </html>
  83   </field>
  84   <field>
  85       <name>end_event_adjust_unit</name>
  86       <type>varchar</type>
  87       <length>8</length>
  88       <comment>Unit used for adjusting from the ending event.</comment>
  89       <pseudoconstant>
  90         <callback>CRM_Core_SelectValues::unitList</callback>
  91       </pseudoconstant>
  92       <add>1.5</add>
  93       <html>
  94         <type>Select</type>
  95       </html>
  96   </field>
  97  <field>
  98       <name>end_event_adjust_interval</name>
  99       <type>int</type>
 100       <comment>Status range ends this many units from end_event.</comment>
 101       <add>1.5</add>
 102   </field>
 103   <field>
 104       <name>is_current_member</name>
 105       <title>Current Membership?</title>
 106       <type>boolean</type>
 107       <comment>Does this status aggregate to current members (e.g. New, Renewed, Grace might all be TRUE... while Unrenewed, Lapsed, Inactive would be FALSE).</comment>
 108       <add>1.5</add>
 109   </field>
 110   <field>
 111       <name>is_admin</name>
 112       <title>Admin Assigned Only?</title>
 113       <type>boolean</type>
 114       <comment>Is this status for admin/manual assignment only.</comment>
 115       <add>1.5</add>
 116   </field>
 117   <field>
 118       <name>weight</name>
 119       <title>Weight</title>
 120       <type>int</type>
 121       <add>1.5</add>
 122   </field>
 123   <field>
 124       <name>is_default</name>
 125       <title>Default Status?</title>
 126       <type>boolean</type>
 127       <comment>Assign this status to a membership record if no other status match is found.</comment>
 128       <add>1.5</add>
 129   </field>
 130   <field>
 131       <name>is_active</name>
 132       <title>Is Active</title>
 133       <type>boolean</type>
 134       <default>1</default>
 135       <comment>Is this membership_status enabled.</comment>
 136       <add>1.5</add>
 137   </field>
 138  <field>
 139       <name>is_reserved</name>
 140       <title>Is Reserved</title>
 141       <type>boolean</type>
 142       <default>0</default>
 143       <comment>Is this membership_status reserved.</comment>
 144       <add>2.1</add>
 145   </field>
 146 </table>