Prisma Schema for Phones

schema.prisma

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model users {
  id                        BigInt    @id @default(autoincrement())
  name                      String    @db.VarChar(255)
  email                     String    @unique(map: "users_email_unique") @db.VarChar(255)
  email_verified_at         DateTime? @db.Timestamp(0)
  password                  String    @db.VarChar(255)
  remember_token            String?   @db.VarChar(100)
  created_at                DateTime? @db.Timestamp(0)
  updated_at                DateTime? @db.Timestamp(0)
}


model phones {
  id                        BigInt    @id @default(autoincrement())
  user_id                   BigInt
  phone_number              String    @db.VarChar(255)
  verified_at               DateTime? @db.Timestamp(0)
  created_at                DateTime? @db.Timestamp(0)
  updated_at                DateTime? @db.Timestamp(0)

  @@index([user_id], map: "phones_user_id_index")
}