public.payment_intent

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false			Unique identifier of the payment intent.(DC2Type:uuid)
user_id	uuid		true		public.user	User who created this payment intent.(DC2Type:uuid)
match_id	uuid		true		public.game	Match associated with this payment intent.(DC2Type:uuid)
total_in_cents	varchar(255)		false			Total amount to be paid in cents (smallest currency unit).
currency	varchar(255)		false			Currency code for the payment (e.g., EUR, USD).
stripe_client_secret	varchar(255)		false			Stripe client secret for completing the payment on client side.

Constraints

Name	Type	Definition
fk_9b5460872abeacd6	FOREIGN KEY	FOREIGN KEY (match_id) REFERENCES game(id) ON DELETE RESTRICT
payment_intent_pkey	PRIMARY KEY	PRIMARY KEY (id)
fk_9b546087a76ed395	FOREIGN KEY	FOREIGN KEY (user_id) REFERENCES "user"(id) ON DELETE RESTRICT

Indexes

Name	Definition
payment_intent_pkey	CREATE UNIQUE INDEX payment_intent_pkey ON public.payment_intent USING btree (id)
idx_9b5460872abeacd6	CREATE INDEX idx_9b5460872abeacd6 ON public.payment_intent USING btree (match_id)
idx_9b546087a76ed395	CREATE INDEX idx_9b546087a76ed395 ON public.payment_intent USING btree (user_id)

Relations

---

Generated by tbls