seb41 main02

Tables (12)

Address (주소)

  • addressId — bigint — Primary key — NOT NULL
  • memberId — bigint — Foreign key → Member.memberId — NOT NULL
  • addressTitle (주소 이름) — varchar(255)
  • address (주소) — varchar(255)
  • isPrimary (대표 주소 여부) — boolean
  • zipcode (우편 번호) — varchar(255)
  • createdAt (생성일) — datetime
  • modifiedAt (수정일) — datetime

Banner (배너)

  • bannerImageId (배너이미지아이디) — bigint — Primary key — NOT NULL
  • bannerImageUrl (배너 이미지) — varchar(255)
  • createdAt (생성일자) — datetime
  • modifiedAt (수정일자) — datetime

Cart (장바구니)

  • cartId (basketId) — bigint — Primary key — NOT NULL
  • memberId — bigint — Foreign key → Member.memberId — NOT NULL
  • createdAt (생성일) — datetime
  • modifiedAt (수정일) — datetime

Cart_Item (장바구니_상품)

  • cartItemId (Key) — bigint — Primary key — NOT NULL
  • cartId — bigint — Foreign key → Cart.cartId — NOT NULL
  • itemId — bigint — Foreign key → Item.itemId — NOT NULL
  • itemCount (수량) — int
  • itemTotalPrice (총 금액) — int
  • createdAt (생성일) — datetime
  • modifiedAt (수정일) — datetime

Delivery (배송)

  • deliveryId — bigint — Primary key — NOT NULL
  • orderId — bigint — Foreign key → Order.orderId — NOT NULL
  • deliveryStatus (배달 상태) — varchar(255)
  • createdAt (생성일) — datetime
  • modifiedAt (수정일) — datetime
  • address (주소) — varchar(255)
  • zipcode (우편번호) — varchar(255)

Event (이벤트)

  • EventId (eventId) — bigint — Primary key — NOT NULL
  • Title (제목) — varchar(20) — NOT NULL
  • content (본문) — varchar(255)
  • eventTitleImageUrl (이벤트 배너 이미지) — varchar(255)
  • eventContentImageUrl (이벤트 본문 이미지) — varchar(255)
  • createdAt (생성 시간) — datetime
  • modifiedAt (수정시간) — datetime
  • eventStatus (이벤트 상태) — varchar(255)
  • end_at (이벤트종료시간) — varchar(255)

Item (상품)

  • itemId — bigint — Primary key — NOT NULL
  • itemTitle (제품 제목) — varchar(255)
  • tagList (태그 값) — varchar(255)
  • price (가격) — varchar(255)
  • contentImageUrl (본문설명 이미지) — varchar(255)
  • content (본문) — varchar(255)
  • titleImageUrl (제품 이미지) — varchar(255)
  • rating (별점) — int
  • salesCount (판매된 수량) — int
  • categoryKRName (한글 카테고리) — varchar(255)
  • categoryENName (영문 카테고리) — varchar(255)
  • createdAt (Field) — datetime
  • modifiedAt (Field2) — datetime

Member (멤버)

  • memberId — bigint — Primary key — NOT NULL
  • name (실명) — varchar(255)
  • accountId (ID) — varchar(255)
  • password (비밀번호) — varchar(255)
  • email (이메일) — varchar(255)
  • birthdate (생년월일) — varchar(255)
  • phoneNumber (휴대폰) — varchar(255)
  • tagList (태그값) — table
  • memberReserve (적립금) — int
  • createdAt (생성일) — datetime
  • modifiedAt (수정일) — datetime

Order (주문)

  • orderId (Key) — bigint — Primary key — NOT NULL
  • memberId — bigint — Foreign key → Member.memberId — NOT NULL
  • orderStatus (주문 상태) — varchar(255)
  • reserve (총 적립 금액) — int
  • totalPrice (총결제금액) — int
  • createdAt (생성일) — datetime
  • modifiedAt (수정일) — datetime

Order_Item (주문_상품)

  • orderItemId — bigint — Primary key — NOT NULL
  • orderId (Key) — bigint — Foreign key → Order.orderId — NOT NULL
  • itemId — bigint — Foreign key → Item.itemId — NOT NULL
  • itemCount (수량) — int
  • itemTotalPrice (총 금액) — int
  • createdAt (생성일) — datetime
  • modifiedAt (수정일) — datetime
  • isReviewed (리뷰여부) — boolean

Review (리뷰)

  • reviewId — bigint — Primary key — NOT NULL
  • memberId — bigint — Foreign key → Member.memberId — NOT NULL
  • itemId — bigint — Foreign key → Item.itemId — NOT NULL
  • reviewTitle (제목) — varchar(255)
  • reviewContent (본문) — varchar(255)
  • reviewRating (별점) — float
  • createdAtt (생성일) — datetime
  • modifiedAt (수정일) — datetime

Subscribe (구독)

  • subscribeId — bigint — Primary key — NOT NULL
  • memberId — bigint — Foreign key → Member.memberId — NOT NULL
  • isSubscribed (구독 여부) — boolean
  • sampleCount (샘플받은개수) — int
  • createdAt (생성일) — datetime
  • modifiedAt (수정일) — datetime
  • totalDeliveryDiscout (배송할인) — int
  • reserveProfit (추가적립) — int
  • subscribedDate (구독일) — datetime
  • sid (결제아이디) — varchar(255)