Skip to content

public.refund

Description

Columns

Name Type Default Nullable Children Parents Comment
id uuid false Unique identifier for the refund(DC2Type:uuid)
player_id uuid true public.match_player Reference to the match player receiving the refund(DC2Type:uuid)
status varchar(255) false Current status of the refund (PENDING, SUCCEEDED, REJECTED)
refunded_at timestamp(0) with time zone NULL::timestamp with time zone true Timestamp when the refund was successfully processed(DC2Type:datetimetz_immutable)
stripe_refund_id varchar(255) NULL::character varying true Stripe refund transaction identifier
total_amount bigint false
total_currency character(3) false (DC2Type:currency)
created_at timestamp(0) with time zone false Timestamp when the refund was created(DC2Type:datetimetz_immutable)
voucher_id uuid true public.voucher Unique identifier for the 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 Refund strategy applied (SERVICE_TERMS, REFUND_FULL, REFUND_HALF, NO_REFUND)
event_registration_id uuid true public.event_registration Reference to the event registration receiving the refund(DC2Type:uuid)

Constraints

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)

Indexes

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)

Relations

er


Generated by tbls