couppang

Tables (4)

coupon (쿠폰)

  • coupon_id (쿠폰ID) — BIGINT — Primary key — NOT NULL
  • user_id (유저ID) — BIGINT — Foreign key → user.user_id — NOT NULL
  • coupon_name (쿠폰 이름) — VARCHAR(50)
  • off (할인율) — BIGINT
  • status (쿠폰상태) — VARCAHR(50)
  • exrp_date (만료일) — DATETIME
  • used_count (현재 발급된 수량) — BIGINT
  • max_count (최대 수량) — BIGINT

product (상품)

  • product_id (상품ID) — BIGINT — Primary key — NOT NULL
  • user_id (유저ID) — BIGINT — Foreign key → user.user_id — NOT NULL
  • product_name (상품명) — VARCHAR(20)
  • contents (상품 설명) — VARCHAR(100)
  • price (가격) — BIGINT

search (검색)

  • search_id (검색ID) — BIGINT — Primary key — NOT NULL
  • searct_text (검색어) — VARCHAR(255)
  • count (검색횟수) — BIGINT

user (회원)

  • user_id (유저ID) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(100)
  • password (비밀번호) — VARCHAR(255)
  • user_name (이름) — VARCHAR(20)