Hi all,
Could someone please let me know if the following modeling is on the right way
?
Te requirement is to query by user_id the summarized data of
transaction_status_per_user.
-----
### UDT
CREATE TYPE core_analytics.status_summary (
name text,
count int,
hexcolor text
);
### TABLE
CREATE TABLE core_analytics.transaction_status_per_user (
user_id uuid,
statuses LIST<FROZEN<status_summary>>,
PRIMARY KEY (user_id)
);
###Java Mapping
@UDT(keyspace = "core_analytics", name = "status_summary")
public class StatusSummary {
private String name;
private Integer count;
private String hexcolor;
// getters setters omitted
}
-----
Thanks
IP
