Tables

Table or key	Design	Entity	Columns	Indexes	Foreign keys
orders	Payment state · illustrative PostgreSQL designPostgreSQL · Payment records	Order reference	3	0	0
payments	Payment state · illustrative PostgreSQL designPostgreSQL · Payment records	Payment	7	0	1
confirmations	Payment state · illustrative PostgreSQL designPostgreSQL · Payment records	Processor confirmation	4	0	2
refunds	Payment state · illustrative PostgreSQL designPostgreSQL · Payment records	Refund	6	0	1