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