You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.The text was updated successfully, but these errors were encountered: