Schema for term_synonym
  Database: go    Primary Table: term_synonym    Row Count: 127,084   Data last updated: 2018-04-27
On download server: MariaDB table dump directory
fieldexampleSQL type info
term_id 29int(11) range
term_synonym mitochondrial inheritancevarchar(996) values
acc_synonym  varchar(255) values
synonym_type_id 30int(11) range
synonym_category_id  int(11) range

Connected Tables and Joining Fields
        go.graph_path.term1_id (via term_synonym.term_id)
      go.graph_path.term2_id (via term_synonym.term_id)
      go.term.id (via term_synonym.term_id)
      go.term2term.term1_id (via term_synonym.term_id)
      go.term2term.term2_id (via term_synonym.term_id)
      go.term_dbxref.term_id (via term_synonym.term_id)
      go.term_definition.term_id (via term_synonym.term_id)

Sample Rows
 
term_idterm_synonymacc_synonymsynonym_type_idsynonym_category_id
29mitochondrial inheritance30
32reproductive physiological process30
32GO:0019952GO:001995233
32GO:0050876GO:005087633
34ribosomal chaperone activity30
39high affinity zinc uptake transmembrane transporter activity30
41thioredoxin30
41GO:0000013GO:000001333
441,6-alpha-mannosyltransferase activity30
48single-stranded DNA specific endodeoxyribonuclease activity49

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.