privacy_setting

Description

Who may see a kind of data of a user. Invariants (application): every user has exactly one setting per data type, created PRIVATE together with the user, and settings are never deleted; the groups of a setting are owned by its user.

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	bigint	nextval(‘privacy_setting_seq’::regclass)	false	public.privacy_setting_group
public_id	uuid	gen_random_uuid()	false
user_id	bigint		false		public.app_user
data_type	varchar(20)		false
level	varchar(20)	‘PRIVATE’::character varying	false
created_at	timestamp with time zone	now()	false
updated_at	timestamp with time zone		true
version	bigint		false

Constraints

Name	Type	Definition
chk_privacy_setting_data_type	CHECK	CHECK (((data_type)::text = ANY ((ARRAY[‘PROFILE’::character varying, ‘MATCH_HISTORY’::character varying, ‘MATCH_DETAILS’::character varying])::text[])))
chk_privacy_setting_level	CHECK	CHECK (((level)::text = ANY ((ARRAY[‘PRIVATE’::character varying, ‘PRIVILEGED_ACCESS’::character varying, ‘PUBLIC’::character varying])::text[])))
fk_privacy_setting_user_id	FOREIGN KEY	FOREIGN KEY (user_id) REFERENCES app_user(id)
privacy_setting_pkey	PRIMARY KEY	PRIMARY KEY (id)
uq_privacy_setting_public_id	UNIQUE	UNIQUE (public_id)
uq_privacy_setting_user_id_data_type	UNIQUE	UNIQUE (user_id, data_type)

Indexes

Name	Definition
privacy_setting_pkey	CREATE UNIQUE INDEX privacy_setting_pkey ON public.privacy_setting USING btree (id)
uq_privacy_setting_public_id	CREATE UNIQUE INDEX uq_privacy_setting_public_id ON public.privacy_setting USING btree (public_id)
uq_privacy_setting_user_id_data_type	CREATE UNIQUE INDEX uq_privacy_setting_user_id_data_type ON public.privacy_setting USING btree (user_id, data_type)

Relations

---

Generated by tbls