@startuml
 class Counterparty { 
  user_id : key 
 company : string 
 national : string 
 middlename : string 
 lastname : string 
 firstname : string 
}

 class Product { 
  sku_id : key 
 trans_act_id : Transaction*
 user_id : Counterparty*
 store : string 
 productID : string 
 unitValue : string 
 productName : string 
 quantity : string 
}

 class Store { 
  Store_id : key 
 trans_act_id : Transaction*
 state : string 
 postcode : string 
 address2 : string 
 address1 : string 
 country : string 
}

 class Transaction { 
  trans_act_id : key 
 user_id : Counterparty*
 authoriser : string 
 transactionDate : string 
 approvalDate : string 
 accountName : string 
 paymentMethod : string 
}
Product --> Counterparty : user_id
Product --> Transaction : trans_act_id
Store --> Transaction : trans_act_id
Transaction --> Counterparty : user_id
@enduml
