could you please provide some more details about the use case, what are the requirements.

Hi João,

You can create a CreditCard table that will store the credit card information's.  One user can use multiple cards so you need to create junction table as UserCreditCard that contains UserId and CreditCardId.

While placing order you can ask user to enter the credit card information's or you can use any third party service for credit card validation and payment. Once validated you can save that into CreditCard and UserCreditCard table.

Please make sure that you are following PCI Rules for Storing Credit Card Numbers in a Database.

https://www.globalpaymentsintegrated.com/en-us/blog/2019/11/25/pci-rules-for-storing-credit-card-numbers-in-a-database

Thanks

Vinod