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>varchar</type>
  33        <length>8</length>
  34        <comment>Are the members of the group included or excluded?.</comment>
  35        <pseudoconstant>
  36          <callback>CRM_Core_SelectValues::getMailingGroupTypes</callback>
  37        </pseudoconstant>
  38        <html>
  39          <type>Select</type>
  40        </html>
  41   </field>
  42   <field>
  43        <name>entity_table</name>
  44        <type>varchar</type>
  45        <length>64</length>
  46        <required>true</required>
  47        <comment>Name of table where item being referenced is stored.</comment>
  48   </field>
  49   <field>
  50        <name>entity_id</name>
  51        <type>int unsigned</type>
  52        <required>true</required>
  53        <comment>Foreign key to the referenced item.</comment>
  54   </field>
  55   <dynamicForeignKey>
  56        <idColumn>entity_id</idColumn>
  57        <typeColumn>entity_table</typeColumn>
  58   </dynamicForeignKey>
  59   <field>
  60         <name>search_id</name>
  61         <type>int</type>
  62         <comment>The filtering search. custom search id or -1 for civicrm api search</comment>
  63   </field>
  64   <field>
  65         <name>search_args</name>
  66         <type>text</type>
  67         <comment>The arguments to be sent to the search function</comment>
  68   </field>
  69 </table>