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