Roabella

Tables (20)

Banner (배너)

  • bannerId (Key) — bigInt — Primary key — NOT NULL
  • bannerTitle (Field) — varchar
  • bannerType (Field2) — char
  • linkUrl (Field3) — varchar
  • expressionOrder (Field4) — int
  • expressionCheck (Field5) — char
  • existMediaCheck (Field6) — char
  • startPostDate (Field7) — localdate
  • endPostDate (Field8) — localdate
  • createdAt (Field9) — localdate
  • modifiedAt (Field10) — localdate

CancelOrder (주문 취소 이력 정보)

  • cancelOrderId (Key) — bigInt — Primary key — NOT NULL
  • orderNumber (Field) — varchar
  • classificationCode (Field2) — varchar
  • productId (Field3) — bigInt
  • productName (Field4) — varchar
  • productOptionId (Field5) — bigInt
  • productOptionTitle (Field6) — varchar
  • productDetailOptionId (Field7) — bigInt
  • productDetailOptionTitle (Field8) — varchar
  • productPrice (Field9) — int
  • productOptionPrice (Field10) — int
  • quantity (Field11) — int
  • productTotalPrice (Field12) — int
  • additionalPrice (Field13) — int
  • seq (Field14) — int
  • cancelCheck (Field15) — char
  • createdAt (Field16) — localdate
  • modifiedAt (Field17) — localdate

Cart (장바구니)

  • cartId (Key) — bigInt — Primary key — NOT NULL
  • memberId (Field) — bigInt
  • classificationCode (Field2) — varchar
  • productId (Field3) — bigint
  • productName (Field4) — varchar
  • productOptionId (Field5) — bigInt
  • productOptionTItle (Field6) — varchar
  • productDetailOptionId (Field7) — bigInt
  • productDetailOptionTitle (Field8) — varchar
  • productPrice (Field9) — int
  • productOptionPrice (Field10) — int
  • quantity (Field11) — int
  • createdAt (Field12) — localdate
  • modifiedAt (Field13) — localdate

Category (카테고리)

  • categoryId (Key) — bigInt — Primary key — NOT NULL
  • categoryName (Field) — varchar
  • classificationCode (Field2) — varchar
  • createdAt (Field3) — localdate
  • modifiedAt (Field4) — localdate

Coupon (쿠폰)

    Event (이벤트)

      Faq (FAQ)

      • faqId (Key) — bigInt — Primary key — NOT NULL
      • question (Field) — varchar
      • answer (Field2) — text
      • type (Field6) — varchar
      • existMediaCheck (Field5) — char
      • createdAt (Field3) — localdate
      • modifiedAt (Field4) — localdate

      Inquiry (문의)

      • inquiryId (Key) — bigInt — Primary key — NOT NULL
      • inquiryTitle (Field) — varchar
      • inquiryContent (Field2) — text
      • memberId (Field3) — bigInt
      • nickName (Field4) — varchar
      • secretCheck (Field10) — char
      • answerContent (Field5) — text
      • answerCheck (Field6) — char
      • answeredAt (Field7) — localdate
      • createdAt (Field8) — localdate
      • modifiedat (Field9) — localdate

      JwtToken (JWT 토큰)

      • tokenId (Key) — bigInt — Primary key — NOT NULL
      • refreshToken (Field) — varchar
      • grantType (Field2) — char
      • memberId (Field3) — bigInt
      • createdAt (Field4) — localdate
      • modifiedAt (Field5) — localdate

      Like (좋아요)

      • likeId (Key) — bigInt — Primary key — NOT NULL
      • memberId (Field) — bigInt
      • productId (Field2) — bigInt
      • createdAt (Field3) — localdate
      • modifiedAt (Field4) — localdate

      Media (미디어)

      • mediaId (Key) — bigInt — Primary key — NOT NULL
      • mediaTitle (Field) — varchar
      • mediaUuidTitle (Field2) — varchar
      • mediaUploadUrl (Field3) — varchar
      • mediaUrl (Field4) — varchar
      • contentType (Field5) — varchar
      • type (Field6) — char
      • mappingContentId (Field7) — bigInt
      • representcheck (Field8) — char
      • createdAt (Field9) — localdate
      • modifiedAt (Field10) — localdate

      Member (회원)

      • memberId (Key) — bigInt — Primary key — NOT NULL
      • email (Field) — varchar
      • nickName (Field2) — varchar
      • password (Field3) — varchar
      • accountType (Field4) — char
      • address (Field5) — varchar
      • postalCode (Field6) — char
      • phone (Field7) — char
      • live (Field8) — char
      • createdAt (Field9) — localdate
      • modifiedAt (Field10) — localdate

      Notice (공지사항)

      • noticeId (Key) — bigInt — Primary key — NOT NULL
      • noticeTitle (Field) — varchar
      • noticeContent (Field2) — text
      • expressionCheck (Field6) — char
      • existMediaCheck (Field5) — char
      • createdAt (Field3) — localdate
      • modifiedAt (Field4) — localdate

      Order (주문 정보)

        OrderInProduct (주문 및 매핑 제품 정보)

        • orderInProductId (Key) — bigInt — Primary key — NOT NULL
        • orderNumber (Field) — varchar
        • businessNumber (Field2) — varchar
        • cartId (Field3) — bigInt
        • memberId (Field4) — bigInt
        • productId (Field5) — bigInt
        • productName (Field6) — varchar
        • prodcurOptionId (Field7) — bigint
        • productOptionTitle (Field8) — varchar
        • prodcutDetailOptionId (Field9) — bigInt
        • productDetailOptionTitle (Field10) — varchar
        • productPrice (Field11) — int
        • productOptionPrice (Field12) — int
        • quantity (Field13) — int
        • productTotalPrice (Field14) — int
        • deliveryPrice (Field15) — int
        • additionalPrice (Field16) — int
        • seq (Field17) — int
        • parcelName (Field18) — varchar
        • transportNumber (Field19) — varchar
        • memo (Field20) — varchar
        • completePurchaseAt (Field21) — localdate
        • completePurchaseCheck (Field22) — char
        • createdAt (Field23) — localdate
        • modifiedAt (Field24) — localdate

        Payment (결제 정보)

          Product (제품)

          • productId (Key) — bigInt — Primary key — NOT NULL
          • productName (Field) — varchar
          • categoryId (Field2) — bigInt
          • category (Field3) — varchar
          • sellPrice (Field4) — int
          • classificationCode (Field5) — varchar
          • deliveryPrice (Field6) — int
          • expressionCheck (Field7) — char
          • modelNumber (Field8) — varchar
          • optioncheck (Field9) — char
          • mediaIds (Field10) — varchar
          • detailContent (Field14) — text
          • status (Field11) — char
          • createdAt (Field12) — localdate
          • modifiedAt (Field13) — localdate

          ProductDetailOption (제품 상세 옵션)

          • productDetailOptionId (Key) — bigInt — Primary key — NOT NULL
          • detailOptionTitle (Field) — varchar
          • detailOptionPrice (Field2) — int
          • productOptionId (Field3) — bigInt
          • createdAt (Field4) — localdate
          • modifiedAt (Field5) — localdate

          ProductOption (제품 옵션)

          • productOptionId (Key) — bingInt — Primary key — NOT NULL
          • optionTitle (Field) — varchar
          • productId (Field2) — bigInt
          • createdAt (Field3) — localdate
          • modifiedAt (Field4) — localdate

          Review (리뷰)

          • reviewId (Key) — bigInt — Primary key — NOT NULL
          • productId (Field) — bigInt
          • productName (Field3) — varchar
          • memberId (Field2) — bigInt
          • reviewer (Field4) — varchar
          • reviewContent (Field5) — text
          • starRate (Field10) — int
          • existMediaCheck (Field6) — char
          • createdAt (Field8) — localdate
          • modifiedAt (Field9) — localdate