public.voucher_reservation¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | (DC2Type:uuid) | |||
| owner_id | uuid | false | public.user | (DC2Type:uuid) | ||
| stripe_payment_intent_id | varchar(255) | true | ||||
| created_at | timestamp(0) with time zone | false | (DC2Type:datetimetz_immutable) | |||
| voucher_id | uuid | true | public.voucher | (DC2Type:uuid) | ||
| is_paid | boolean | false | ||||
| 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¶
Generated by tbls