Table Schema Error - Githubissues

taoyds / spider

scripts and baselines for Spider: Yale complex and cross-domain semantic parsing and text-to-SQL challenge

https://yale-lily.github.io/spider

Apache License 2.0

848 stars 193 forks source link

Table Schema Error #17

Closed GaoyanCheerup closed 5 years ago

GaoyanCheerup commented 5 years ago

Hi Tao,

The table schema (table.json) misses a lot of "foreign_keys" pairs. For example: table "paper" has primary key "paper_id", and table "paper key phrase" also has column "paper_id", but there is no "foreign_keys" relation between the two columns. Similar cases: customer id:: [contacts, customer], product id::[store product, product] During the evaluation, it will cause extra errors.

Thanks, Yan

taoyds commented 5 years ago

Hi Yan,

Sorry for the late response. Some databases are from some online resources. A few of them miss some foreign key info. We didn't have time to update these at that time. It would be great if you can send us your corrections. We will update them soon. Thanks!

Best, Tao

taoyds commented 5 years ago

Close this issue, record it here