public.tags¶

Description¶

Unique tag names for categorization

Name	Type	Default	Nullable	Children	Comment
created_at	timestamp with time zone	CURRENT_TIMESTAMP	true		When this tag was created
deleted_at	timestamp with time zone		true		Soft delete timestamp
id	bigint	nextval('tags_id_seq'::regclass)	false	public.node_tags
name	text		false		Hierarchical tag in format: root:level1:level2 (e.g., database:postgresql:timescaledb)

Name	Type	Definition
tags_pkey	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
idx_tags_deleted_at	CREATE INDEX idx_tags_deleted_at ON public.tags USING btree (deleted_at)
idx_tags_name_pattern	CREATE INDEX idx_tags_name_pattern ON public.tags USING btree (name text_pattern_ops)
idx_tags_name_trgm	CREATE INDEX idx_tags_name_trgm ON public.tags USING gin (name gin_trgm_ops)
idx_tags_name_unique	CREATE UNIQUE INDEX idx_tags_name_unique ON public.tags USING btree (name)
tags_pkey	CREATE UNIQUE INDEX tags_pkey ON public.tags USING btree (id)

Generated by tbls