Breefield

CREATE OR REPLACE FUNCTION
    record_inventory_change()
RETURNS TRIGGER LANGUAGE plpgsql AS $$
DECLARE
    columns text;
    entity RECORD := NEW;
    _deleted VARCHAR(5) := 'false';
BEGIN
    SELECT string_agg(column_name, ',') INTO columns from information_schema.columns where table_name = 'inventory';
    IF TG_OP = 'DELETE' THEN

Breefield

CREATE TRIGGER test_trigger_insert_update AFTER UPDATE OR INSERT ON inventory FOR EACH ROW EXECUTE PROCEDURE record_inventory_change();
CREATE TRIGGER test_trigger_delete BEFORE DELETE ON inventory FOR EACH ROW EXECUTE PROCEDURE record_inventory_change();

Breefield

data class Animal(
    val name: String
)

data class Farm(
    val animals: List<Animal> = emptyList(),
)