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