database model for transaction-subscription