AMETHYST INDEXES

[Belinda Frick]

IDX_DATA_CHECKSUM INDEX ON AMTDATA(AMTCHECKSUM)
IDX_DATA_DESTINATION INDEX ON AMTDATA(AMTDESTINATION)
IDX_DATA_DIRECTION INDEX ON AMTDATA(AMTDIRECTION)
IDX_DATA_DURATION INDEX ON AMTDATA(AMTDURATION)
IDX_DATA_EXTENSION INDEX ON AMTDATA(AMTEXTENSION)
IDX_DATA_NUMBER INDEX ON AMTDATA(AMTNUMBER)
IDX_DATA_RECORDING INDEX ON AMTDATA(AMTRECORDING)
IDX_DATA_REFERENCE INDEX ON AMTDATA(AMTREFERENCE)
IDX_DATA_SHORTNORE INDEX ON AMTDATA(AMTSHORTNOTE)
IDX_DATA_USERNAME INDEX ON AMTDATA(AMTUSERNAME)
IDX_DATA_WHEN INDEX ON AMTDATA(AMTWHEN)
RDB$PRIMARY1 UNIQUE INDEX ON AMTDATA(AMTUSERIP, AMTWHEN, AMTRECORDING)
IDX_DETAIL_RECORDING INDEX ON AMTDETAIL(AMTRECORDING)
RDB$PRIMARY2 UNIQUE INDEX ON AMTDETAIL(AMTRECORDING, AMTTIMESTAMP, AMTTYPE)
IDX_REVIEW INDEX ON AMTREVIEWS(AMTSTATIONUSER, AMTREVIEWDATE)
RDB$PRIMARY3 UNIQUE INDEX ON AMTREVIEWS(AMTRECORDING, AMTTEMPLATE, AMTCATEGORY, AMTSEQUENCENO)
RDB$PRIMARY4 UNIQUE INDEX ON AMTSTATUS(AMTCOMPUTERNAME)
RDB$PRIMARY5 UNIQUE INDEX ON AMTSUPDETAIL(AMTSUPERNAME, AMTRECORDING, AMTTIMESTAMP, AMTTYPE)
RDB$PRIMARY6 UNIQUE INDEX ON AMTSUPER(AMTSUPERNAME)
RDB$PRIMARY7 UNIQUE INDEX ON AMTTEMPLATES(AMTTEMPLATE, AMTCATEGORY, AMTSEQUENCENO)
RDB$PRIMARY8 UNIQUE INDEX ON AMTUSERS(AMTUSER)