Logical Flows: Unable to add new Logical Flows via the UI

[TL41]

Description

It looks like the recent change to add an 'external_id' to the 'logical_flow' table broke this functionality. The insert function from the UI isn't creating/adding an external_id

@davidwatkins73 @JWoodland-Scott @OscarGreen03 - two ideas to fix: make external_id nullable, or start going through and forcing any function that touches this table to generate and add an external_id

One of those is quick and easy, and the other would take some time and risks breaking other things along the way.

Thoughts?

Waltz Version

1.58

Steps to Reproduce

Try to add a new Logical Flow via the UI

Expected Result

Logical flow gets created

Actual Result

nothing gets added; error in console

2255.c64e8354c92d77dc9962.js?0467007895fde07e9cca:2 Possibly unhandled rejection: {"data":{"message":"Data integrity violation detected: jooq; SQL [insert into \"logical_flow\" (\"source_entity_kind\", \"source_entity_id\", \"target_entity_kind\", \"target_entity_id\", \"provenance\", \"last_updated_at\", \"last_updated_by\", \"last_attested_at\", \"last_attested_by\", \"entity_lifecycle_status\", \"is_removed\", \"created_at\", \"created_by\", \"is_readonly\") values (?, ?, ?, ?, ?, cast(? as timestamp), ?, cast(? as timestamp), ?, ?, ?, cast(? as timestamp), ?, ?) returning \"logical_flow\".\"id\"]; ERROR: null value in column \"external_id\" of relation \"logical_flow\" violates not-null constraint\n  Detail: Failing row contains (APPLICATION, 5, APPLICATION, 6, waltz, 15, 2024-02-28 16:30:11.1, admin, null, null, ACTIVE, f, 2024-02-28 16:30:11.1, admin, f, null).; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column \"external_id\" of relation \"logical_flow\" violates not-null constraint\n  Detail: Failing row contains (APPLICATION, 5, APPLICATION, 6, waltz, 15, 2024-02-28 16:30:11.1, admin, null, null, ACTIVE, f, 2024-02-28 16:30:11.1, admin, f, null).","id":"DATA_INTEGRITY"}