-
Notifications
You must be signed in to change notification settings - Fork 6
Open
Description
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):
- Deleting a Category that linked to Webservices causes FY referential error;
- Deleting a Format removed a row in
formattable, no error in app, but the linked value reminded inweb_service_output_formattable cannot be displayed when loading up the Webservice in app.
Reactions are currently unavailable