Need help to create chat application database schema?
I am developing a chat application in asp.net using SignalR.
Client requirements are:
Admin can create different chat rooms e.g. (News Room, Sports Room, Android Room etc)
Registered users can then join different chat rooms (one at a time) to chat with other online users on selected chat room.
Each user's chat history should be stored.
These are major requirements of my client. I have developed the following database schema at the moment for managing users and chat history of users.
Table 1: User
Fields: user_id, username, firstname, lastname, email, phone
Table 2: chathistory
Fields: ch_id, user_id(FK), sendby, sendto, message, time, date
But now I am confused in creating database schema for multiple chat rooms. How should I create or manage database schema for chat rooms. Please help me out to get it done as per my client's requirements.
Thanks,
momersaleem
database-design
asked May 30 '14 at 8:04
momersaleemmomersaleem
111
add a comment |
I am developing a chat application in asp.net using SignalR.
Client requirements are:
Admin can create different chat rooms e.g. (News Room, Sports Room, Android Room etc)
Registered users can then join different chat rooms (one at a time) to chat with other online users on selected chat room.
Each user's chat history should be stored.
These are major requirements of my client. I have developed the following database schema at the moment for managing users and chat history of users.
Table 1: User
Fields: user_id, username, firstname, lastname, email, phone
Table 2: chathistory
Fields: ch_id, user_id(FK), sendby, sendto, message, time, date
But now I am confused in creating database schema for multiple chat rooms. How should I create or manage database schema for chat rooms. Please help me out to get it done as per my client's requirements.
Thanks,
momersaleem
database-design
asked May 30 '14 at 8:04
momersaleemmomersaleem
111
1
The first thing I would do is Google "open source chat applications" and take a look at how others have done it - there is also "forum software" or even "message boards". One I can recommend is fudforum.org/forum if it's forum stuff that you want - to me they appear to overlap considerably. The one I have recommended runs orafaq.com/forums - their forum design is way better than Oracle's own board/forum/chat one! One other final thing - many of these (that I have used anyway) specifically forbid crossposting (i.e. multi-forum). There are good reasons for this - think about that also.
– Vérace
May 30 '14 at 9:05
add a comment |
I am developing a chat application in asp.net using SignalR.
Client requirements are:
Admin can create different chat rooms e.g. (News Room, Sports Room, Android Room etc)
Registered users can then join different chat rooms (one at a time) to chat with other online users on selected chat room.
Each user's chat history should be stored.
These are major requirements of my client. I have developed the following database schema at the moment for managing users and chat history of users.
Table 1: User
Fields: user_id, username, firstname, lastname, email, phone
Table 2: chathistory
Fields: ch_id, user_id(FK), sendby, sendto, message, time, date
But now I am confused in creating database schema for multiple chat rooms. How should I create or manage database schema for chat rooms. Please help me out to get it done as per my client's requirements.
Thanks,
momersaleem
database-design
asked May 30 '14 at 8:04
momersaleemmomersaleem
111
I am developing a chat application in asp.net using SignalR.
Client requirements are:
Admin can create different chat rooms e.g. (News Room, Sports Room, Android Room etc)
Registered users can then join different chat rooms (one at a time) to chat with other online users on selected chat room.
Each user's chat history should be stored.
These are major requirements of my client. I have developed the following database schema at the moment for managing users and chat history of users.
Table 1: User
Fields: user_id, username, firstname, lastname, email, phone
Table 2: chathistory
Fields: ch_id, user_id(FK), sendby, sendto, message, time, date
But now I am confused in creating database schema for multiple chat rooms. How should I create or manage database schema for chat rooms. Please help me out to get it done as per my client's requirements.
Thanks,
momersaleem
database-design
database-design
asked May 30 '14 at 8:04
momersaleemmomersaleem
111
asked May 30 '14 at 8:04
momersaleemmomersaleem
111
asked May 30 '14 at 8:04
momersaleemmomersaleem
111
asked May 30 '14 at 8:04
momersaleemmomersaleem
111
asked May 30 '14 at 8:04
momersaleemmomersaleem
111
111
1
The first thing I would do is Google "open source chat applications" and take a look at how others have done it - there is also "forum software" or even "message boards". One I can recommend is fudforum.org/forum if it's forum stuff that you want - to me they appear to overlap considerably. The one I have recommended runs orafaq.com/forums - their forum design is way better than Oracle's own board/forum/chat one! One other final thing - many of these (that I have used anyway) specifically forbid crossposting (i.e. multi-forum). There are good reasons for this - think about that also.
– Vérace
May 30 '14 at 9:05
add a comment |
1
The first thing I would do is Google "open source chat applications" and take a look at how others have done it - there is also "forum software" or even "message boards". One I can recommend is fudforum.org/forum if it's forum stuff that you want - to me they appear to overlap considerably. The one I have recommended runs orafaq.com/forums - their forum design is way better than Oracle's own board/forum/chat one! One other final thing - many of these (that I have used anyway) specifically forbid crossposting (i.e. multi-forum). There are good reasons for this - think about that also.
– Vérace
May 30 '14 at 9:05
1
1
The first thing I would do is Google "open source chat applications" and take a look at how others have done it - there is also "forum software" or even "message boards". One I can recommend is fudforum.org/forum if it's forum stuff that you want - to me they appear to overlap considerably. The one I have recommended runs orafaq.com/forums - their forum design is way better than Oracle's own board/forum/chat one! One other final thing - many of these (that I have used anyway) specifically forbid crossposting (i.e. multi-forum). There are good reasons for this - think about that also.
– Vérace
May 30 '14 at 9:05
The first thing I would do is Google "open source chat applications" and take a look at how others have done it - there is also "forum software" or even "message boards". One I can recommend is fudforum.org/forum if it's forum stuff that you want - to me they appear to overlap considerably. The one I have recommended runs orafaq.com/forums - their forum design is way better than Oracle's own board/forum/chat one! One other final thing - many of these (that I have used anyway) specifically forbid crossposting (i.e. multi-forum). There are good reasons for this - think about that also.
– Vérace
May 30 '14 at 9:05
add a comment |
1 Answer
1
active
oldest
votes
Please fine the blow link of facebook chat app db design
enter link description here
answered 8 mins ago
Thomson IgnesiousThomson Ignesious
11
New contributor
Thomson Ignesious is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f66225%2fneed-help-to-create-chat-application-database-schema%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Please fine the blow link of facebook chat app db design
enter link description here
answered 8 mins ago
Thomson IgnesiousThomson Ignesious
11
New contributor
Thomson Ignesious is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Please fine the blow link of facebook chat app db design
enter link description here
answered 8 mins ago
Thomson IgnesiousThomson Ignesious
11
New contributor
Thomson Ignesious is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Please fine the blow link of facebook chat app db design
enter link description here
answered 8 mins ago
Thomson IgnesiousThomson Ignesious
11
New contributor
Thomson Ignesious is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Please fine the blow link of facebook chat app db design
enter link description here
answered 8 mins ago
Thomson IgnesiousThomson Ignesious
11
New contributor
Thomson Ignesious is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 8 mins ago
Thomson IgnesiousThomson Ignesious
11
New contributor
Thomson Ignesious is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 8 mins ago
Thomson IgnesiousThomson Ignesious
11
answered 8 mins ago
Thomson IgnesiousThomson Ignesious
11
11
New contributor
Thomson Ignesious is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Thomson Ignesious is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Thomson Ignesious is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f66225%2fneed-help-to-create-chat-application-database-schema%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
The first thing I would do is Google "open source chat applications" and take a look at how others have done it - there is also "forum software" or even "message boards". One I can recommend is fudforum.org/forum if it's forum stuff that you want - to me they appear to overlap considerably. The one I have recommended runs orafaq.com/forums - their forum design is way better than Oracle's own board/forum/chat one! One other final thing - many of these (that I have used anyway) specifically forbid crossposting (i.e. multi-forum). There are good reasons for this - think about that also.
– Vérace
May 30 '14 at 9:05