-@Entity(tableName = "transactions", primaryKeys = {"profile", "id"}, indices = {
- @Index(name = "un_transactions_data_hash", unique = true, value = {"profile", "data_hash"}),
- @Index(name = "idx_transaction_description", value = "description")
+@Entity(tableName = "transactions", foreignKeys = {
+ @ForeignKey(entity = Profile.class, parentColumns = "id", childColumns = "profile_id",
+ onDelete = ForeignKey.CASCADE, onUpdate = ForeignKey.RESTRICT)
+}, indices = {@Index(name = "un_transactions_ledger_id", unique = true,
+ value = {"profile_id", "ledger_id"}),
+ @Index(name = "idx_transaction_description", value = "description"),
+ @Index(name = "fk_transaction_profile", value = "profile_id")