Skip to content

Review webapi database #24

@Rita-C

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.

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