써밋 프로젝트

테이블 (5)

Product_Categories

  • product_id — INT
  • category_id — INT

Products

  • product_id — INT
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • lower_price — DECIMAL(10, 2) — NOT NULL
  • upper_price — DECIMAL(10, 2) — NOT NULL
  • stock — INT — NOT NULL
  • created_at — TIMESTAMP

Transactions

  • transaction_id — INT
  • product_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • purchase_price — DECIMAL(10, 2) — NOT NULL
  • quantity — INT — NOT NULL
  • status — ENUM('PENDING', 'COMPLETED', 'CANCELLED')
  • created_at — TIMESTAMP

관심사 (Interests)

  • interest_id — INT
  • 이름 (name) — VARCHAR(100) — NOT NULL
  • Field

유저 (Users)

  • user_id — INT
  • 이름 (name) — VARCHAR(100) — NOT NULL
  • 이메일 (email) — VARCHAR(150)
  • 전화번호 (phone_number) — VARCHAR(15)
  • 예산 (budget) — DECIMAL(10, 2)
  • created_at — TIMESTAMP
  • 닉네임 (nickname) — VARCHAR(100)