[civicrm-core.git] / xml / schema / Event / ParticipantStatusType.xml

<?xml version="1.0" encoding="utf-8" ?>
<table>
  <base>CRM/Event</base>
  <class>ParticipantStatusType</class>
  <name>civicrm_participant_status_type</name>
  <comment>various types of CiviEvent participant statuses</comment>
  <add>3.0</add>
  <log>true</log>
  <component>CiviEvent</component>
  <field>
    <name>id</name>
    <title>Participant Status Type ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>unique participant status type id</comment>
    <html>
      <type>Number</type>
    </html>
    <add>3.0</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>name</name>
    <uniqueName>participant_status</uniqueName>
    <title>Participant Status</title>
    <type>varchar</type>
    <length>64</length>
    <import>true</import>
    <unique>true</unique>
    <comment>non-localized name of the status type</comment>
    <add>3.0</add>
  </field>
  <field>
    <name>label</name>
    <title>Participant Status Label</title>
    <type>varchar</type>
    <length>255</length>
    <unique>true</unique>
    <localizable>true</localizable>
    <comment>localized label for display of this status type</comment>
    <add>3.0</add>
  </field>
  <field>
    <name>class</name>
    <title>Participant Status Class</title>
    <type>varchar</type>
    <length>8</length>
    <comment>the general group of status type this one belongs to</comment>
    <pseudoconstant>
      <callback>CRM_Event_PseudoConstant::participantStatusClassOptions</callback>
    </pseudoconstant>
    <add>3.0</add>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>is_reserved</name>
    <title>Participant Status Is Reserved?></title>
    <type>boolean</type>
    <comment>whether this is a status type required by the system</comment>
    <default>0</default>
    <required>true</required>
    <add>3.0</add>
  </field>
  <field>
    <name>is_active</name>
    <title>Participant Status is Active</title>
    <type>boolean</type>
    <default>1</default>
    <comment>whether this status type is active</comment>
    <default>0</default>
    <required>true</required>
    <add>3.0</add>
  </field>
  <field>
    <name>is_counted</name>
    <title>Participant Status Counts?</title>
    <type>boolean</type>
    <comment>whether this status type is counted against event size limit</comment>
    <default>0</default>
    <required>true</required>
    <add>3.0</add>
  </field>
  <field>
    <name>weight</name>
    <title>Order</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>controls sort order</comment>
    <add>3.0</add>
  </field>
  <field>
    <name>visibility_id</name>
    <title>Participant Status Visibility</title>
    <type>int unsigned</type>
    <comment>whether the status type is visible to the public, an implicit foreign key to option_value.value related to the `visibility` option_group</comment>
    <add>3.0</add>
    <pseudoconstant>
      <optionGroupName>visibility</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
</table>
Commit	Line	Data
6a488035 TO	1	<?xml version="1.0" encoding="utf-8" ?>
	2	<table>
	3	<base>CRM/Event</base>
	4	<class>ParticipantStatusType</class>
	5	<name>civicrm_participant_status_type</name>
	6	<comment>various types of CiviEvent participant statuses</comment>
	7	<add>3.0</add>
	8	<log>true</log>
d31fb4e3	9	<component>CiviEvent</component>
6a488035 TO	10	<field>
6a488035 TO	11	<name>id</name>
0d94665e	12	<title>Participant Status Type ID</title>
6a488035 TO	13	<type>int unsigned</type>
	14	<required>true</required>
	15	<comment>unique participant status type id</comment>
0481e12c A	16	<html>
	17	<type>Number</type>
	18	</html>
6a488035 TO	19	<add>3.0</add>
	20	</field>
	21	<primaryKey>
	22	<name>id</name>
	23	<autoincrement>true</autoincrement>
	24	</primaryKey>
	25	<field>
	26	<name>name</name>
	27	<uniqueName>participant_status</uniqueName>
	28	<title>Participant Status</title>
	29	<type>varchar</type>
	30	<length>64</length>
	31	<import>true</import>
	32	<unique>true</unique>
	33	<comment>non-localized name of the status type</comment>
	34	<add>3.0</add>
	35	</field>
	36	<field>
	37	<name>label</name>
0d94665e	38	<title>Participant Status Label</title>
6a488035 TO	39	<type>varchar</type>
	40	<length>255</length>
	41	<unique>true</unique>
	42	<localizable>true</localizable>
	43	<comment>localized label for display of this status type</comment>
	44	<add>3.0</add>
	45	</field>
	46	<field>
	47	<name>class</name>
0d94665e	48	<title>Participant Status Class</title>
909ca5f6	49	<type>varchar</type>
909ca5f6	50	<length>8</length>
6a488035	51	<comment>the general group of status type this one belongs to</comment>
71a707c3	52	<pseudoconstant>
84403e23	53	<callback>CRM_Event_PseudoConstant::participantStatusClassOptions</callback>
71a707c3	54	</pseudoconstant>
6a488035	55	<add>3.0</add>
614d72ec	56	<html>
	57	<type>Select</type>
	58	</html>
6a488035 TO	59	</field>
	60	<field>
	61	<name>is_reserved</name>
0d94665e	62	<title>Participant Status Is Reserved?></title>
6a488035 TO	63	<type>boolean</type>
6a488035 TO	64	<comment>whether this is a status type required by the system</comment>
c1e814c7 MD	65	<default>0</default>
c1e814c7 MD	66	<required>true</required>
6a488035 TO	67	<add>3.0</add>
	68	</field>
	69	<field>
	70	<name>is_active</name>
0d94665e	71	<title>Participant Status is Active</title>
6a488035 TO	72	<type>boolean</type>
	73	<default>1</default>
	74	<comment>whether this status type is active</comment>
c1e814c7 MD	75	<default>0</default>
c1e814c7 MD	76	<required>true</required>
6a488035 TO	77	<add>3.0</add>
	78	</field>
	79	<field>
	80	<name>is_counted</name>
0d94665e	81	<title>Participant Status Counts?</title>
6a488035 TO	82	<type>boolean</type>
6a488035 TO	83	<comment>whether this status type is counted against event size limit</comment>
c1e814c7 MD	84	<default>0</default>
c1e814c7 MD	85	<required>true</required>
6a488035 TO	86	<add>3.0</add>
	87	</field>
	88	<field>
	89	<name>weight</name>
7ecddde4	90	<title>Order</title>
6a488035 TO	91	<type>int unsigned</type>
	92	<required>true</required>
	93	<comment>controls sort order</comment>
	94	<add>3.0</add>
	95	</field>
	96	<field>
	97	<name>visibility_id</name>
0d94665e	98	<title>Participant Status Visibility</title>
6a488035 TO	99	<type>int unsigned</type>
	100	<comment>whether the status type is visible to the public, an implicit foreign key to option_value.value related to the `visibility` option_group</comment>
	101	<add>3.0</add>
4080e473 AS	102	<pseudoconstant>
	103	<optionGroupName>visibility</optionGroupName>
	104	</pseudoconstant>
614d72ec	105	<html>
e0991796	106	<type>Select</type>
614d72ec	107	</html>
6a488035 TO	108	</field>
6a488035 TO	109	</table>