```model User {
id Int @id @default...
# orm-helpa
Awey
11/13/2021, 8:35 AM Copy code
model User {
id Int @id @default(autoincrement())
createdAt DateTime @default(now())
email String @unique
username String @db.VarChar(50)
password String
...
}
model Message {
id Int @id @default(autoincrement())
createdAt DateTime @default(now())
subject String
body String
}Awey
11/16/2021, 7:44 AM@Ryan Sorry to bug you again, would you be able to point me in the right direction with this one?
I'm having trouble thinking about this conceptually. I'm not the best when it comes to setting up these data models.
Awey
11/16/2021, 7:51 AM🤔 If you know of any courses that teach this stuff (database design), I'd also appreciate a link to those.
r
Ryan
11/16/2021, 12:29 PM@Awey 👋
Sure, what you could do is create a messaging room and have 2 users present in the room as this is just a 1-1 chat. That would be connected to the messages model. Let me share the schema with you.
Ryan
11/16/2021, 12:34 PM Copy code
model User {
id Int @id @default(autoincrement())
name String
rooms Room[]
messages Message[]
}
model Room {
id Int @id @default(autoincrement())
messages Message[]
users User[]
}
model Message {
id Int @id @default(autoincrement())
content String
user User @relation(fields: [userId], references: [id])
Room Room? @relation(fields: [roomId], references: [id])
userId Int
roomId Int?
}a
Awey
11/18/2021, 9:09 AMIs this model architecutre for live chat or how I would structure it for an email like system between userss?
r
Ryan
11/18/2021, 11:34 AMYes you can use this for a live chat as well as a simple messaging system. An basic email system would also work but an advanced one with something like threads and reply-all would need more design.