canonical_player
Description
Section titled “Description”The authoritative identity of a person in gaming history, created when the user registers. Ghost players are linked to it through claim edges.
Columns
Section titled “Columns”| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | nextval(‘canonical_player_seq’::regclass) | false | public.app_user public.claim_request public.claim_edge | ||
| public_id | uuid | gen_random_uuid() | false | |||
| display_name | varchar(100) | false | ||||
| created_at | timestamp with time zone | now() | false | |||
| updated_at | timestamp with time zone | true | ||||
| version | bigint | false |
Constraints
Section titled “Constraints”| Name | Type | Definition |
|---|---|---|
| canonical_player_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| uq_canonical_player_public_id | UNIQUE | UNIQUE (public_id) |
Indexes
Section titled “Indexes”| Name | Definition |
|---|---|
| canonical_player_pkey | CREATE UNIQUE INDEX canonical_player_pkey ON public.canonical_player USING btree (id) |
| uq_canonical_player_public_id | CREATE UNIQUE INDEX uq_canonical_player_public_id ON public.canonical_player USING btree (public_id) |
Relations
Section titled “Relations”
Generated by tbls