찜콩몰
테이블 (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