-@Entity(tableName = "transaction_accounts", primaryKeys = {"profile", "transaction_id", "order_no"},
- foreignKeys = {@ForeignKey(entity = Transaction.class, parentColumns = {"profile", "id"},
- childColumns = {"profile", "transaction_id"},
- onDelete = ForeignKey.CASCADE, onUpdate = ForeignKey.RESTRICT),
- @ForeignKey(entity = Account.class, parentColumns = {"profile", "name"},
- childColumns = {"profile", "account_name"},
- onDelete = ForeignKey.CASCADE, onUpdate = ForeignKey.RESTRICT)
- }, indices = {@Index(name = "fk_tran_acc_prof_acc", value = {"profile", "account_name"})})
+import net.ktnx.mobileledger.utils.Misc;
+
+@Entity(tableName = "transaction_accounts", foreignKeys = {
+ @ForeignKey(entity = Transaction.class, parentColumns = {"id"},
+ childColumns = {"transaction_id"}, onDelete = ForeignKey.CASCADE,
+ onUpdate = ForeignKey.RESTRICT)
+}, indices = {@Index(name = "fk_trans_acc_trans", value = {"transaction_id"}),
+ @Index(name = "un_transaction_accounts", unique = true,
+ value = {"transaction_id", "order_no"})
+})