public.payment_intent

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false			(DC2Type:uuid)
user_id	uuid		true		public.user	(DC2Type:uuid)
match_id	uuid		true		public.game	Unique identifier of the match.(DC2Type:uuid)
total_in_cents	varchar(255)		false
currency	varchar(255)		false
stripe_client_secret	varchar(255)		false

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