Hi,
Check below...
You can have below tables to maintain relations between your tables
Customer Table
Customer_Info
(
Cust_Id,
Cust_name,
.
.
.
)
Payment Option Table
Pay_Option
(
Po_Id,
PO_Desc,
.
.
.
)
Payment Transaction Table
Payment_Trans
(
PT_Id,
PT_PO_Id,
PT_Cust_Id,
PT_Amt,
PT_Status,
PT_Desc,
PT_Date,
.
.
.
)
Order Details Table
Order_Dtls
(
Ord_Id,
Ord_PT_Id,
Ord_Cust_Id,
Ord_Date,
.
.
.
)
Hope this will help you.
Cheers