찜콩몰

테이블 (14)

Categories

  • categoryId (카테고리Id) — BIGINT — 기본 키 — NOT NULL
  • parentId (부모카테고리ID) — BIGINT — 외래 키 → Categories.categoryId — NOT NULL
  • code (카테고리관리코드) — VARCHAR(255)
  • name (카테고리이름) — VARCHAR(255) — NOT NULL
  • depth (카테고리 뎁스) — INT — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME

Options

  • optionId (옵션ID) — BIGINT — 기본 키 — NOT NULL
  • name (옵션이름) — VARCHAR(255) — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME

Orders

  • orderId (주문ID) — BIGINT — 기본 키 — NOT NULL
  • userId (유저ID) — BIGINT — 외래 키 → Users.userId — NOT NULL
  • orderNumber (주문번호) — VARCHAR(255) — NOT NULL
  • totalAmount — DECIMAL(10, 2) — NOT NULL
  • discountAmount — DECIMAL(10, 2)
  • paymentAmount — DECIMAL(10, 2) — NOT NULL
  • orderStatus — VARCHAR(50) — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME

Payments

  • paymentId (결제ID) — BIGINT — 기본 키 — NOT NULL
  • orderId (주문ID) — BIGINT — 외래 키 → Orders.orderId — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • paymentStatus — VARCHAR(50) — NOT NULL
  • installmentMonths (할부개월수) — INT
  • paymentMethod (지불방법) — VARCHAR(100)
  • pgProvider — VARCHAR(100)
  • pgTransactionId — VARCHAR(255)
  • pgStatus — VARCHAR(50)
  • cardIssuer — VARCHAR(100)
  • approvalDate — DATETIME
  • createdAt — DATETIME
  • updatedAt — DATETIME

ProductImages

  • imageId (상품이미지ID) — BIGINT — 기본 키 — NOT NULL
  • productId (상품ID) — 외래 키 → Products.productId — NOT NULL
  • imageUrl — VARCHAR(255) — NOT NULL
  • isThumbnail — TINYINT(1) — NOT NULL
  • isDetailImage — TINYINT(1) — NOT NULL
  • isPreviewImage — TINYINT(1) — NOT NULL
  • orderIndex — INT — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME

ProductOptions

  • productOptionId (상품옵션ID) — BIGINT — 기본 키 — NOT NULL
  • productId (상품ID) — 외래 키 → Products.productId — NOT NULL
  • optionId (옵션ID) — BIGINT — 외래 키 → Options.optionId — NOT NULL
  • prodOptionValue (value) — VARCHAR(255) — NOT NULL
  • stock — INT — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME

Products

  • productId (상품Id) — 기본 키 — NOT NULL
  • categoryId (카테고리Id) — BIGINT — 외래 키 → Categories.categoryId — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • stock (재고수량) — BIGINT
  • price — DECIMAL(10, 2) — NOT NULL
  • thumbnailUrl — VARCHAR(255)
  • createdAt — DATETIME
  • updatedAt — DATETIME

Refunds

  • refundId (환불ID) — BIGINT — 기본 키 — NOT NULL
  • orderId (주문ID) — BIGINT — 외래 키 → Orders.orderId — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • refundStatus — VARCHAR(50) — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME

ReviewImages

  • reviewImageId (리뷰이미지ID) — BIGINT — 기본 키 — NOT NULL
  • reviewId (리뷰ID) — BIGINT — 외래 키 → Reviews.reviewId — NOT NULL
  • imageUrl — VARCHAR(255) — NOT NULL
  • imageOrder — INT
  • createdAt — DATETIME
  • updatedAt — DATETIME

Reviews

  • reviewId (리뷰ID) — BIGINT — 기본 키 — NOT NULL
  • productId (상품ID) — 외래 키 → Products.productId — NOT NULL
  • userId (유저ID) — BIGINT — 외래 키 → Users.userId — NOT NULL
  • rating — INT — NOT NULL
  • comment — TEXT — EX
  • createdAt — DATETIME
  • updatedAt — DATETIME

ShippingAddresses

  • addressId (배송주소ID) — BIGINT — 기본 키 — NOT NULL
  • userId (유저ID) — BIGINT — 외래 키 → Users.userId — NOT NULL
  • alias — VARCHAR(255)
  • recipientName (받는사람) — VARCHAR(255) — NOT NULL
  • addressLine1 — VARCHAR(255) — NOT NULL
  • addressLine2 — VARCHAR(255)
  • city — VARCHAR(100) — NOT NULL
  • state — VARCHAR(100) — NOT NULL
  • postalCode (우편번호) — VARCHAR(20) — NOT NULL
  • country — VARCHAR(100) — NOT NULL
  • isDefault (기본주소여부) — TINYINT(1) — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME

SocialAccounts

  • accountId (소셜계정ID) — BIGINT — 기본 키 — NOT NULL
  • userId (유저ID) — BIGINT — 외래 키 → Users.userId — NOT NULL
  • provider (소셜이름) — VARCHAR(50) — NOT NULL
  • socialId (소셜계정 아이디) — VARCHAR(255) — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME

Users

  • userId (유저ID) — BIGINT — 기본 키 — NOT NULL
  • accountName — VARCHAR(255)
  • username — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • birthday — DATETIME
  • phoneNumber — VARCHAR(255)
  • password — VARCHAR(255) — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME

좋아요 관리 테이블 (Likes)

  • likeId (상품좋아요ID) — BIGINT — 기본 키 — NOT NULL
  • userId (유저ID) — BIGINT — 외래 키 → Users.userId — NOT NULL
  • productId (상품ID) — BIGINT — 외래 키 → Products.productId — NOT NULL
  • reviewId (리뷰ID) — BIGINT — 외래 키 → Reviews.reviewId — NOT NULL
  • likeType — VARCHAR(50)
  • createdAt — DATETIME
  • updatedAt — DATETIME