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)