Skip to content

Review webapi database #24

Description

@Rita-C

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.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions