Collections functions
Encryption functions
General functions
Theme permission functions
Resource functions

Table: node_keyword

Keyword nodes are indexed - broken down into single word keywords.

ColumnTypeNote
nodeint(11)See table node
keywordint(11)See table keyword
positionint(11)The position within the node string, e.g. node "red cat", keyword "cat" would be in the second position. Used for quoted searching.

Default contents are as follows.

nodekeywordposition
25080
25190
252100
253110
254120
255130
256140
257150
258160
259170
260180
261190
262200
263210
264220
265230
266240
266251
267260
268270
269280
270290
270301
271310
272320
273330
274340
275350
276360
277530
1550
2560
23621
2571
3580
4590
5600
5611
6620
7630
8640
9650
10660
10672
11680
12690
13700
14710
15720
16730
173630
17740
18750
19760
203640
20770
213650
21780
22790
233660
23800
24810
25820
26830
27840
28850
28862
29870
30880
30571
31890
32900
32911
32922
323673
32933
33940
33951
34960
35970
35981
36990
371000
381010
391020
401030
403681
401041
411050
413621
41571
421060
421071
423692
421082
431090
441100
451110
463700
461120
46571
473710
471130
473721
471141
473622
47572
481150
493730
491160
501170
511170
513742
511182
513693
511083
521190
523621
52571
531200
531211
541220
541231
543752
541242
551250
561260
573760
571270
581280
583691
581081
591290
601300
611310
621320
623691
621081
631330
641340
651350
651361
663770
661370
661381
671390
681400
691410
701420
703621
70571
703782
701432
713790
711440
713621
71571
721450
731460
743800
741470
751480
751491
761480
761501
771480
771511
773812
77932
781520
791530
801540
813820
811550
821560
831570
843830
841580
851590
861600
873840
871610
881620
891630
903850
901640
911380
921380
921651
931660
941670
951680
95571
951693
953624
95574
963860
961700
961711
961722
963873
961733
961744
973880
971750
981760
981771
993890
991780
1001790
1011800
1021810
1031820
1033901
1031831
1033692
1031082
1041840
1051850
1063910
1061860
10692
1071870
1083920
1081880
1091890
1101900
1113930
1111910
1121920
1131930
1141940
1151950
1161960
1163741
1161181
1163942
1161972
1161983
1163694
1161084
1171960
1173691
1171081
1181990
1192000
1202010
1203941
1201971
1201982
1203743
1201183
1203694
1201084
1212020
1222030
1232040
1242050
1252060
1252071
1252082
1262090
1272100
1282110
1292120
1302130
1302142
1302153
1303694
1301084
1312160
1322170
1332180
1343950
1342190
1352200
1362210
1373960
1372220
1373621
137571
1383970
1382230
1392240
1403980
1402250
1413990
1412260
1422270
1432280
1434001
1432291
1434012
1431742
1442300
1443691
1441081
1452310
1462320
1472330
1482340
1492350
1504020
1502360
1512370
1522380
1532390
1542400
1554030
1552410
1564030
1562410
1564041
1562421
1572430
1572441
1582430
1582451
1592460
1602470
1612480
1622490
1632500
163571
1642510
1642521
1643622
164572
1654050
1652530
1662540
1672550
1682560
1692570
1693671
169931
1694062
1692582
1702590
1712600
1712431
1711382
1724070
1722610
1732620
1744080
1742630
1752640
1762650
1774090
1772660
1782670
1782681
1792690
1802700
1812710
1822720
1824101
1822291
1832730
1842740
1844111
1842751
1852740
1852761
1862740
1864121
1862771
1864133
1862783
1872740
1872791
1882740
1882801
1892740
1894141
1892811
1892823
1902740
1902831
1904154
1902844
191610
1922850
1922861
1932870
1932881
1934163
1932893
1942900
1942911
1954170
1952920
1962930
1974180
1972940
1982950
1984191
1982961
1994200
1992970
2002980
2012990
2023000
2023621
202571
2033010
2043020
2043031
2053020
2051541
2053024
2053045
2053626
205576
2063050
2073060
2073071
2083080
2094210
2093090
2103100
2103112
2103123
2113130
2123140
2133150
2143160
2142071
2143692
2141082
2153170
2154221
2153181
2151113
2163190
2173200
2174231
2173211
2173692
2171082
2183220
2193230
2194241
2193241
2203250
2213260
2223270
2233280
2233292
2243300
2254250
2253310
2263320
2274260
2273330
2274272
2273342
2273623
227573
2283350
2293360
2304280
2303370
2314230
2313210
2312071
2314292
2313382
2324230
2323210
2323391
2334230
2333210
2334011
2331741
2344230
2343210
2344011
2341741
2343402
2344303
2343413
2343624
234574
2354310
2353420
2363430
2373440
2383450
2383461
2383692
2381082
2393470
2393481
2403490
2403621
240571
240902
2413490
2413621
241571
2413502
2411983
2424320
2423510
2423522
2433530
2433541
2443550
2453560
2464330
2463570

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