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

Review webapi database #24

Open
Rita-C opened this issue Oct 30, 2019 · 0 comments
Open

Review webapi database #24

Rita-C opened this issue Oct 30, 2019 · 0 comments

Comments

@Rita-C
Copy link
Contributor

Rita-C commented Oct 30, 2019

While working on #22, I found the table relationships need review, [and update]. For instance, FK is stored in web_service_category table compares to the value itself is stored in web_service_output_format table:

createTable(schemaName: "webapi", tableName: "web_service_category") { column(name: "web_service_categories_id", type: "BIGINT") column(name: "category_id", type: "BIGINT") }

createTable(schemaName: "webapi", tableName: "web_service_output_format") { column(name: "web_service_id", type: "BIGINT") column(name: "output_format_string", type: "VARCHAR(255)") }

These resulted (via the admin URLs):

  1. Deleting a Category that linked to Webservices causes FY referential error;
  2. Deleting a Format removed a row in format table, no error in app, but the linked value reminded in web_service_output_format table cannot be displayed when loading up the Webservice in app.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants