actsmall
테이블 (14)
검색 (search)
- search_id — INT — 기본 키 — NOT NULL
- user_id — Int — 외래 키 → 회원.user_id — NOT NULL
- search_content — VARCHAR(255) — NOT NULL
- searched_at — TIMESTAMP
로그인 히스토리 (login_history)
- login_id — INT — 기본 키
- user_id — Int — 외래 키 → 회원.user_id — NOT NULL
- ip_address — VARCHAR(45)
- user_agent — VARCHAR(255)
- success — BOOLEAN — NOT NULL
- reason — VARCHAR(255)
- login_time — TIMESTAMP
리뷰 (review)
- review_id — INT — 기본 키
- user_id — Int — 외래 키 → 회원.user_id — NOT NULL
- product_id — INT — 외래 키 → 상품.product_id
- content — TEXT
- rate — ENUM('0', '1', '2', '3', '4', '5') — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
배송지 (delivery_address)
- delivery_id — INT — 기본 키 — NOT NULL
- user_id — Int — 외래 키 → 회원.user_id — NOT NULL
- receiver_address — VARCHAR(255) — NOT NULL
- receiver_name — VARCHAR(100) — NOT NULL
- receiver_phone — VARCHAR(20) — NOT NULL
- is_default — BOOLEAN — NOT NULL
상품 (product)
- product_id — INT — 기본 키
- category_id — INT — 외래 키 → 카테고리.category_id
- product_name — VARCHAR(150) — NOT NULL
- product_price — INT — NOT NULL
- quantity — INT
- thumbnail_img — VARCHAR(255)
- detail_img — VARCHAR(255)
- shipping_fee — INT
- shipping_addition_flag — BOOLEAN
- shipping_addition_fee (shippng_addition_fee) — INT
- issac_point — INT
- seller_id — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
상품옵션 (product_option)
- option_id — INT — 기본 키
- product_id — INT — 외래 키 → 상품.product_id
- option_name — VARCHAR(100) — NOT NULL
- option_type — ENUM('COLOR', 'SIZE')
- quantity — INT — NOT NULL
세션키 (session)
- token — CHAR(64) — 기본 키
- user_id — Int — 외래 키 → 회원.user_id — NOT NULL
- expired_date — DATETIME — NOT NULL
- created_at — TIMESTAMP
위시리스트 (wishlist)
- user_id — Int — 외래 키 → 회원.user_id — NOT NULL
- product_id — INT — 외래 키 → 상품.product_id
- created_at — TIMESTAMP
주문 (order)
- order_id — INT — 기본 키 — NOT NULL
- user_id — Int — 외래 키 → 회원.user_id — NOT NULL
- delivery_id — INT — 외래 키 → 배송지.delivery_id — NOT NULL
- price — INT — NOT NULL
- status — ENUM('PENDING', 'PAID', 'CANCELED', 'SHIPPED', 'DELIVERED') — NOT NULL
- payment_method — VARCHAR(50) — NOT NULL
- agreed_terms — BOOLEAN — NOT NULL
- cash_receipt_type — ENUM('PERSONAL', 'BUSINESS')
- cash_receipt_number — VARCHAR(50)
- receiver_name — VARCHAR(100) — NOT NULL
- receiver_phone — VARCHAR(20) — NOT NULL
- receiver_address — VARCHAR(255) — NOT NULL
- delivery_memo — VARCHAR(255)
- order_date — DATETIME
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
주문상세 (order_detail)
- order_detail_id — INT — 기본 키 — NOT NULL
- order_id — INT — 외래 키 → 주문.order_id — NOT NULL
- product_id — INT — 외래 키 → 상품.product_id
- option_id — INT — 외래 키 → 상품옵션.option_id
- quantity — INT — NOT NULL
- price — INT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
최근 본 상품 (recently_viewed)
- user_id — Int — 외래 키 → 회원.user_id — NOT NULL
- product_id — INT — 외래 키 → 상품.product_id
- viewed_at — TIMESTAMP — NOT NULL
카테고리 (product_category)
- category_id — INT — 기본 키
- category_name — VARCHAR(100) — NOT NULL
- parent_category_id — INT
포인트 (point)
- point_id — INT — 기본 키
- user_id — Int — 외래 키 → 회원.user_id — NOT NULL
- product_id — INT — 외래 키 → 상품.product_id
- points — INT — NOT NULL
- reason — VARCHAR(255)
- created_at — TIMESTAMP
회원 (user)
- user_id — Int — 기본 키 — NOT NULL
- id — VARCHAR(50)
- password — VARCHAR(255)
- user_name — VARCHAR(100)
- address — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP