Sample of part of DOML file for using indexes

The following snippet shows part of a DOML file, Computers.doml (creates tables containing data about computers and their parts).

<table id="firm.computers.hardware.parts.motherboard"  dbTableName="Motherboard">
              <column id="manufacturrer" generateSecure="false"  generateInsecure="false">
                 <type canBeNull="false" dbType="CHAR" javaType="String" size="40"/>
              </column>
              <column id="type" generateSecure="false">
                 <type dbType="CHAR" javaType="String" size="40"/>
              </column>
              <column id="chipSet" generateSecure="false">
                 <type dbType="CHAR" javaType="String" size="40"/>
              </column>
              <column id="compName" generateSecure="false">
                 <referenceObject constraint="true" reference="firm.computers.hardware.Computers" />
                 <type dbType="none" javaType="firm.computers.hardware.ComputersDO"/>
              </column>
              <column id="integratedGraphicAdapter">
                 <type dbType="BIT" javaType="boolean"/>
              </column>
              <column id="integratedModem" >
                 <type dbType="BIT" javaType="boolean"/>
              </column>
              <column id="integratedNetworkKard">
                 <type dbType="BIT" javaType="boolean"/>
              </column>
              <column id="integratedMusicKard">
                 <type dbType="BIT" javaType="boolean"/>
              </column>
<!-- Each computer has only one motherboard. (There are all common computers.) -->
            <index id="computerName" unique="true">
               <indexColumn id="compName"/>
            </index>
</table>
. . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . .
<table id="firm.computers.hardware.parts.monitor" dbTableName="Monitor">
              <column id="manufacturrer">
                 <type canBeNull="false" dbType="CHAR" javaType="String" size="40"/>
              </column>
              <column id="type" >
                 <type dbType="CHAR" javaType="String" size="40"/>
              </column>
              <column id="maxResolution">
                 <type canBeNull="true" dbType="CHAR" javaType="String" size="20"/>
              </column>
              <column id="refreshFrequency" >
                 <type canBeNull="true" dbType="INTEGER" javaType="int"/>
              </column>
              <column id="compName" >
                 <referenceObject constraint="true" reference="firm.computers.hardware.Computers"/>
                 <type dbType="none" javaType="firm.computers.hardware.ComputersDO"/>
              </column>
<!-- Each computer has only one monitor. (There are all common computers.) -->
            <index id="computerName" unique="true">
               <indexColumn id="compName"/>
            </index>
</table>

The whole DOML file Computers.doml in <dods_home>/examples/doml_examples directory.