coupong

Tables (12)

basket (장바구니)

  • 멤버ID (member_id) — int — Foreign key → member.멤버ID — NOT NULL
  • 상품ID (item_id) — int — Foreign key → item.상품ID — NOT NULL
  • 수량 (quantity) — int
  • 생성일시 (created_at) — timestamp
  • 수정일시 (updated_at) — timestamp

category (카테고리)

  • 카테고리ID (category_id) — int — Primary key — NOT NULL
  • 상위카테고리ID (parent_category_id) — int
  • 카테고리명 (category_name) — varchar(100)
  • 사용여부 (use_yn) — char(1)
  • 생성일시 (created_at) — timestamp
  • 수정일시 (updated_at) — timestamp

coupon (쿠폰)

  • 쿠폰ID (coupon_id) — int — Primary key — NOT NULL
  • 쿠폰명 (name) — varchar(20)
  • 할인률 (discount_percent) — int
  • 최대할인가격 (max_price) — int
  • 총개수 (total_amount) — int
  • 상태 (status) — int
  • 적용일시 (apply_at) — timestamp
  • 만료일시 (expire_at) — timestamp
  • 생성일시 (created_at) — timestamp
  • 수정일시 (updated_at) — timestamp

issue_coupon (쿠폰발급)

  • 쿠폰발급ID (issue_coupon_id) — int — Primary key — NOT NULL
  • 쿠폰ID (coupon_id2) — int — Foreign key → coupon.쿠폰ID — NOT NULL
  • 멤버ID (member_id) — int — Foreign key → member.멤버ID — NOT NULL
  • 상태 (status) — int
  • 사용일시 (used_at) — timestamp
  • 생성일시 (created_at) — timestamp

item (상품)

  • 상품ID (item_id) — int — Primary key — NOT NULL
  • 상품RID (item_rid) — int
  • 상품명 (item_name) — varchar(100)
  • 가격 (price) — int
  • 재고 (remains) — int
  • 주문수 (order_count) — int
  • 상태 (status) — int
  • 정보 (info) — varchar(500)
  • 사진URL (image_url) — varchar(200)
  • 카테고리ID (category_id) — int — Foreign key → category.카테고리ID — NOT NULL
  • 생성일시 (created_at) — timestamp
  • 생성자 (created_by) — int
  • 수정일시 (updated_at) — timestamp

member (멤버)

  • 멤버ID (member_id) — int — Primary key — NOT NULL
  • 이메일 (email) — varchar(30)
  • 비밀번호 (password) — varchar(255)
  • 닉네임 (nickname) — varchar(100)
  • IP (ip) — char(15)
  • 핸드폰번호 (phone_number) — varchar(32)
  • 생성일시 (created_at) — timestamp
  • 수정일시 (updated_at) — timestamp
  • 탈퇴일시 (leaved_at) — timestamp
  • 권한ID (role_id) — int — Foreign key → role.권한ID — NOT NULL

order (주문)

  • 주문ID (order_id) — int — Primary key — NOT NULL
  • 주문RID (order_rid) — char(32)
  • 멤버ID (member_id) — int — Foreign key → member.멤버ID — NOT NULL
  • 주소 (address) — varchar(255)
  • 상태 (status) — int
  • 사용한쿠폰ID (used_coupon_id) — int
  • 생성일시 (created_at) — timestamp
  • 수정일시 (updated_at) — timestamp

order_item (주문상품)

  • 주문ID (order_id) — int — Foreign key → order.주문ID — NOT NULL
  • 상품ID (item_id) — int — Foreign key → item.상품ID — NOT NULL
  • 상품주문수량 (item_quantity) — int

qna (질의응답)

  • 질의응답ID (qna_id) — int — Primary key — NOT NULL
  • 상위질의응답ID (parent_qna_id) — int
  • 멤버ID (member_id) — int — Foreign key → member.멤버ID — NOT NULL
  • 상품ID (item_id) — int — Foreign key → item.상품ID — NOT NULL
  • 제목 (title) — varchar(100)
  • 내용 (content) — varchar(1000)
  • 생성일시 (created_at) — timestamp
  • 수정일시 (updated_at) — timestamp

review (리뷰)

  • 리뷰ID (review_id) — int — Primary key — NOT NULL
  • 멤버ID (member_id) — int — Foreign key → member.멤버ID — NOT NULL
  • 상품ID (item_id) — int — Foreign key → item.상품ID — NOT NULL
  • 제목 (title) — varchar(100)
  • 내용 (content) — varchar(1000)
  • 사진URL (image_url) — varchar(200)
  • 별점 (star) — int
  • 생성일시 (created_at) — timestamp
  • 수정일시 (updated_at) — timestamp

role (권한)

  • 권한ID (role_id) — int — Primary key — NOT NULL
  • 권한 (role) — varchar(10)

token (토큰)

  • 멤버ID (member_id) — int — Foreign key → member.멤버ID — NOT NULL
  • 접근토큰 (atk) — varchar(256)
  • 접근토큰유효시간 (atk_valid_at) — timestamp
  • 재발급토큰 (rtk) — varchar(256)
  • 재발급토근유효시간 (rtk_valid_at) — timestamp