KREAM-Clone

Tables (14)

account (계좌)

  • id (PK) — String — Primary key — NOT NULL
  • user_id (FK) — String — Foreign key → user.id — NOT NULL
  • bank (Field) — String
  • account_number (Field2) — String
  • depositor (Field3) — String

address (주소)

  • id (PK) — String — Primary key — NOT NULL
  • user_id (FK) — String — Foreign key → user.id — NOT NULL
  • address (Field) — String
  • detail (Field2) — String
  • phone (Field3) — String
  • receiver (Field4) — String

brand (브랜드)

  • id (PK) — String — Primary key — NOT NULL
  • brand (Field) — String

buy_request (구매 요청)

  • id (PK) — String — Primary key — NOT NULL
  • user_id (FK1) — String — Foreign key → user.id — NOT NULL
  • product_id (FK2) — String — Foreign key → product.id — NOT NULL
  • price (Field) — String
  • status (Field2) — String
  • created_at (Field3) — Date
  • updated_at (Field4) — Date

category (메인 카테고리)

  • id (PK) — String — Primary key — NOT NULL
  • category (Field) — String

deal (거래)

  • id (PK) — String — Primary key — NOT NULL
  • buy_request_id (FK1) — String — Foreign key → buy_request.id — NOT NULL
  • sell_request_id (FK2) — String — Foreign key → sell_request.id — NOT NULL
  • status (Field) — String
  • created_at (Field2) — Date
  • updated_at (Field3) — Date

image (상품 이미지)

  • id (PK) — String — Primary key — NOT NULL
  • product_id (FK) — String — Foreign key → product.id — NOT NULL
  • url (Field) — String

payment (결제)

  • id (PK) — String — Primary key — NOT NULL
  • deal_id (FK1) — String — Foreign key → deal.id — NOT NULL
  • user_id (FK2) — String — Foreign key → user.id — NOT NULL
  • payment_method (Field) — String
  • total_price (Field2) — Number
  • status (Field3) — String
  • created_at (Field4) — Date
  • updated_at (Field5) — Date

product (상품)

  • id (PK) — String — Primary key — NOT NULL
  • category_id (FK1) — String — Foreign key → category.id — NOT NULL
  • sub_category_id (FK2) — String — Foreign key → sub_category.id — NOT NULL
  • brand_id (FK3) — String — Foreign key → brand.id — NOT NULL
  • kr_name (Field) — String
  • eng_name (Field2) — String
  • model_number (Field3) — String
  • color (Field4) — String
  • sex (Field5) — String
  • created_at (Field6) — Date
  • updated_at (Field7) — Date

sell_request (판매 요청)

  • id (PK) — String — Primary key — NOT NULL
  • user_id (FK1) — String — Foreign key → user.id — NOT NULL
  • product_id (FK2) — String — Foreign key → product.id — NOT NULL
  • price (Field) — String
  • status (Field2) — String
  • created_at (Field3) — Date
  • updated_at (Field4) — Date

size (상품 사이즈)

  • id (PK) — String — Primary key — NOT NULL
  • product_id (FK) — String — Foreign key → product.id — NOT NULL
  • size (Field) — String
  • price (Field2) — Number

sub_category (서브 카테고리)

  • id (PK) — String — Primary key — NOT NULL
  • category_id (FK) — String — Foreign key → category.id — NOT NULL
  • sub_category (Field) — String

user (회원)

  • id (PK) — String — Primary key — NOT NULL
  • username (Field) — String
  • nickname (Field1) — String
  • email (Field2) — String
  • password (Field3) — String
  • phone (Field4) — String
  • shoe_size (Field5) — String
  • profile_image (Field6) — String
  • provider (Field7) — String
  • point (Field8) — Number
  • created_at (Field9) — Date

wishlist (찜 목록)

  • id (PK) — String — Primary key — NOT NULL
  • user_id (FK1) — String — Foreign key → user.id — NOT NULL
  • product_id (FK2) — String — Foreign key → product.id — NOT NULL