public.refund¶

Description¶

Name	Type	Default	Nullable	Parents	Comment
id	uuid		false		(DC2Type:uuid)
player_id	uuid		true	public.match_player	(DC2Type:uuid)
status	varchar(255)		false
refunded_at	timestamp(0) with time zone	NULL::timestamp with time zone	true		(DC2Type:datetimetz_immutable)
stripe_refund_id	varchar(255)	NULL::character varying	true
total_amount	bigint		false
total_currency	character(3)		false		(DC2Type:currency)
created_at	timestamp(0) with time zone		false		(DC2Type:datetimetz_immutable)
voucher_id	uuid		true	public.voucher	(DC2Type:uuid)
refunded_amount_voucher_amount	bigint		false
refunded_amount_voucher_currency	character(3)		false		(DC2Type:currency)
refunded_amount_online_amount	bigint		false
refunded_amount_online_currency	character(3)		false		(DC2Type:currency)
strategy	varchar(255)	NULL::character varying	false
event_registration_id	uuid		true	public.event_registration	(DC2Type:uuid)

Name	Type	Definition
fk_5b2c145899e6f5df	FOREIGN KEY	FOREIGN KEY (player_id) REFERENCES match_player(id)
fk_5b2c145828aa1b6f	FOREIGN KEY	FOREIGN KEY (voucher_id) REFERENCES voucher(id)
refund_pkey	PRIMARY KEY	PRIMARY KEY (id)
fk_5b2c14584aeeeb73	FOREIGN KEY	FOREIGN KEY (event_registration_id) REFERENCES event_registration(id)

Name	Definition
refund_pkey	CREATE UNIQUE INDEX refund_pkey ON public.refund USING btree (id)
uniq_5b2c1458a715271f	CREATE UNIQUE INDEX uniq_5b2c1458a715271f ON public.refund USING btree (stripe_refund_id)
uniq_5b2c145899e6f5df	CREATE UNIQUE INDEX uniq_5b2c145899e6f5df ON public.refund USING btree (player_id)
uniq_5b2c145828aa1b6f	CREATE UNIQUE INDEX uniq_5b2c145828aa1b6f ON public.refund USING btree (voucher_id)
uniq_5b2c14584aeeeb73	CREATE UNIQUE INDEX uniq_5b2c14584aeeeb73 ON public.refund USING btree (event_registration_id)

Generated by tbls