Schema documentation for component constraint

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element constraint_characteristics

Namespace

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

Diagram

Properties

content

complex

Used by

Elements	assertion_definition, column_constraint_definition, domain_constraint, table_constraint_definition
Element Group	additional_common_elements

Model

constraint_check_time_deferrable | deferrable_constraint_check_time

Children

constraint_check_time_deferrable, deferrable_constraint_check_time

Instance

<constraint_characteristics xmlns="http://www.sqlparser.com/xml/ansi2003">
  <constraint_check_time_deferrable>{1,1}</constraint_check_time_deferrable>
  <deferrable_constraint_check_time>{1,1}</deferrable_constraint_check_time>
</constraint_characteristics>

Source

<xs:element name="constraint_characteristics">
  <xs:complexType>
    <xs:choice>
      <xs:element name="constraint_check_time_deferrable">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="constraint_check_time"/>
            <xs:element name="kw_not_deferrable" minOccurs="0">
              <xs:complexType>
                <xs:sequence>
                  <xs:element ref="kw_not" minOccurs="0"/>
                  <xs:element ref="kw_deferrable"/>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="deferrable_constraint_check_time">
        <xs:complexType>
          <xs:sequence>
            <xs:element name="kw_not_deferrable" minOccurs="0">
              <xs:complexType>
                <xs:sequence>
                  <xs:element ref="kw_not" minOccurs="0"/>
                  <xs:element ref="kw_deferrable"/>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element ref="constraint_check_time" minOccurs="0"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:choice>
  </xs:complexType>
</xs:element>

Element constraint_characteristics / constraint_check_time_deferrable

Namespace

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

Diagram

Properties

content

complex

Model

constraint_check_time , kw_not_deferrable{0,1}

Children

constraint_check_time, kw_not_deferrable

Instance

<constraint_check_time_deferrable xmlns="http://www.sqlparser.com/xml/ansi2003">
  <constraint_check_time>{1,1}</constraint_check_time>
  <kw_not_deferrable>{0,1}</kw_not_deferrable>
</constraint_check_time_deferrable>

Source

<xs:element name="constraint_check_time_deferrable">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="constraint_check_time"/>
      <xs:element name="kw_not_deferrable" minOccurs="0">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_not" minOccurs="0"/>
            <xs:element ref="kw_deferrable"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element constraint_characteristics / constraint_check_time_deferrable / kw_not_deferrable

Namespace

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

Diagram

Properties

content	complex
minOccurs	0

Model

kw_not{0,1} , kw_deferrable

Children

kw_deferrable, kw_not

Instance

<kw_not_deferrable xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_not>{0,1}</kw_not>
  <kw_deferrable>{1,1}</kw_deferrable>
</kw_not_deferrable>

Source

<xs:element name="kw_not_deferrable" minOccurs="0">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_not" minOccurs="0"/>
      <xs:element ref="kw_deferrable"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element constraint_characteristics / deferrable_constraint_check_time

Namespace

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

Diagram

Properties

content

complex

Model

kw_not_deferrable{0,1} , constraint_check_time{0,1}

Children

constraint_check_time, kw_not_deferrable

Instance

<deferrable_constraint_check_time xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_not_deferrable>{0,1}</kw_not_deferrable>
  <constraint_check_time>{0,1}</constraint_check_time>
</deferrable_constraint_check_time>

Source

<xs:element name="deferrable_constraint_check_time">
  <xs:complexType>
    <xs:sequence>
      <xs:element name="kw_not_deferrable" minOccurs="0">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_not" minOccurs="0"/>
            <xs:element ref="kw_deferrable"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element ref="constraint_check_time" minOccurs="0"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element constraint_characteristics / deferrable_constraint_check_time / kw_not_deferrable

Namespace

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

Diagram

Properties

content	complex
minOccurs	0

Model

kw_not{0,1} , kw_deferrable

Children

kw_deferrable, kw_not

Instance

<kw_not_deferrable xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_not>{0,1}</kw_not>
  <kw_deferrable>{1,1}</kw_deferrable>
</kw_not_deferrable>

Source

<xs:element name="kw_not_deferrable" minOccurs="0">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_not" minOccurs="0"/>
      <xs:element ref="kw_deferrable"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>