schema.prisma

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

datasource sqlite {
  provider = "sqlite"
  url      = env("DATABASE_URL")
  // url = "file:./data.db"
}

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

model Link {
  id          Int      @id @default(autoincrement())
  createdAt   DateTime @default(now())
  href        String
  readingTime String?
  user        User     @relation(fields: [userId], references: [id])
  userId      Int
  tags        Tag[]    @relation(references: [id])
  timeout     DateTime
  notify      Boolean  @default(true)

  title       String?

  @@unique([userId, href])
}

model Tag {
  id     Int     @id @default(autoincrement())
  tag    String
  user   User    @relation(fields: [userId], references: [id])
  notify Boolean @default(true)
  userId Int
  posts  Link[]  @relation(references: [id])

  @@unique([userId, tag])
}

model User {
  id        Int        @id @default(autoincrement())
  email     String     @unique
  name      String?
  createdAt DateTime   @default(now())
  notify    Boolean    @default(true)
  Link      Link[]
  Tag       Tag[]
  EmailLog  EmailLog[]
  twitterUsername       String?       @unique
  stripeCustomerId      String?       @unique
  paymentStatus         String        @default("unsubscribed")
  pocketConnected       Boolean       @default(false)
  pocketToken           PocketToken?
}

model EmailLog {
  id        Int      @id @default(autoincrement())
  mailId    String
  createdAt DateTime @default(now())
  user      User     @relation(fields: [userId], references: [id])
  userId    Int
  text      String
  html      String
}

model PocketToken {
  id          Int      @id @default(autoincrement())
  token       String?  @unique
  user        User     @relation(fields: [userId], references: [id])
  userId      Int
}