<title>Participant ID</title>
<type>int unsigned</type>
<required>true</required>
- <comment>Participant Id</comment>
+ <comment>Participant ID</comment>
<import>true</import>
<headerPattern>/(^(participant(.)?)?id$)/i</headerPattern>
+ <html>
+ <type>Number</type>
+ </html>
<add>1.7</add>
</field>
<primaryKey>
<import>true</import>
<required>true</required>
<comment>FK to Contact ID</comment>
+ <html>
+ <label>Contact</label>
+ </html>
<add>1.7</add>
</field>
<foreignKey>
<field>
<name>event_id</name>
<type>int unsigned</type>
- <title>Event</title>
+ <title>Event ID</title>
<import>true</import>
<headerPattern>/event id$/i</headerPattern>
<required>true</required>
<comment>FK to Event ID</comment>
+ <html>
+ <label>Event</label>
+ </html>
<add>1.7</add>
</field>
<foreignKey>
<field>
<name>status_id</name>
<uniqueName>participant_status_id</uniqueName>
- <title>Participant Status</title>
+ <title>Status ID</title>
<headerPattern>/(participant.)?(status)$/i</headerPattern>
<import>true</import>
<type>int unsigned</type>
</pseudoconstant>
<html>
<type>Select</type>
+ <label>Status</label>
</html>
</field>
<foreignKey>
<name>registered_by_id</name>
<uniqueName>participant_registered_by_id</uniqueName>
<type>int unsigned</type>
- <title>Registered By ID</title>
+ <title>Registered By Participant ID</title>
<import>true</import>
<default>NULL</default>
<comment>FK to Participant ID</comment>
+ <html>
+ <label>Registered By</label>
+ </html>
<add>2.1</add>
<export>true</export>
</field>
<title>Discount ID</title>
<default>NULL</default>
<comment>FK to Discount ID</comment>
+ <html>
+ <label>Discount</label>
+ </html>
<add>2.1</add>
</field>
<foreignKey>
<name>campaign_id</name>
<uniqueName>participant_campaign_id</uniqueName>
<type>int unsigned</type>
- <title>Campaign</title>
+ <title>Campaign ID</title>
<import>true</import>
<comment>The campaign for which this participant has been registered.</comment>
- <pseudoconstant>
- <table>civicrm_campaign</table>
- <keyColumn>id</keyColumn>
- <labelColumn>title</labelColumn>
- </pseudoconstant>
+ <html>
+ <type>EntityRef</type>
+ <label>Campaign</label>
+ </html>
<add>3.4</add>
</field>
<foreignKey>
<type>int unsigned</type>
<title>Event Cart ID</title>
<comment>FK to civicrm_event_carts</comment>
+ <html>
+ <label>Event Cart</label>
+ </html>
<add>4.1</add>
</field>
<foreignKey>
<headerPattern>/transfer(.?id)?/i</headerPattern>
<import>true</import>
<comment>FK to Contact ID</comment>
+ <html>
+ <label>Transferred to</label>
+ </html>
<add>4.7</add>
</field>
<foreignKey>