Table: search_feedback

Connected to

This table references:

• assets(id) via column hit_asset_id
• user(ref) via column user_ref

Columns

Column	Type	Nullable	Notes
id	uuid	no	Default gen_random_uuid()
query_hash	text	no	—
dsl_query	text	no	—
hit_asset_id	uuid	no	References assets(id)
hit_position	integer	no	—
direction	text	no	—
user_ref	bigint	no	References user(ref)
ip_hash	text	yes	—
feedback_at	timestamp	no	Default now()

Constraints

• CONSTRAINT search_feedback_direction_check CHECK ((direction = ANY (ARRAY['up'::text, 'down'::text])))
• CONSTRAINT search_feedback_hit_position_check CHECK ((hit_position >= 1))

Full DDL

CREATE TABLE public.search_feedback (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    query_hash text NOT NULL,
    dsl_query text NOT NULL,
    hit_asset_id uuid NOT NULL,
    hit_position integer NOT NULL,
    direction text NOT NULL,
    user_ref bigint NOT NULL,
    ip_hash text,
    feedback_at timestamp with time zone DEFAULT now() NOT NULL,
    CONSTRAINT search_feedback_direction_check CHECK ((direction = ANY (ARRAY['up'::text, 'down'::text]))),
    CONSTRAINT search_feedback_hit_position_check CHECK ((hit_position >= 1))
);

---

Please see the schema overview for context. This document was last regenerated on 2026-07-26T08:25:29.520Z.