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:
Deleting a Category that linked to Webservices causes FY referential error;
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.
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 inweb_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):
format
table, no error in app, but the linked value reminded inweb_service_output_format
table cannot be displayed when loading up the Webservice in app.