user_survey_favorites

Overview

A join table holding per-user survey favorites.

Table Definition

Logical name	Physical name	Column	Type	PK	Relation	Unique	Nullable	Default	Notes
Favorite	user_survey_favorites	user_id	uuid	◯	users:id (cascade)
		survey_id	uuid	◯	surveys:id (cascade)
		created_at	timestamptz					now()

Relations

• user_id → users.id (onDelete: cascade)
• survey_id → surveys.id (onDelete: cascade)

Indexes

• Composite primary key (user_id, survey_id)

Notes

• Favorites are per user: several users can each favorite the same survey independently
• Adding a favorite inserts a row; removing one deletes it
• In the survey list, favorited surveys are sorted to the top
• Duplicating a survey does not carry favorites over