public.cancellation

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false			(DC2Type:uuid)
initiated_by_id	uuid		false		public.user	(DC2Type:uuid)
created_at	timestamp(0) with time zone		false			(DC2Type:datetimetz_immutable)
refund_strategy	varchar(255)		false
reason	varchar(255)		true
initiator_role	varchar(255)		false
game_id	uuid		false		public.game	Unique identifier of the match.(DC2Type:uuid)
payout_method	varchar(255)		false

Constraints

Name	Type	Definition
fk_fbce5d0ce48fd905	FOREIGN KEY	FOREIGN KEY (game_id) REFERENCES game(id)
fk_fbce5d0cc4ef1fc7	FOREIGN KEY	FOREIGN KEY (initiated_by_id) REFERENCES "user"(id)
cancellation_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
cancellation_pkey	CREATE UNIQUE INDEX cancellation_pkey ON public.cancellation USING btree (id)
idx_fbce5d0cc4ef1fc7	CREATE INDEX idx_fbce5d0cc4ef1fc7 ON public.cancellation USING btree (initiated_by_id)
uniq_fbce5d0ce48fd905	CREATE UNIQUE INDEX uniq_fbce5d0ce48fd905 ON public.cancellation USING btree (game_id)

Relations

---

Generated by tbls