app_user

Description

A person with an account. Created together with their canonical player, their self ghost player and their three privacy settings (PROFILE, MATCH_HISTORY, MATCH_DETAILS, all PRIVATE).

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	bigint	nextval(‘app_user_seq’::regclass)	false	public.app_user_identity public.ghost_player public.app_group public.group_member public.playset public.community public.membership public.membership_request public.match public.match_participant public.claim_request public.claim_edge public.match_edit public.trusted_editor public.privacy_setting
public_id	uuid	gen_random_uuid()	false
canonical_player_id	bigint		false		public.canonical_player
display_name	varchar(100)		false
email	varchar(255)		true
last_login_at	timestamp with time zone		true
created_at	timestamp with time zone	now()	false
updated_at	timestamp with time zone		true
version	bigint		false

Constraints

Name	Type	Definition
app_user_pkey	PRIMARY KEY	PRIMARY KEY (id)
uq_app_user_public_id	UNIQUE	UNIQUE (public_id)
uq_app_user_canonical_player_id	UNIQUE	UNIQUE (canonical_player_id)
fk_app_user_canonical_player_id	FOREIGN KEY	FOREIGN KEY (canonical_player_id) REFERENCES canonical_player(id)

Indexes

Name	Definition
app_user_pkey	CREATE UNIQUE INDEX app_user_pkey ON public.app_user USING btree (id)
uq_app_user_public_id	CREATE UNIQUE INDEX uq_app_user_public_id ON public.app_user USING btree (public_id)
uq_app_user_canonical_player_id	CREATE UNIQUE INDEX uq_app_user_canonical_player_id ON public.app_user USING btree (canonical_player_id)
ix_app_user_email	CREATE INDEX ix_app_user_email ON public.app_user USING btree (email)

Relations

---

Generated by tbls