Node.jsで掲示板アプリのAPIを作成してみよう（データベース作成編)

docker compose exec node sh
yarn add dotenv
yarn add prisma

yarn prisma init

// 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"
}

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

model User {
  id          Int     @id @default(autoincrement())
  name        String
  email       String  @unique
  password    String
  boards      Board[]
  bookmarks   Bookmark[]
  comments    Comment[]
}

model Board {
  id          Int     @id @default(autoincrement())
  title       String
  content     String?
  user        User    @relation(fields: [userId], references: [id])
  userId      Int
  bookmarks   Bookmark[]
  comments    Comment[]
}

model Bookmark {
  id          Int     @id @default(autoincrement())
  board       Board   @relation(fields: [boardId], references: [id])
  user        User    @relation(fields: [userId], references: [id])
  boardId     Int
  userId      Int
}

model Comment {
  id          Int     @id @default(autoincrement())
  content     String
  board       Board   @relation(fields: [boardId], references: [id])
  user        User    @relation(fields: [userId], references: [id])
  boardId     Int
  userId      Int
}

#src/.env
# Environment variables declared in this file are automatically made available to Prisma.
# See the documentation for more detail: https://pris.ly/d/prisma-schema#accessing-environment-variables-from-the-schema

# Prisma supports the native connection string format for PostgreSQL, MySQL, SQLite, SQL Server, MongoDB and CockroachDB.
# See the documentation for all the connection string options: https://pris.ly/d/connection-strings

DATABASE_URL="postgresql://johndoe:randompassword@localhost:5432/mydb?schema=public"

DATABASE_URL="postgresql://user:password@postgres:5432/board_api_db?schema=public"

yarn prisma migrate dev
Enter a name for the new migration > create table

Connect by: Host
Host:       localhost
Port:       5432
Database:   board_api_db
ユーザー名:   user
パスワード:    password