Muhammad al-xorazmiy nomidagi toshkent axborot texnologiyalari universiteti farg’ona filiali

Loyihanintg malumotlar bazasi tuzilishi

ProfileUsers {

AccountID integer > Accounts.ID
firstName varchar
lastName varchar
bithday date
Photo blob
RoleID integer > Roles.id
sex binary
}

Roles {
id integer pk increments unique

nameRole varchar unique
}

Accounts {

ID binary pk increments unique
login varchar unique
password varchar
}

Groups {
ID integer pk increments unique

name varchar
desciption varchar
usersListID varchar > Users-Groups.ID
listMessages integer > messagesGroup.ID
chatID integer > Chats.ID
}

Users-Groups {

ID integer pk increments unique
accountID integer > Accounts.ID
groupID integer > Groups.ID
}

Messages {

ID integer pk increments unique
authorID integer > Accounts.ID
text varchar
dateOfCreate datetime
header varchar
}

messagesGroup {

ID integer pk increments unique
messageID integer > Messages.ID
groupsID integer > Groups.ID
}

RateUser {

id integer
accountID integer > Accounts.ID
UPaccountID integer > Accounts.ID
DOWNaccountID integer > Accounts.ID
}

Chats {
ID integer pk increments unique

name varchar
listMessagesID integer > messageChat.ID
}

messageChat {

ID integer
chatID integer > Chats.ID
messageID integer > Messages.ID
}