HeonChaekBang

Tables (11)

Cart (장바구니)

  • cartId (장바구니id) — NOT NULL — Primary key — NOT NULL
  • userId (회원id) — NOT NULL — Foreign key → User.userId — NOT NULL
  • sellOrBuy (판매/구매여부) — NOT NULL
  • totalPrice (총가격) — NOT NULL
  • createdAt (생성일시) — NOT NULL
  • updatedAt (수정일시) — NOT NULL
  • isSolved (솔루션제공여부) — NOT NULL

CartProduct (장바구니-상품)

  • cartId (장바구니id) — NOT NULL — Foreign key → Cart.cartId — NOT NULL
  • productId (상품id) — NOT NULL — Foreign key → Product.productId — NOT NULL
  • count (수량) — NOT NULL

ChatRoom (Untitled9)

    Deal (직거래)

    • dealId (직거래id) — NOT NULL — Primary key — NOT NULL
    • sellerId (판매자id) — NOT NULL — Foreign key → User.userId — NOT NULL
    • buyerId (구매자id) — NULL — Foreign key → User.userId — NOT NULL
    • genre (장르) — NOT NULL
    • price (가격) — NOT NULL
    • title (제목) — NOT NULL
    • description (상세내용) — NOT NULL
    • location (지역) — NOT NULL
    • status (상태) — NOT NULL
    • thumbNailImg (썸네일이미지) — NOT NULL
    • viewCnt (조회수) — NOT NULL
    • createdAt (생성일시) — NOT NULL
    • updatedAt (수정일시) — NOT NULL
    • scrapCnt (좋아요 횟수) — NOT NULL

    DealProduct (상품-직거래)

      Platform (플랫폼)

      • platformId (플랫폼id) — NOT NULL — Primary key — NOT NULL
      • name (플랫폼명) — NOT NULL
      • link (플랫폼링크) — NOT NULL

      PlatformProduct (상품-플랫폼)

      • platformProductId (고유id) — NOT NULL — Primary key — NOT NULL
      • productId (상품id) — NOT NULL — Foreign key → Product.productId — NOT NULL
      • platformId (플랫폼id) — NOT NULL — Foreign key → Platform.platformId — NOT NULL
      • buyingPriceHigh (최상구입가) — NOT NULL
      • buyingPriceMiddle (중간구입가) — NOT NULL
      • buyingPriceLow (최하구입가) — NOT NULL
      • sellingPriceHigh (최상판매가) — NOT NULL
      • sellingPriceMiddle (중간판매가) — NOT NULL
      • sellingPriceLow (최하판매가) — NOT NULL
      • buyLink (구입링크) — NOT NULL
      • sellLing (판매링크) — NOT NULL

      Product (상품(도서))

      • productId (상품id) — NOT NULL — Primary key — NOT NULL
      • title (제목) — NOT NULL
      • photo (상품사진) — NOT NULL
      • originalPrice (원가) — NOT NULL
      • author (저자) — NOT NULL
      • genre (장르) — NOT NULL
      • publisher (출판사) — NOT NULL
      • ISBN (책고유코드) — NOT NULL
      • breifDescription (간략설명) — NOT NULL
      • tableOfContents (목차) — NOT NULL

      ProductImage (상품사진)

      • Key — Primary key — NOT NULL

      Scrap (스크랩)

      • Key — Primary key — NOT NULL
      • userId (회원id) — NOT NULL — Foreign key → User.userId — NOT NULL
      • dealId (직거래id) — NOT NULL — Foreign key → Deal.dealId — NOT NULL
      • createdAt (생성일시) — NOT NULL

      User (회원)

      • userId (회원id) — NOT NULL — Primary key — NOT NULL
      • password (비밀번호) — NOT NULL
      • name (이름) — NOT NULL
      • phone (전화번호) — NOT NULL
      • email (이메일) — NOT NULL
      • address (주소) — NULL
      • createdAt (생성일시) — NOT NULL
      • isActive (활동여부) — NOT NULL