Prisma Schema (数据库建模)

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

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

model User {
  id        String    @id @default(uuid())
  username  String    @unique
  email     String    @unique
  password  String
  avatar    String?
  comments  Comment[]
  createdAt DateTime  @default(now())
}

model News {
  id        Int       @id @default(autoincrement())
  title     String
  slug      String    @unique
  content   String    @db.Text
  views     Int       @default(0)
  tags      Tag[]
  comments  Comment[]
  createdAt DateTime  @default(now())
}

model Match {
  id         Int      @id @default(autoincrement())
  league     String
  homeTeam   String
  awayTeam   String
  homeScore  Int      @default(0)
  awayScore  Int      @default(0)
  status     String   // UPCOMING, LIVE, FINISHED
  startTime  DateTime
}

model Comment {
  id        String   @id @default(uuid())
  content   String
  userId    String
  user      User     @relation(fields: [userId], references: [id])
  newsId    Int
  news      News     @relation(fields: [newsId], references: [id])
  createdAt DateTime @default(now())
}

model Tag {
  id    Int    @id @default(autoincrement())
  name  String @unique
  news  News[]
}
                    

Next.js 15 App Router 目录结构

my-app/
├── src/
│   ├── app/
│   │   ├── page.tsx          # 首页 (Server Component)
│   │   ├── news/
│   │   │   ├── [slug]/
│   │   │   │   └── page.tsx  # 新闻详情页 (SSR + ISR)
│   │   ├── matches/
│   │   │   └── page.tsx      # 实时比分页 (Dynamic SSR)
│   │   ├── layout.tsx        # 全局骨架
│   │   └── providers.tsx     # 状态容器
                    

Nginx 反向代理与安全配置

server {
    listen 80;
    server_name axygxh.com www.axygxh.com;

    location / {
        proxy_pass http://localhost:3000;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection 'upgrade';
        proxy_set_header Host $host;
        proxy_cache_bypass $http_upgrade;
    }
}