GlobalNamesArchitecture / gnresolver

MIT License
0 stars 0 forks source link

As a user I want to have information about vernacular names. #71

Open dimus opened 7 years ago

dimus commented 7 years ago

When a user gets resolution information they can also get information about vernacular names. For this to happen we need to import all fields from vernacular names tables

vernacular_strings

+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| id         | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
| name       | varchar(255)     | YES  | UNI | NULL    |                |
| uuid       | decimal(39,0)    | NO   | UNI | NULL    |                |
| created_at (DROP) | datetime         | YES  |     | NULL    |                |
| updated_at (DROP) | datetime         | YES  |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+

vernacular_string_indices

+----------------------+------------------+------+-----+---------+-------+
| Field                | Type             | Null | Key | Default | Extra |
+----------------------+------------------+------+-----+---------+-------+
| data_source_id       | int(11)          | NO   | PRI | NULL    |       |
| vernacular_string_id | int(11) unsigned | NO   | PRI | NULL    |       |
| taxon_id             | varchar(255)     | NO   | PRI | NULL    |       |
| language             | varchar(255)     | YES  |     | NULL    |       |
| locality             | varchar(255)     | YES  |     | NULL    |       |
| country_code         | varchar(255)     | YES  |     | NULL    |       |
| created_at (DROP)           | datetime         | YES  |     | NULL    |       |
| updated_at (DROP)           | datetime         | YES  |     | NULL    |       |
+----------------------+------------------+------+-----+---------+-------+
alexander-myltsev commented 7 years ago

Output Json format for vernaculars:

{
  "vernaculars": [
    { "dataSourceId": 1, "values": [{"name":"a", "language": "", "locality": "", "countryCode": ""}] },
    { "dataSourceId": 2, "values": [{"name":"a", "language": "", "locality": "", "countryCode": ""}] }
  ]
}

False by default.