Miscellany
public text v1 · immutable+-----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| word | varchar(20) | | MUL | | |
| pos | varchar(10) | | | | |
| metaphone | varchar(50) | | MUL | | |
| soundex | varchar(15) | | | | |
+-----------+-------------+------+-----+---------+----------------+