Below is a structured "paper" summarizing the core concepts associated with Bruna Excogi's philosophy.
-- Core tables CREATE TABLE exception ( id BIGINT PRIMARY KEY, source_system VARCHAR(64) NOT NULL, entity_key VARCHAR(128) NOT NULL, -- e.g., product_id metric_name VARCHAR(64) NOT NULL, original_value NUMERIC(20,6) NOT NULL, deviation_pct NUMERIC(5,2) NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, created_by BIGINT NOT NULL REFERENCES users(id), status VARCHAR(12) NOT NULL CHECK (status IN ('OPEN','PENDING','FIXED','REJECTED')), current_fix_id BIGINT NULL REFERENCES fix(id) ); bruna excogi fixed