Collections functions
Encryption functions
General functions
Theme permission functions
Resource functions

Table: keyword

A list of keywords used when indexing. With stemming enabled (the default) the stems are stored as well as the full keywords.

ColumnTypeNote
refint(11)Auto incrementing index
keywordvarchar(100)An individual word, used for indexing/searching. When stemming is enabled the word stems are also stored in this table as keywords.
soundexvarchar(50)A Soundex representation of the keyword, used when suggesting searches after zero results - it can show keywords that sound similar and help correct typos.
hit_countint(11)How many times this keyword has been used within resource metadata. Used to sort keywords when suggesting alternatives to the user.

Default contents are as follows.

refkeywordsoundexhit_count
1200000
2my collectionM2420
3joe smithJ2530
4myM0000
5collectionC4230
6joeJ0001
7smithS5301
8womanW5501
9manM50015
10childC4301
11buildingB4351
12vehicleV2401
13animalA5543
14elderlyE4361
15babyB1001
16boyB0001
17girlG6401
18exhibitionE2131
19meetingM3521
20concertC5263
21festivalF2311
22partyP6301
23conferenceC5161
24photoP3008
25shootS3001
26happyH1001
27sadS3001
28inspirationalI5211
29eyeE0003
30contactC5323
31thoughtfulT2311
32familyF5401
33groupG6101
34productP6321
35employeeE5141
36customerC2351
37testT2302
38eye contactE2532
39201600002
402016-0600002
412016-06-16 10:5600002
421700000
43300000
44upload 20160616105637U1430
45uploadU1430
462016061610563700000
47montalaM5341
48supportS1631
49100001
50posterP2361
51pngP5201
520
53fundraisingF5361
54!last1000L2300
55afghanistanA12514
56alandA45314
57islandI245386
58albaniaA41514
59algeriaA42614
60americanA56214
61samoaS50028
62andorraA53614
63angolaA52414
64anguillaA52414
65antarcticaA53614
66antiguaA53214
67barbudaB61314
68argentinaA62514
69armeniaA65514
70arubaA61014
71australiaA23614
72austriaA23614
73azerbaijanA26114
74bahamaB50022
75bahrainB65014
76bangladeshB52414
77barbadoB61322
78belaruB46022
79belgiumB42514
80belizB42022
81beninB55014
82bermudaB65314
83bhutanB35014
84boliviaB41014
85bosniaB25014
86herzegovinaH62214
87botswanaB32514
88bouvetB13014
89brazilB62414
90britishB63228
91indianI53514
92oceanO25014
93territoriT63666
94bruneiB65014
95darussalamD62414
96bulgariaB42614
97burkinaB62514
98fasoF20014
99burundiB65314
100cambodiaC51314
101cameroonC56514
102canadaC53014
103capeC10014
104verdV63022
105caymanC55014
106centralC53614
107africanA16214
108republR114286
109chadC30014
110chileC40014
111chinaC50028
112christmaC62322
113cocoC20022
114keelK40022
115colombiaC45114
116comoroC56022
117congoC52028
118democratD52666
119cookC20014
120costaC23014
121ricaR20014
122côteC30014
123dD00014
124ivoirI16022
125croatiaC63014
126cubaC10014
127cypruC16022
128czechC20014
129denmarkD56214
130djiboutiD21314
131dominicaD55214
132dominicanD55214
133ecuadorE23614
134egyptE21314
135elE40014
136salvadorS41314
137equatoriE23622
138guineaG50056
139eritreaE63614
140estoniaE23514
141ethiopiaE31014
142falklandF42414
143malvinaM41522
144faroF60022
145fijiF20014
146finlandF54514
147francF65222
148frenchF65242
149guianaG50014
150polynesiaP45214
151southernS36514
152gabonG15014
153gambiaG51014
154georgiaG62028
155germaniG65522
156ghanaG50014
157gibraltarG16414
158greecG62022
159greenlandG65414
160grenadaG65314
161guadeloupG34122
162guamG50014
163guatemalaG35414
164guernseiG65222
165bissauB20014
166guyanaG50014
167haitiH30014
168heardH63014
169mcdonaldM23514
170holiH40022
171seeS00014
172vaticanV32514
173citiC30022
174stateS33080
175honduraH53622
176hongH52014
177kongK52014
178hungariH52622
179icelandI24514
180indiaI53014
181indonesiaI53514
182iranI65014
183islamI24522
184iraqI62014
185irelandI64514
186islI24022
187israelI26414
188italiI34022
189jamaicaJ52014
190japanJ15014
191jerseiJ62022
192jordanJ63514
193kazakhstanK22214
194kenyaK50014
195kiribatiK61314
196koreaK60028
197peoplP14044
198sS00042
199kuwaitK30014
200kyrgyzstanK62214
201laoL00014
202latviaL31014
203lebanonL15514
204lesothoL23014
205liberiaL16014
206libyanL15014
207arabA61042
208jamahiriyaJ56014
209liechtensteinL23514
210lithuaniaL35014
211luxembourgL25114
212macaoM20014
213macedoniaM23514
214formerF65614
215yugoslavY22414
216madagascarM32214
217malawiM40014
218malaysiaM42014
219maldivM43122
220maliM40014
221maltaM43014
222marshalM62422
223martiniquM63522
224mauritaniaM63514
225mauritiuM63022
226mayottM30022
227mexicoM22014
228micronesiaM26514
229federF36044
230moldovaM43114
231monacoM52014
232mongoliaM52414
233montenegroM53514
234montserratM53214
235moroccoM62014
236mozambiquM25122
237myanmarM56014
238namibiaN51014
239nauruN60014
240nepalN14014
241netherlandN36444
242antilA53422
243newN00042
244caledoniaC43514
245zealandZ45314
246nicaraguaN26214
247nigerN26014
248nigeriaN26014
249niueN00014
250norfolkN61414
251northernN63614
252marianaM65014
253norwaiN60022
254omanO55014
255pakistanP22314
256palauP40014
257palestinianP42314
258occupiO21022
259panamaP55014
260papuaP10014
261paraguaiP62022
262peruP60014
263philippinP41522
264pitcairnP32614
265polandP45314
266portugP63222
267puertoP63014
268ricoR20014
269qatarQ36014
270réunionR55014
271romaniaR55014
272russianR25014
273rwandaR53014
274saintS53098
275barthélemiB63422
276helenaH45014
277kittK30022
278neviN10022
279luciaL20014
280martinM63514
281pierrP60022
282miquelonM24514
283vincentV52514
284grenadinG65322
285sanS50014
286marinoM65014
287saoS00014
288tomeT50014
289principP65222
290saudiS30014
291arabiaA61014
292senegS52022
293serbiaS61014
294seychelS24022
295sierraS60014
296leonL50022
297singaporS52122
298slovakiaS41214
299sloveniaS41514
300solomonS45514
301somaliaS54014
302southS30042
303africaA16214
304sandwichS53214
305spainS15014
306sriS60014
307lankaL52014
308sudanS35014
309surinamS65522
310svalbardS14114
311janJ50014
312mayenM50014
313swazilandS24514
314swedenS35014
315switzerlandS32614
316syrianS65014
317taiwanT50014
318provincP61522
319tajikistanT22214
320tanzaniaT52514
321unitU530110
322thailandT45314
323timorT56014
324lestL23022
325togoT20014
326tokelauT24014
327tongaT52014
328trinidadT65314
329tobagoT12014
330tunisiaT52014
331turkeiT62022
332turkmenistanT62514
333turkT62022
334caicoC20022
335tuvaluT14014
336ugandaU25314
337ukrainU26522
338emirE56022
339kingdomK52314
340minorM56014
341outliO34022
342uruguaiU62022
343uzbekistanU21214
344vanuatuV53014
345venezuelaV52414
346bolivarianB41614
347vietV30014
348namN50014
349virginV62528
350uU00014
351walliW40022
352futunaF35014
353westernW23614
354saharaS60014
355yemenY55014
356zambiaZ51014
357zimbabwZ51122
358digitD2302
359cameraC5602
360scanS5004
361negN2002
362islandsI24515
363bahamasB5201
364barbadosB6131
365belarusB4621
366belizeB4201
367territoryT6362
368verdeV6301
369republicR11413
370christmasC6231
371cocosC2201
372keelingK4521
373comorosC5621
374democraticD5263
375ivoireI1601
376cyprusC1621
377equatorialE2361
378malvinasM4151
379faroeF6001
380franceF6521
381territoriesT6361
382germanyG6551
383greeceG6201
384guadeloupeG3411
385guernseyG6521
386holyH4001
387cityC3001
388hondurasH5361
389hungaryH5261
390islamicI2451
391isleI2401
392italyI3401
393jerseyJ6201
394peopleP1402
395maldivesM4311
396marshallM6241
397martiniqueM6351
398mauritiusM6321
399mayotteM3001
400federatedF3631
401statesS3323
402mozambiqueM2511
403netherlandsN3642
404antillesA5341
405norwayN6001
406occupiedO2131
407paraguayP6201
408philippinesP4151
409portugalP6321
410federationF3631
411barthélemyB6341
412kittsK3201
413nevisN1201
414pierreP6001
415grenadinesG6531
416principeP6521
417senegalS5241
418seychellesS2421
419leoneL5001
420singaporeS5211
421surinameS6551
422provinceP6151
423unitedU5335
424lesteL2301
425turkeyT6201
426turksT6201
427caicosC2201
428ukraineU2651
429emiratesE5631
430outlyingO3451
431uruguayU6201
432wallisW4201
433zimbabweZ5111

Please see the schema overview for context. This document was last updated on the 5th of July 2020 at 05:05 (Europe/London time).