shoppingmall

Tables (18)

address (주소)

  • address_id (아이디) — varchar(50) — Primary key — NOT NULL
  • user_id (아이디2) — varchar(50) — Foreign key → user.user_id — NOT NULL
  • recipient_name (수령인 이름) — varchar(20) — NOT NULL
  • street_address (거리 주소) — varchar(50)
  • city (도시) — varchar(50)
  • state (주/도) — varchar(50)
  • postal_code (우편번호) — varchar(20) — NOT NULL
  • country (국가) — varchar(50) — NOT NULL
  • phone_number (수령인 전화번호) — varchar(20) — NOT NULL

auth (권한)

  • auth_id (아이디) — int — Primary key — NOT NULL
  • auth_name (이름) — varchar(10) — NOT NULL

cart_item (장바구니 물건)

  • user_id (아이디) — varchar(50) — Foreign key → user.user_id — NOT NULL
  • product_id (아이디2) — varchar(50) — Foreign key → product.product_id — NOT NULL
  • quantity (상품 수량) — int — NOT NULL
  • added_at (장바구니에 추가된 시각) — datetime — NOT NULL

category (카테고리)

  • category_id (아이디) — int — Primary key — NOT NULL
  • category_name (이름) — varchar(50) — NOT NULL
  • parent_category_id (아이디2) — int — Foreign key → category.category_id — NOT NULL

oder_detail (주문상세)

  • order_id (아이디) — int, auto_increment — Foreign key → order.order_id — NOT NULL
  • product_id (아이디2) — varchar(50) — Foreign key → product.product_id — NOT NULL
  • quantity (주문 수량) — int — NOT NULL
  • price (상품 가격(단가)) — decimal — NOT NULL
  • subtotal (소계(가격 * 수량)) — decimal — NOT NULL

order (주문)

  • order_id (아이디) — int, auto_increment — Primary key — NOT NULL
  • user_id (아이디2) — varchar(50) — Foreign key → user.user_id — NOT NULL
  • order_status_id (아이디3) — int — Foreign key → order_status.order_status_id — NOT NULL
  • total_amount (총 주문 가격) — decimal — NOT NULL
  • created_at (주문 생성일) — datetime — NOT NULL
  • updated_at (주문 수정일) — datetime — NOT NULL
  • recipient_name (수령인 이름) — varchar(20) — NOT NULL
  • street_address (거리 주소) — varchar(50)
  • city (도시) — varchar(50)
  • state (주/도) — varchar(50)
  • postal_code (우편번호) — varchar(20) — NOT NULL
  • country (국가) — varchar(50) — NOT NULL
  • phone_number (수령인 전화번호) — varchar(20) — NOT NULL

order_status (주문상태)

  • order_status_id (아이디) — int — Primary key — NOT NULL
  • order_status_name (이름) — varchar(50) — NOT NULL

payment (결제)

  • payment_id (아이디) — int, auto_increment — Primary key — NOT NULL
  • oder_id (아이디2) — int, auto_increment — Foreign key → order.order_id — NOT NULL
  • payment_method_id (아이디3) — int — Foreign key → payment_method.payment_method_id — NOT NULL
  • payment_status_id (아이디4) — int — Foreign key → payment_status.payment_status_id — NOT NULL
  • amount (결제 금액) — decimal — NOT NULL
  • payment_date (결제 일자) — datetime — NOT NULL

payment_method (결제 방법)

  • payment_method_id (아이디) — int — Primary key — NOT NULL
  • payment_method_name (이름) — varchar(50) — NOT NULL

payment_status (결제 상태)

  • payment_status_id (아이디) — int — Primary key — NOT NULL
  • payment_status_name (이름) — varchar(50) — NOT NULL

point (포인트)

  • point_id (아이디) — int_auto_increment — Primary key — NOT NULL
  • user_id (아이디3) — varchar(50) — Foreign key → user.user_id — NOT NULL
  • point_type_id (아이디2) — int_auto_increment — Foreign key → point_type.point_type_id — NOT NULL
  • related_order_id (아이디4) — int, auto_increment — Foreign key → order.order_id
  • points (포인트 양) — int — NOT NULL
  • created_at (포인트 사용/적립 시간) — datetime — NOT NULL
  • description (비고) — text

point_type (포인트 타입)

  • point_type_id (아이디) — int_auto_increment — Primary key — NOT NULL
  • point_type_name (이름) — varchar(20) — NOT NULL

product (상품)

  • product_id (아이디) — int — Primary key — NOT NULL
  • product_status_id (아이디2) — int — Foreign key → product_status.product_status_id — NOT NULL
  • product_name (이름) — varchar(50) — NOT NULL
  • thumbnail (상품 섬네일) — varchar(200) — NOT NULL
  • product_desc (설명) — text
  • product_price (상품 가격) — decimal
  • stock_quantity (재고 수량) — int
  • created_at (상품 등록일) — datetime — NOT NULL
  • updated_at (상품 수정일) — datetime — NOT NULL

product_category (상품_카데고리)

  • category_id (아이디) — int — Foreign key → category.category_id — NOT NULL
  • product_id (아이디2) — varchar(50) — Foreign key → product.product_id — NOT NULL

product_image (상품 이미지)

  • product_image_id (아이디) — int — Primary key — NOT NULL
  • product_id (아이디2) — varchar(50) — Foreign key → product.product_id — NOT NULL
  • image (이미지 주소) — varchar(200) — NOT NULL

product_status (상품 상태)

  • product_status_id (아이디) — int — Primary key — NOT NULL
  • product_status_name (이름) — varchar(50) — NOT NULL

review (리뷰)

  • review_id (아이디) — int, auto_increment — Primary key — NOT NULL
  • product_id (아이디2) — varchar(50) — Foreign key → product.product_id — NOT NULL
  • user_id (아이디3) — varchar(50) — Foreign key → user.user_id — NOT NULL
  • rating (평점) — int(1~5) — NOT NULL
  • comment (리뷰 내용) — text — NOT NULL
  • created_at (리뷰 작성일) — datetime — NOT NULL

user (회원)

  • user_id (아이디) — varchar(50) — Primary key — NOT NULL
  • auth_id (아이디2) — int — Foreign key → auth.auth_id — NOT NULL
  • user_name (이름) — varchar(50) — NOT NULL
  • user_password (비밀번호) — varchar(200) — NOT NULL
  • user_birth (생일) — varchar(8) — NOT NULL
  • user_auth (권한) — varchar(10) — NOT NULL
  • user_point (포인트) — int — NOT NULL
  • created_at (가입일자) — datetime — NOT NULL
  • latest_login_at (마지막 로그인 일자) — datetime