phpMyAdmin can provide a detailed look at the current table definition (if you have the needed permissions).
| Field | Notes |
|---|---|
| serial_num | the serial number of the item for which this record is describing a reference to another work item. |
| type | the type of item being referred to, one of ("dependency", "see_also") |
| seq_num | an origin 1 index of the position of the "reference" in the list of references. |
| reference | the RT serial number of an item that item #serial_num refers to, either as a dependency or a see also. Although not intended, it sometimes my be a textual description of an item in another system, e.g. [UW-IST #53082]. |
For example, the "see also" field of an item is derivable via a query like:
select reference from refers_to where serial_num = serial_num and type = "see_also" order by seq_num;