1 CREATE UNIQUE INDEX ON Allele(allele)
\r
3 CREATE INDEX ON Allele(rev_allele_id)
\r
7 CREATE INDEX ON AlleleMotif(motif_id)
\r
10 CREATE UNIQUE INDEX ON AllocIds(name)
\r
13 CREATE INDEX ON Author(author)
\r
16 CREATE UNIQUE INDEX ON Batch_tax_id(batch_id)
\r
24 CREATE INDEX ON GtyAllele(unigty_id)
\r
26 CREATE INDEX ON GtyAllele(gty_id)
\r
28 CREATE INDEX ON GtyAllele(gty_id)
\r
32 CREATE INDEX ON LoadHistory(loaddate)
\r
37 CREATE UNIQUE INDEX ON Method(handle, loc_method_id)
\r
43 CREATE UNIQUE INDEX ON Motif(motif)
\r
46 CREATE INDEX ON ObsGenotype(obs)
\r
48 CREATE INDEX ON ObsGenotype(obs_upp_fix)
\r
50 CREATE INDEX ON ObsGenotype(gty_id)
\r
53 CREATE UNIQUE INDEX ON ObsVariation(pattern)
\r
55 CREATE INDEX ON ObsVariation(univar_id)
\r
59 CREATE UNIQUE INDEX ON OrganismTax(organism)
\r
61 CREATE INDEX ON OrganismTax(tax_id)
\r
63 CREATE INDEX ON OrganismTax(species_tax_id)
\r
65 CREATE INDEX ON OrganismTax(database_name)
\r
70 CREATE UNIQUE INDEX ON Publication(handle, title)
\r
74 CREATE INDEX ON SNP_tax_id(tax_id, snp_id)
\r
80 CREATE UNIQUE INDEX ON SnpValidationCode(code)
\r
83 CREATE INDEX ON StrandCode(abbrev, rs_to_ss_orien, code)
\r
86 CREATE UNIQUE INDEX ON SubSNPDelComm(comment_id)
\r
90 CREATE UNIQUE INDEX ON Submitter(handle)
\r
92 CREATE INDEX ON Submitter(name)
\r
96 CREATE UNIQUE INDEX ON UniGty(gty_str)
\r
98 CREATE UNIQUE INDEX ON UniGty(allele_id_1, allele_id_2)
\r
100 CREATE INDEX ON UniGty(allele_id_2)
\r
103 CREATE INDEX ON UniVariAllele(allele_id)
\r
106 CREATE UNIQUE INDEX ON UniVariation(var_str)
\r
108 CREATE INDEX ON UniVariation(univar_id, subsnp_class)
\r
112 CREATE INDEX ON VariAllele(allele_id)
\r
123 CREATE UNIQUE INDEX ON dn_gty2unigty_trueSNP(gty_id, rev_flag)
\r