-/*
-create table account_values(profile varchar not null, account varchar not null, currency varchar
-not null default '', value decimal not null, generation integer default 0 );
-create unique index un_account_values on account_values(profile,account,currency);
- */
-@Entity(tableName = "account_values", primaryKeys = {"profile", "account", "currency"})
+
+@Entity(tableName = "account_values", indices = {
+ @Index(name = "un_account_values", unique = true, value = {"account_id", "currency"}),
+ @Index(name = "fk_account_value_acc", value = "account_id")
+}, foreignKeys = {
+ @ForeignKey(entity = Account.class, parentColumns = "id", childColumns = "account_id",
+ onDelete = ForeignKey.CASCADE, onUpdate = ForeignKey.RESTRICT)
+})