Merge pull request #2649 from rocxa/master

[civicrm-core.git] / xml / schema / Mailing / Event / TrackableURLOpen.xml

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

<table>
    <base>CRM/Mailing/Event</base>
    <class>TrackableURLOpen</class>
    <name>civicrm_mailing_event_trackable_url_open</name>
    <comment>Tracks when a TrackableURL is clicked by a recipient.</comment>
    <archive>true</archive>
    <field>
        <name>id</name>
        <type>int unsigned</type>
        <required>true</required>
    </field>
    <primaryKey>
        <name>id</name>
        <autoincrement>true</autoincrement>
    </primaryKey>
    <field>
        <name>event_queue_id</name>
        <type>int unsigned</type>
        <required>true</required>
        <comment>FK to EventQueue</comment>
    </field>
    <foreignKey>
        <name>event_queue_id</name>
        <table>civicrm_mailing_event_queue</table>
        <key>id</key>
        <onDelete>CASCADE</onDelete>
    </foreignKey>
    <field>
        <name>trackable_url_id</name>
        <type>int unsigned</type>
        <required>true</required>
        <comment>FK to TrackableURL</comment>
    </field>
    <foreignKey>
        <name>trackable_url_id</name>
        <table>civicrm_mailing_trackable_url</table>
        <key>id</key>
        <onDelete>CASCADE</onDelete>
    </foreignKey>
    <field>
        <name>time_stamp</name>
        <type>datetime</type>
        <required>true</required>
        <comment>When this trackable URL open occurred.</comment>
    </field>
</table>