Setup DB table in scaffold to capture all required fields for payment journies

[acuthbert]

Need to capture

Amount, currency, address (optional), description summary, provider identifier (should this be primary key?), status (Created, Pending, Awaiting SCA, Success, Failed)

[jmcelreavey]

I had been thinking about this and came up with the following list:

• Payment Tracking ID
• Payment Service - Realex / Stripe
• Payment Description
• Email Address
• Status - Created, Pending, Awaiting SCA, Success, Failed
• Amount
• Currency
• Card Type
• Card Last 4 Digits
• Card Expiry
• Creation Date
• Last Updated Date
• Additional Data

I was thinking since each provider have different payment identifiers we could hold an object in additional data specific to the provider type. Realex for example require an Auth Code, Order ID and Transaction ID to issue a refund whereas you could probably get everything from the PaymentIntent for Stripe.