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