schema.prisma

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["orderByAggregateGroup"]
}

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

model User {
  id                      String                 @id
  createdAt               DateTime               @default(now())
  updatedAt               DateTime               @updatedAt
  fcmToken                String?
  eventMessageAllowDate   DateTime?
  termsOfServiceAllowDate DateTime?
  privacyPolicyAllowDate  DateTime?
  name                    String?
  photo                   String?
  type                    UserType
  cart                    CartItem[]
  coupons                 Coupon[]
  itemReviews             ItemReview[]
  orders                  Order[]
  payments                Payment[]
  pointReceipts           PointReceipt[]
  searchKeywords          SearchKeyword[]
  certificatedInfo        UserCertificatedInfo?
  deliveryInfo            UserDeliveryInfo?
  refundBankAccount       UserRefundBankAccount?
  itemLikes               Item[]
  itemReviewLikes         ItemReview[]           @relation("UserItemReviewLike")
  itemReviewUnlikes       ItemReview[]           @relation("UserItemReviewUnlike")
  notifications           Notification[]
  userRecentViewItem      UserRecentViewItem[]
}

enum UserType {
  cat
  dog
}

model UserRecentViewItem {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  userId    String
  itemId    Int
  user      User     @relation(fields: [userId], references: [id])
  item      Item     @relation(fields: [itemId], references: [id])

  @@index([createdAt])
}

model UserCertificatedInfo {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  phone     String
  userId    String   @unique
  user      User     @relation(fields: [userId], references: [id])

  @@index([userId], name: "userId")
}

model UserRefundBankAccount {
  id            Int      @id @default(autoincrement())
  createdAt     DateTime @default(now())
  updatedAt     DateTime @updatedAt
  bankName      String
  accountNumber String
  ownerName     String
  userId        String   @unique
  user          User     @relation(fields: [userId], references: [id])

  @@index([userId], name: "userId")
}

model UserDeliveryInfo {
  id            Int      @id @default(autoincrement())
  createdAt     DateTime @default(now())
  updatedAt     DateTime @updatedAt
  postCode      String
  address       String
  addressDetail String
  name          String
  phone         String
  userId        String   @unique
  user          User     @relation(fields: [userId], references: [id])

  @@index([userId], name: "userId")
}

model SearchKeyword {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  keyword   String
  userId    String
  user      User     @relation(fields: [userId], references: [id])

  @@index([userId], name: "userId")
}

model Coupon {
  id           String   @id @default(uuid())
  createdAt    DateTime @default(now())
  updatedAt    DateTime @updatedAt
  image        String
  name         String
  period       DateTime
  minItemPrice Int?
  maxSalePrice Int?
  salePercent  Int?
  salePrice    Int?
  userId       String?
  orderId      Int?
  order        Order?   @relation(fields: [orderId], references: [id])
  user         User?    @relation(fields: [userId], references: [id])

  @@index([orderId], name: "orderId")
  @@index([userId], name: "userId")
}

model PointReceipt {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  name      String
  point     Int
  userId    String
  user      User     @relation(fields: [userId], references: [id])

  @@index([userId], name: "userId")
}

model CartItem {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  option    Json?
  itemId    Int
  userId    String
  num       Int
  item      Item     @relation(fields: [itemId], references: [id])
  user      User     @relation(fields: [userId], references: [id])

  @@index([itemId], name: "itemId")
  @@index([userId], name: "userId")
}

model Order {
  id                     Int            @id @default(autoincrement())
  createdAt              DateTime       @default(now())
  updatedAt              DateTime       @updatedAt
  state                  String
  itemPrice              Int
  itemOptionPrice        Int
  itemSale               Int
  num                    Int
  itemOption             Json?
  deliveryCompletionDate DateTime?
  // 교환 환불 취소
  reason                 String?
  reasonDetail           String?        @db.Text
  refundPrice            Int            @default(0) // 환불된 가격
  refundPoint            Int            @default(0) // 환불된 포인트
  refundMethod           String?
  deliveryNumber         String? // 운송장 번호
  deliveryCompany        String? // 배송회사 이름
  deliveryCompanyCode    String? // 배송회사 코드
  totalPrice             Int
  cartItemId             Int
  userId                 String
  paymentId              String
  itemId                 Int
  profitReceiptId        Int?
  item                   Item           @relation(fields: [itemId], references: [id])
  payment                Payment        @relation(fields: [paymentId], references: [id])
  user                   User           @relation(fields: [userId], references: [id])
  profitReceipt          ProfitReceipt? @relation(fields: [profitReceiptId], references: [id])
  coupons                Coupon[]
  itemReview             ItemReview?

  @@index([itemId], name: "itemId")
  @@index([paymentId], name: "paymentId")
  @@index([userId], name: "userId")
  @@index([itemId], name: "itemId")
}

model Payment {
  id                 String   @id
  createdAt          DateTime @default(now())
  updatedAt          DateTime @updatedAt
  name               String
  state              String
  cancelReason       String?
  paymentMethod      String
  price              Int
  deliveryPrice      Int
  extraDeliveryPrice Int
  itemSale           Int
  couponSale         Int
  pointSale          Int
  totalPrice         Int
  address            String
  addressName        String
  addressPhone       String
  postCode           String
  deliveryMemo       String
  vBankNum           String?
  vBankDate          String?
  vBankName          String?
  userId             String
  cancelPoint        Int      @default(0)
  cancelPrice        Int      @default(0)
  user               User     @relation(fields: [userId], references: [id])
  orders             Order[]

  @@index([userId], name: "userId")
}

model ItemReview {
  id          Int               @id @default(autoincrement())
  createdAt   DateTime          @default(now())
  updatedAt   DateTime          @updatedAt
  likeNum     Int               @default(0)
  content     String?           @db.Text
  rate        Int
  userId      String
  itemId      Int
  orderId     Int               @unique
  item        Item              @relation(fields: [itemId], references: [id])
  order       Order             @relation(fields: [orderId], references: [id])
  user        User              @relation(fields: [userId], references: [id])
  images      ItemReviewImage[]
  userLikes   User[]            @relation("UserItemReviewLike")
  userUnlikes User[]            @relation("UserItemReviewUnlike")

  @@index([itemId], name: "itemId")
  @@index([userId], name: "userId")
  @@index([orderId], name: "orderId")
}

model ItemReviewImage {
  id           Int         @id @default(autoincrement())
  createdAt    DateTime    @default(now())
  uri          String
  itemReviewId Int?
  itemReview   ItemReview? @relation(fields: [itemReviewId], references: [id])

  @@index([itemReviewId], name: "itemReviewId")
}

model Item {
  id                 Int                  @id @default(autoincrement())
  createdAt          DateTime             @default(now())
  updatedAt          DateTime             @updatedAt
  likeNum            Int                  @default(0)
  state              String               @default("상품등록요청")
  type               ItemType
  deliveryPrice      Int
  extraDeliveryPrice Int
  name               String
  price              Int
  sale               Int                  @default(0)
  reservedSale       Int?
  saleStartDate      DateTime?
  saleEndDate        DateTime?
  option             Json?
  requireInformation Json
  html               String               @db.Text
  shopId             Int?
  category1          String
  category2          String
  targetItemId       Int?                 @unique
  shop               Shop?                @relation(fields: [shopId], references: [id])
  targetItem         Item?                @relation("ItemToItem", fields: [targetItemId], references: [id])
  cart               CartItem[]
  updateItem         Item?                @relation("ItemToItem")
  images             ItemImage[]
  reviews            ItemReview[]
  orders             Order[]
  userLikes          User[]
  userRecentViewItem UserRecentViewItem[]

  @@index([shopId], name: "shopId")
  @@index([targetItemId], name: "targetItemId")
  @@index([likeNum], name: "likeNum")
}

enum ItemType {
  cat
  dog
  both
}

model ItemImage {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  uri       String
  itemId    Int?
  item      Item?    @relation(fields: [itemId], references: [id])

  @@index([itemId], name: "itemId")
}

model Shop {
  id                Int             @id @default(autoincrement())
  createdAt         DateTime        @default(now())
  updatedAt         DateTime        @updatedAt
  // 기본정보
  shopName          String          @unique
  shopImage         String?
  kakaoId           String? // 주문 정보를 받을 수 있음
  // 수익
  bankAccountNumber String?
  bankName          String?
  bankOwnerName     String?
  // CS
  kakaoLink         String? // 카카오 채널
  csPhone           String?
  refundInfo        String?         @db.Text
  exchangeInfo      String?         @db.Text
  // 담당자
  managerName       String?
  managerPhone      String?
  managerEmail      String?
  // 기타
  storeLink         String?
  state             String          @default("가입요청")
  items             Item[]
  partner           Partner?
  seller            Seller?
  profitReceipts    ProfitReceipt[]
}

model Seller {
  id              Int      @id @default(autoincrement())
  createdAt       DateTime @default(now())
  updatedAt       DateTime @updatedAt
  email           String   @unique
  licenseNumber   String   @unique
  bizRegistration String?
  bizType         String?
  shopId          Int      @unique
  shop            Shop     @relation(fields: [shopId], references: [id])

  @@index([shopId], name: "shopId")
}

model Partner {
  id            Int      @id @default(autoincrement())
  createdAt     DateTime @default(now())
  updatedAt     DateTime @updatedAt
  licenseNumber String   @unique
  email         String   @unique
  shopId        Int      @unique
  shop          Shop     @relation(fields: [shopId], references: [id])

  @@index([shopId], name: "shopId")
}

model Event {
  id          Int      @id @default(autoincrement())
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
  period      DateTime
  bannerImage String
  html        String   @db.Text
}

model ProfitReceipt {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  updatedAt  DateTime @updatedAt
  state      String   @default("정산요청")
  price      Int
  commission Int
  shopId     Int
  shop       Shop     @relation(fields: [shopId], references: [id])
  orders     Order[]

  @@index([shopId], name: "shopId")
}

model Notification {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  image     String?
  title     String
  content   String
  checked   Boolean  @default(false)
  type      String
  params    Json?
  userId    String
  user      User     @relation(fields: [userId], references: [id])
}

model AppVersion {
  id                   Int      @id @default(autoincrement())
  createdAt            DateTime @default(now())
  majorVersion         Int
  minorVersion         Int
  patchVersion         Int
  updateRequire        Boolean
  playstoreDistributed Boolean
  appstoreDistributed  Boolean
}