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)