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
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
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