I am having difficulty creating tables in the database to work with payment, I am creating the payment table with the total payment amount and other tables of money, promissory, check, boleto, card and well, each with id of the payment table. can anyone help me in the relationship between these tables and whether it can be right or wrong. How would it be regarding the cancellation of a product within a purchase to reference some payment made
Picture of attached tables: