Created
May 12, 2023 04:06
-
-
Save kuc-arc-f/2155c65350a5decb3b7f0e9fadb0786d to your computer and use it in GitHub Desktop.
schema.prisma: prisma ORM, Cloudflare D1 , session table
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// This is your Prisma schema file, | |
// learn more about it in the docs: https://pris.ly/d/prisma-schema | |
generator client { | |
provider = "prisma-client-js"schema.prisma | |
} | |
datasource db { | |
provider = "sqlite" | |
url = env("DATABASE_URL") | |
} | |
model User { | |
id Int @id @default(autoincrement()) | |
createdAt DateTime @default(now()) | |
updatedAt DateTime @updatedAt | |
password String | |
email String @unique | |
name String? | |
} | |
model Task { | |
id Int @id @default(autoincrement()) | |
createdAt DateTime @default(now()) | |
updatedAt DateTime @updatedAt | |
title String? | |
content String? | |
userId Int? | |
} | |
model Token { | |
id Int @id @default(autoincrement()) | |
createdAt DateTime @default(now()) | |
updatedAt DateTime @updatedAt | |
token String? | |
secret String? | |
expire_datetime DateTime @default(now()) | |
userId Int? | |
} | |
model Session { | |
id Int @id @default(autoincrement()) | |
sessionId String | |
key String | |
value String? | |
createdAt DateTime @default(now()) | |
updatedAt DateTime? @updatedAt | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment