Table: asset_tag

Connected to

This table references:

• assets(id) via column asset_id

Columns

Column	Type	Nullable	Notes
asset_id	uuid	no	References assets(id)
tag	text	no	—
added_at	timestamp	no	Default now()
source	text	no	Default 'manual'::text
confidence	real	yes	—
created_by_provider	text	yes	—
created_by_model	text	yes	—

Constraints

• CONSTRAINT asset_tag_confidence_check CHECK (((confidence IS NULL) OR ((confidence >= (0.0)::double precision) AND (confidence <= (1.0)::double precision))))
• CONSTRAINT asset_tag_source_check CHECK ((source = ANY (ARRAY['manual'::text, 'ai'::text, 'import'::text])))

Full DDL

CREATE TABLE public.asset_tag (
    asset_id uuid NOT NULL,
    tag text NOT NULL,
    added_at timestamp with time zone DEFAULT now() NOT NULL,
    source text DEFAULT 'manual'::text NOT NULL,
    confidence real,
    created_by_provider text,
    created_by_model text,
    CONSTRAINT asset_tag_confidence_check CHECK (((confidence IS NULL) OR ((confidence >= (0.0)::double precision) AND (confidence <= (1.0)::double precision)))),
    CONSTRAINT asset_tag_source_check CHECK ((source = ANY (ARRAY['manual'::text, 'ai'::text, 'import'::text])))
);

---

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