C.6 Content of STATUS_SYNONYM_DICTIONARIES

STATUS_SYNONYM_DICTIONARIES stores information relating to synonym dictionaries. One row stores information for one dictionary.

The content of STATUS_SYNONYM_DICTIONARIES is shown in the following table.

Table C‒7: Content of STATUS_SYNONYM_DICTIONARIES
No.	Column name	Data type	Stored information
1	`SYNONYM_DICTIONARY_NAME`	`VARCHAR(120)`	Synonym dictionary name
2	`CREATE_TIME`	`TIMESTAMP`	Creation date and time of synonym dictionary
3	`BINARY_PATH`	`VARCHAR(510)`	Path name of directory for storing synonym dictionary files
4	`BINARY_FILE_NAME`	`VARCHAR(130)`	Synonym dictionary file name
5	`BINARY_FILE_NAME_IGNORECASE`	`VARCHAR(130)`	Synonym dictionary file name corresponding to correction search (`IGNORECASE` specified) If `CASESENSITIVE` is specified in the correction search options, null values are stored. Null values are also stored when no correction options are specified.
6	`BINARY_FILE_NAME_SORTCODE`	`VARCHAR(130)`	Synonym dictionary file name corresponding to correction search (`SORTCODE` specified) If `CASESENSITIVE` is specified in the correction search options, null values are stored. Null values are also stored when no correction search options are specified.
7	`CORRECTION_RULE`	`VARCHAR(32)`	Values specified in correction search options `'CASESENSITIVE'` No specifications made for correction search `'CORRECTIONRULE'` Specifications made for correction search When no correction search options are specified, `'CASESENSITIVE'` is stored.
8	`N_SYNONYM_GROUP`	`SMALLINT`	Number of synonym groups
9	`SYNONYM_DICTIONARY_COMMENT`	`VARCHAR(1024)`	Comment If a comment is not specified, a null value is stored.