Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[schema error] composite key #20

Closed
leoeaton opened this issue Dec 28, 2018 · 1 comment
Closed

[schema error] composite key #20

leoeaton opened this issue Dec 28, 2018 · 1 comment

Comments

@leoeaton
Copy link

There are composite key sets in some tables according to the *.sql file. For example, in college_2 database, the 6th line in the file TextBookExample.sql says "primary key (building, room_number)", which indicate building and room_number are composite key of this table. However, in the tables.json, building is annotated as the only primary key of the table. I notice there are also some other databases where such issue exists.

@taoyds
Copy link
Owner

taoyds commented Feb 13, 2019

Thanks for your report. We used a script to automatically extract schema info for each database. I am sure why this happens. I already recorded your findings [here(https://github.com//issues/24). We will correct the tables.json file in the next release. Please comment under that issue thread if you find more errors.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants