How to design my schemas, SQL way and NOSQL way
I have a small message system that send message between user and administrators.
We have different admins, 开发者_Go百科so their response making need to know the early message.
In one conversation it has not so many messages.
conversation{
id,
kind, ( the type of conversation, like publish request, edit request, other request)
user_id,
}
message(
id,
flag,(read and unread or some)
conversation_id,
create_time,
)
I didn't know if it is a good solution.
and more, our system use nosql database as well. so I think my data in the nosql database will like these:
conversation(
id,
kind, ( the type of conversation, like publish request, edit request, other request)
user_id,
message_list[m1, m2, m3, m4.........],
)
message_list is a dict:
message_list{
text:text,
time:time,
type:(user or system admin),
}
if I use nosql database, is it a good solution?
In my opinion, NOSQL would only make sense for this if you plan on having data that just doesn't match a schema that well. The above code looks like it'll fit SQL better to me, but either one would work.
加载中,请稍侯......
精彩评论