Can any body help me out

Don't build your own payment gateway, instead use a fully baked payment gateway such as paypal, authorize.net and etc..

https://stackoverflow.com/questions/35129979/generic-database-design-for-multiple-gateways may help you https://dba.stackexchange.com/questions/13972/schema-designing-for-handling-multiple-payment-gateways https://stackoverflow.com/questions/43391439/integrating-payment-methods-in-db-schemas https://forums.asp.net/t/1532871.aspx?How+do+I+add+a+payment+process+to+my+database+design+