xml/schema/Mailing/MailingGroup.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Mailing</base>
   5   <class>MailingGroup</class>
   6   <name>civicrm_mailing_group</name>
   7   <comment>Stores information about the groups that participate in this mailing..</comment>
   8   <archive>true</archive>
   9   <field>
  10       <name>id</name>
  11       <type>int unsigned</type>
  12       <required>true</required>
  13   </field>
  14   <primaryKey>
  15        <name>id</name>
  16        <autoincrement>true</autoincrement>
  17   </primaryKey>
  18   <field>
  19       <name>mailing_id</name>
  20       <type>int unsigned</type>
  21       <required>true</required>
  22       <comment>The ID of a previous mailing to include/exclude recipients.</comment>
  23   </field>
  24   <foreignKey>
  25        <name>mailing_id</name>
  26        <table>civicrm_mailing</table>
  27        <key>id</key>
  28        <onDelete>CASCADE</onDelete>
  29   </foreignKey>
  30   <field>
  31        <name>group_type</name>
  32        <type>enum</type>
  33        <values>Include, Exclude, Base</values>
  34        <comment>Are the members of the group included or excluded?.</comment>
  35        <html>
  36          <type>Select</type>
  37        </html>
  38   </field>
  39   <field>
  40        <name>entity_table</name>
  41        <type>varchar</type>
  42        <length>64</length>
  43        <required>true</required>
  44        <comment>Name of table where item being referenced is stored.</comment>
  45   </field>
  46   <field>
  47        <name>entity_id</name>
  48        <type>int unsigned</type>
  49        <required>true</required>
  50        <comment>Foreign key to the referenced item.</comment>
  51   </field>
  52   <dynamicForeignKey>
  53        <idColumn>entity_id</idColumn>
  54        <typeColumn>entity_table</typeColumn>
  55   </dynamicForeignKey>
  56   <field>
  57         <name>search_id</name>
  58         <type>int</type>
  59         <comment>The filtering search. custom search id or -1 for civicrm api search</comment>
  60   </field>
  61   <field>
  62         <name>search_args</name>
  63         <type>text</type>
  64         <comment>The arguments to be sent to the search function</comment>
  65   </field>
  66 </table>