The table payments(id int primary key) is already available. Create refunds with id as an int primary key, required payment_id as int referencing payments(id), required amount as numeric, and optional reason as text.