[civicrm-core.git] / xml / schema / Mailing / MailingGroup.xml

<?xml version="1.0" encoding="iso-8859-1" ?>

<table>
  <base>CRM/Mailing</base>
  <class>MailingGroup</class>
  <name>civicrm_mailing_group</name>
  <comment>Stores information about the groups that participate in this mailing..</comment>
  <archive>true</archive>
  <component>CiviMail</component>
  <field>
    <name>id</name>
    <title>Mailing Group ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <html>
      <type>Number</type>
    </html>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>mailing_id</name>
    <title>Mailing</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>The ID of a previous mailing to include/exclude recipients.</comment>
  </field>
  <foreignKey>
    <name>mailing_id</name>
    <table>civicrm_mailing</table>
    <key>id</key>
    <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
    <name>group_type</name>
    <title>Mailing Group Type</title>
    <type>varchar</type>
    <length>8</length>
    <comment>Are the members of the group included or excluded?.</comment>
    <pseudoconstant>
      <callback>CRM_Core_SelectValues::getMailingGroupTypes</callback>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>entity_table</name>
    <title>Mailing Group Entity Table</title>
    <type>varchar</type>
    <length>64</length>
    <required>true</required>
    <comment>Name of table where item being referenced is stored.</comment>
    <pseudoconstant>
      <callback>CRM_Mailing_BAO_Mailing::mailingGroupEntityTables</callback>
    </pseudoconstant>
  </field>
  <field>
    <name>entity_id</name>
    <title>Mailing Group Entity</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Foreign key to the referenced item.</comment>
  </field>
  <dynamicForeignKey>
    <idColumn>entity_id</idColumn>
    <typeColumn>entity_table</typeColumn>
  </dynamicForeignKey>
  <field>
    <name>search_id</name>
    <title>Mailing Group Search</title>
    <type>int</type>
    <comment>The filtering search. custom search id or -1 for civicrm api search</comment>
  </field>
  <field>
    <name>search_args</name>
    <title>Mailing Group Search Arguments</title>
    <type>text</type>
    <comment>The arguments to be sent to the search function</comment>
  </field>
</table>
Commit	Line	Data
6a488035 TO	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<base>CRM/Mailing</base>
04124b30	5	<class>MailingGroup</class>
6a488035 TO	6	<name>civicrm_mailing_group</name>
	7	<comment>Stores information about the groups that participate in this mailing..</comment>
	8	<archive>true</archive>
d31fb4e3	9	<component>CiviMail</component>
6a488035	10	<field>
5435b737	11	<name>id</name>
0d94665e	12	<title>Mailing Group ID</title>
5435b737 EM	13	<type>int unsigned</type>
5435b737 EM	14	<required>true</required>
0481e12c A	15	<html>
	16	<type>Number</type>
	17	</html>
6a488035 TO	18	</field>
6a488035 TO	19	<primaryKey>
5435b737 EM	20	<name>id</name>
5435b737 EM	21	<autoincrement>true</autoincrement>
6a488035 TO	22	</primaryKey>
6a488035 TO	23	<field>
5435b737	24	<name>mailing_id</name>
0d94665e	25	<title>Mailing</title>
5435b737 EM	26	<type>int unsigned</type>
	27	<required>true</required>
	28	<comment>The ID of a previous mailing to include/exclude recipients.</comment>
6a488035 TO	29	</field>
6a488035 TO	30	<foreignKey>
5435b737 EM	31	<name>mailing_id</name>
	32	<table>civicrm_mailing</table>
	33	<key>id</key>
	34	<onDelete>CASCADE</onDelete>
6a488035 TO	35	</foreignKey>
6a488035 TO	36	<field>
5435b737	37	<name>group_type</name>
0d94665e	38	<title>Mailing Group Type</title>
5435b737 EM	39	<type>varchar</type>
	40	<length>8</length>
	41	<comment>Are the members of the group included or excluded?.</comment>
	42	<pseudoconstant>
	43	<callback>CRM_Core_SelectValues::getMailingGroupTypes</callback>
	44	</pseudoconstant>
	45	<html>
	46	<type>Select</type>
	47	</html>
6a488035 TO	48	</field>
6a488035 TO	49	<field>
5435b737	50	<name>entity_table</name>
0d94665e	51	<title>Mailing Group Entity Table</title>
5435b737 EM	52	<type>varchar</type>
	53	<length>64</length>
	54	<required>true</required>
	55	<comment>Name of table where item being referenced is stored.</comment>
27307972 SL	56	<pseudoconstant>
	57	<callback>CRM_Mailing_BAO_Mailing::mailingGroupEntityTables</callback>
	58	</pseudoconstant>
6a488035 TO	59	</field>
6a488035 TO	60	<field>
5435b737	61	<name>entity_id</name>
0d94665e	62	<title>Mailing Group Entity</title>
5435b737 EM	63	<type>int unsigned</type>
	64	<required>true</required>
	65	<comment>Foreign key to the referenced item.</comment>
6a488035	66	</field>
71e5aa5c	67	<dynamicForeignKey>
5435b737 EM	68	<idColumn>entity_id</idColumn>
5435b737 EM	69	<typeColumn>entity_table</typeColumn>
71e5aa5c	70	</dynamicForeignKey>
6a488035	71	<field>
5435b737	72	<name>search_id</name>
0d94665e	73	<title>Mailing Group Search</title>
5435b737 EM	74	<type>int</type>
5435b737 EM	75	<comment>The filtering search. custom search id or -1 for civicrm api search</comment>
6a488035 TO	76	</field>
6a488035 TO	77	<field>
5435b737	78	<name>search_args</name>
0d94665e	79	<title>Mailing Group Search Arguments</title>
5435b737 EM	80	<type>text</type>
5435b737 EM	81	<comment>The arguments to be sent to the search function</comment>
6a488035 TO	82	</field>
6a488035 TO	83	</table>