public.cancellation¶

Description¶

Name	Type	Nullable	Parents	Comment
id	uuid	false		Unique identifier of the cancellation record.(DC2Type:uuid)
initiated_by_id	uuid	false	public.user	User who initiated the cancellation.(DC2Type:uuid)
created_at	timestamp(0) with time zone	false		Timestamp when the cancellation was created.(DC2Type:datetimetz_immutable)
refund_strategy	varchar(255)	false		Refund strategy applied for this cancellation (e.g., full refund, partial refund, no refund).
reason	varchar(255)	true		Optional textual reason provided for the cancellation.
initiator_role	varchar(255)	false		Role of the initiator (e.g., PLAYER, COACH, RECEPTIONIST, SYSTEM).
game_id	uuid	false	public.game	The match (game) that was cancelled.(DC2Type:uuid)
payout_method	varchar(255)	false		Method used for refund payout (e.g., credit card, wallet, voucher).

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)

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)

Generated by tbls