export const users = mysqlTable('user', {
id: varchar('id', { length: 255 }).notNull().primaryKey(),
name: varchar('name', { length: 255 }),
email: varchar('email', { length: 255 }).notNull(),
emailVerified: timestamp('emailVerified', {
mode: 'date',
fsp: 3
}).defaultNow(),
image: varchar('image', { length: 255 })
})export const comments = mysqlTable('comment', {
id: varchar('id', { length: 255 }).notNull().primaryKey(),
body: varchar('body', { length: 255 }).notNull(),
created_at: timestamp('created_at', {
mode: 'date',
fsp: 6
}).defaultNow(),
updated_at: timestamp('updated_at', {
mode: 'date',
fsp: 6
}).defaultNow(),
userId: varchar('userId', { length: 255 })
.notNull()
.references(() => users.id)
})
N
Amodel User {
id String @id @default(cuid())
name String?
email String? @unique
emailVerified DateTime? @map("email_verified")
image String? @db.Text
accounts Account[]
sessions Session[]
createdAt DateTime @default(now()) @map("created_at")
updatedAt DateTime @updatedAt @map("updated_at")
Comment Comment[]
}model Comment {
id String @id @default(cuid())
body String
user User @relation(fields: [userId], references: [id])
userId String
created_at DateTime @default(now())
updated_at DateTime @updatedAt
Post Post @relation(fields: [postId], references: [id])
postId String
children Comment[] @relation("comment_children")
parent Comment? @relation("comment_children", fields: [parentId], references: [id], onDelete: NoAction, onUpdate: NoAction)
parentId String?
@@index([userId])
@@index([parentId])
@@index([postId])
}