Design User Model

[haseakito]

Issue

• Design and implement User model in prisma.schema
• Draw UML diagram with draw.io for example

Requirements

• Set the user id to be autoincrement than UUID for performance
• Separate user account and profile
• Profile table contains bio and profileImage etc
• Add Following table to connect the followers and followees

Feaures Expectation in the future

• Add Stripe Account
• Add boolean parameter emailVerified to check the authenticity of users
• Add relation to Post and Subscription table

[haseakito]

Memo

According to NextAuth Prisma Adapter documentation, user should have Account to enable different oAuth provider.

Example code for user model in schema.prisma:

model Account { id String @id @default(cuid()) userId String type String provider String providerAccountId String refresh_token String? @db.Text access_token String? @db.Text expires_at Int? token_type String? scope String? id_token String? @db.Text session_state String?

user User @relation(fields: [userId], references: [id], onDelete: Cascade)

@@unique([provider, providerAccountId]) }

model Session { id String @id @default(cuid()) sessionToken String @unique userId String expires DateTime user User @relation(fields: [userId], references: [id], onDelete: Cascade) }

model User { id String @id @default(cuid()) name String? email String? @unique emailVerified DateTime? image String? accounts Account[] sessions Session[] }

model VerificationToken { identifier String token String @unique expires DateTime

@@unique([identifier, token]) }