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   </field>
  36   <field>
  37        <name>entity_table</name>
  38        <type>varchar</type>
  39        <length>64</length>
  40        <required>true</required>
  41        <comment>Name of table where item being referenced is stored.</comment>
  42   </field>
  43   <field>
  44        <name>entity_id</name>
  45        <type>int unsigned</type>
  46        <required>true</required>
  47        <comment>Foreign key to the referenced item.</comment>
  48   </field>
  49   <dynamicForeignKey>
  50        <idColumn>entity_id</idColumn>
  51        <typeColumn>entity_table</typeColumn>
  52   </dynamicForeignKey>
  53   <field>
  54         <name>search_id</name>
  55         <type>int</type>
  56         <comment>The filtering search. custom search id or -1 for civicrm api search</comment>
  57   </field>
  58   <field>
  59         <name>search_args</name>
  60         <type>text</type>
  61         <comment>The arguments to be sent to the search function</comment>
  62   </field>
  63 </table>