((hot)): Ebod 875 Verified

CREATE TABLE verification_results ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), device_id UUID NOT NULL REFERENCES devices(id), operator_id UUID NOT NULL REFERENCES users(id), passed BOOLEAN NOT NULL, completed_at TIMESTAMP WITH TIME ZONE NOT NULL, steps JSONB NOT NULL, -- [stepId, passed, error] created_at TIMESTAMP WITH TIME ZONE DEFAULT now() );

Available in English and other languages via fan translations ebod 875 verified