How do I add a text field that links to the taxonomy_index table
Use the field collection module.

Create a new field collection field attached to your content type, and then in your field collection put 2 fields: 1 taxonomy term reference field, and 1 text field.