public.spec_features

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid	gen_random_uuid()	false	public.spec_behaviors
domain_id	uuid		false		public.spec_domains
name	varchar(255)		false
description	text		true
sort_order	integer	0	false
created_at	timestamp with time zone	now()	false
updated_at	timestamp with time zone	now()	false

Constraints

Name	Type	Definition
fk_spec_features_domain	FOREIGN KEY	FOREIGN KEY (domain_id) REFERENCES spec_domains(id) ON DELETE CASCADE
spec_features_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
spec_features_pkey	CREATE UNIQUE INDEX spec_features_pkey ON public.spec_features USING btree (id)
idx_spec_features_domain_sort	CREATE INDEX idx_spec_features_domain_sort ON public.spec_features USING btree (domain_id, sort_order)

Relations

---

Generated by tbls