buyon

Tables (7)

Card (card)

  • Key (card_id) — bigint — Primary key — NOT NULL
  • Key (user_id) — Bigint — Foreign key → User.Key — NOT NULL
  • Field (card_company) — varchar(255) — NOT NULL — 카드사

User

  • Key (user_id) — Bigint — Primary key — NOT NULL
  • Field (oauth_id) — varchar(255) — 소셜로그인용
  • Field2 (email) — varchar(255) — NOT NULL
  • Field2 (name) — varchar(255) — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (login_type) — enum('normal', 'kakao') — NOT NULL — 간편로그인 여부
  • Field (password) — varchar(255) — 일반로그인용
  • Field (login_id) — varchar(255) — 일반로그인용
  • Field

alert_log

  • Key (alert_id) — bigint — Primary key — NOT NULL
  • Key (subscription_id) — bigint — Foreign key → subscription.Key — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (alert_type) — enum('lowest_price', 'below_average_price') — NOT NULL

card_discount (CardDiscount)

  • Key (discount_id) — bigint — Primary key — NOT NULL
  • Key (product_id) — bigint — Foreign key → product.Key — NOT NULL
  • Key (card_id) — bigint — Foreign key → Card.Key — NOT NULL
  • Field (discount_percent) — decimal(5,2) — NOT NULL — % 단위 예정
  • Field (start_at) — timestamp — NOT NULL — 할인기간
  • Field (end_at) — timestamp

price_history (priceHistory)

  • Key (history_id) — bigint — Primary key — NOT NULL
  • Key (product_Id) — bigint — Foreign key → product.Key — NOT NULL
  • Field (price) — bigint — NOT NULL
  • Field (created_at) — timestamp — NOT NULL

product

  • Key (product_id) — bigint — Primary key — NOT NULL
  • Field (product_name) — varchar(255) — NOT NULL
  • Field (product_code) — varchar(255) — NOT NULL — 쿠팡API제품코드
  • Field (url) — varchar(2048) — NOT NULL — 리워드 지급을 위한 개별 url

subscription

  • Key (subscription_id) — bigint — Primary key — NOT NULL
  • Key (user_id) — Bigint — Foreign key → User.Key — NOT NULL — unique
  • Key (product_id) — bigint — Foreign key → product.Key — NOT NULL — unique
  • Field (created_at) — timestamp — NOT NULL