public.app_categories

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
app_id	bigint		false		public.apps
category_id	bigint		false		public.categories
sort_order	integer	0	false
created_at	timestamp without time zone	CURRENT_TIMESTAMP	true

Constraints

Name	Type	Definition
app_categories_app_id_not_null	n	NOT NULL app_id
app_categories_category_id_not_null	n	NOT NULL category_id
app_categories_sort_order_not_null	n	NOT NULL sort_order
app_categories_category_id_fkey	FOREIGN KEY	FOREIGN KEY (category_id) REFERENCES categories(id) ON DELETE CASCADE
app_categories_app_id_fkey	FOREIGN KEY	FOREIGN KEY (app_id) REFERENCES apps(id) ON DELETE CASCADE
app_categories_pkey	PRIMARY KEY	PRIMARY KEY (app_id, category_id)

Indexes

Name	Definition
app_categories_pkey	CREATE UNIQUE INDEX app_categories_pkey ON public.app_categories USING btree (app_id, category_id)
idx_app_categories_category_id	CREATE INDEX idx_app_categories_category_id ON public.app_categories USING btree (category_id)

Relations

---

Generated by tbls