Re: Data Modelling Information

2013-12-11 Thread Aaron Morton
create table messages( body text, username text, tags settext PRIMARY keys(username,tags) ) This statement is syntactically invalid, also you cannot use a collection type in the primary key. 1) I should be able to query by username and get all the messages for a

Data Modelling Information

2013-12-09 Thread Shrikar archak
Hi Data Model Experts, I have a few questions with data modelling for a particular application. example create table messages( body text, username text, tags settext PRIMARY keys(username,tags) ) Requirements 1) I should be able to query by username and get all the messages for a particular