Schema documentation for component trigger

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element trigger_event

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content

complex

Used by

Element

trigger_definition

Model

kw_insert | kw_delete | update_of_trigger_column_list

Children

kw_delete, kw_insert, update_of_trigger_column_list

Instance

<trigger_event xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_insert>{1,1}</kw_insert>
  <kw_delete>{1,1}</kw_delete>
  <update_of_trigger_column_list>{1,1}</update_of_trigger_column_list>
</trigger_event>

Source

<xs:element name="trigger_event">
  <xs:complexType>
    <xs:choice>
      <xs:element ref="kw_insert"/>
      <xs:element ref="kw_delete"/>
      <xs:element name="update_of_trigger_column_list">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_update"/>
            <xs:element name="of_trigger_column_list" minOccurs="0">
              <xs:complexType>
                <xs:sequence>
                  <xs:element ref="kw_of"/>
                  <xs:element ref="trigger_column_list"/>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:choice>
  </xs:complexType>
</xs:element>

Element trigger_event / update_of_trigger_column_list

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content

complex

Model

kw_update , of_trigger_column_list{0,1}

Children

kw_update, of_trigger_column_list

Instance

<update_of_trigger_column_list xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_update>{1,1}</kw_update>
  <of_trigger_column_list>{0,1}</of_trigger_column_list>
</update_of_trigger_column_list>

Source

<xs:element name="update_of_trigger_column_list">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_update"/>
      <xs:element name="of_trigger_column_list" minOccurs="0">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_of"/>
            <xs:element ref="trigger_column_list"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element trigger_event / update_of_trigger_column_list / of_trigger_column_list

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content	complex
minOccurs	0

Model

kw_of , trigger_column_list

Children

kw_of, trigger_column_list

Instance

<of_trigger_column_list xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_of>{1,1}</kw_of>
  <trigger_column_list>{1,1}</trigger_column_list>
</of_trigger_column_list>

Source

<xs:element name="of_trigger_column_list" minOccurs="0">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_of"/>
      <xs:element ref="trigger_column_list"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>