Skip to content

public.voucher_reservation

Description

Columns

Name Type Default Nullable Children Parents Comment
id uuid false Unique identifier of the voucher reservation.(DC2Type:uuid)
owner_id uuid false public.user User who owns this voucher reservation.(DC2Type:uuid)
stripe_payment_intent_id varchar(255) true Stripe payment intent ID for tracking the payment transaction.
created_at timestamp(0) with time zone false The date and time when the voucher reservation was created.(DC2Type:datetimetz_immutable)
voucher_id uuid true public.voucher Reference to the actual voucher once the reservation is fulfilled.(DC2Type:uuid)
is_paid boolean false Indicates whether the voucher reservation has been paid.
amount_amount bigint false
amount_currency character(3) false (DC2Type:currency)

Constraints

Name Type Definition
fk_96fc88d37e3c61f9 FOREIGN KEY FOREIGN KEY (owner_id) REFERENCES "user"(id)
fk_96fc88d328aa1b6f FOREIGN KEY FOREIGN KEY (voucher_id) REFERENCES voucher(id)
voucher_reservation_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
voucher_reservation_pkey CREATE UNIQUE INDEX voucher_reservation_pkey ON public.voucher_reservation USING btree (id)
idx_96fc88d328aa1b6f CREATE INDEX idx_96fc88d328aa1b6f ON public.voucher_reservation USING btree (voucher_id)
uniq_96fc88d3fc72f97e CREATE UNIQUE INDEX uniq_96fc88d3fc72f97e ON public.voucher_reservation USING btree (stripe_payment_intent_id)
idx_96fc88d37e3c61f9 CREATE INDEX idx_96fc88d37e3c61f9 ON public.voucher_reservation USING btree (owner_id)

Relations

er

Generated by tbls