CREATE TABLE tcg.public.TCG_Condition_Audit ( audit_id INT GENERATED ALWAYS AS IDENTITY PRIMARY KEY , condition_id INT NOT NULL , CONSTRAINT FK_TCG_Condition_Audit_condition_id FOREIGN KEY (condition_id) REFERENCES tcg.public.TCG_Condition(condition_id) , name_field VARCHAR(255) NOT NULL , value_prev TEXT , value_new TEXT , change_set_id INT NOT NULL , CONSTRAINT FK_TCG_Condition_Audit_change_set_id FOREIGN KEY (change_set_id) REFERENCES tcg.public.TCG_Change_Set(change_set_id) );