ShoppingMall

Tables (10)

address (주소)

  • address_id (주소아이디) — int — Primary key — NOT NULL — auto_increment
  • address (주소) — varchar(50)
  • is_default (기본배송지) — boolean — NOT NULL
  • zip_code (우편번호) — varchar(8)
  • user_id (아이디) — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디

cart (장바구니)

  • cart_id (장바구니아이디) — int — Primary key — NOT NULL — auto_increment
  • user_id (회원아이디) — varchar(50) — Foreign key → users.user_id — NOT NULL
  • cart_product_quantity (장바구니제품수량) — int
  • product_id (상품아이디) — int — Foreign key → product.product_id — NOT NULL — 상품아이디

category (카테고리)

  • category_id (카테고리아이디) — int — Primary key — NOT NULL — auto_increment
  • category_name (카테고리이름) — varchar(50) — NOT NULL

classification (분류)

  • product_id (상품아이디) — int — Foreign key → product.product_id — NOT NULL — 상품아이디
  • category_id (카테고리아이디) — int — Foreign key → category.category_id — NOT NULL — auto_increment

order (주문)

  • order_id (주문아이디) — int — Primary key — NOT NULL — auto_increment
  • user_id (회원아이디) — varchar(50) — Foreign key → users.user_id — NOT NULL
  • order_quantity (주문수량) — int
  • order_delivery_status (주문배송상태) — enum('배송준비','배송중','배송완료') — 1. 배송준비 / 2. 배송중 / 3. 배송완료
  • order_status (주문상태) — enum('주문','취소','반품') — NOT NULL

orderdetail (주문상세내역)

  • orderdetail_id (주문상세내역아이디) — int — Primary key — NOT NULL — auto_increment
  • orderdetail_date (주문내역날짜) — datetime
  • orderdetail_price (주문내역가격) — int
  • orderdetail_address (주문내역배송지) — varchar(50)
  • orderdetail_quantity (주문내역수량) — int
  • product_id (상품아이디) — int — Foreign key → product.product_id — NOT NULL — auto_increment
  • order_id (주문아이디) — int — Foreign key → order.order_id — NOT NULL — auto_increment

point (포인트)

  • point_id (포인트아이디) — int — Primary key — NOT NULL — auto_increment
  • point_created_at (포인트발생날짜) — datetime — NOT NULL — 사용 혹은 적립 혹은 소멸된 날짜
  • point_amount (포인트금액) — int — NOT NULL — 사용 / 적립 / 소멸 금액
  • point_type (포인트타입) — enum('적립','사용','소멸') — NOT NULL — 1. 적립 / 2. 사용 / 3. 소멸
  • user_id (아이디) — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디

product (상품)

  • product_id (상품아이디) — int — Primary key — NOT NULL — auto_increment
  • product_name (상품이름) — varchar(50) — NOT NULL — 상품이름
  • product_price (상품가격) — int — NOT NULL — 상품가격
  • product_image_url (상품이미지경로) — varchar(255) — 경로
  • product_description (상품설명) — text
  • product_stock (상품재고) — int — NOT NULL
  • product_status (상품상태) — enum('판매중','품절') — 1. 판매중 / 2. 품절
  • product_option (상품옵션) — text — size, color 등

review (리뷰)

  • order_id (주문아이디) — int — Foreign key → order.order_id — NOT NULL — auto_increment
  • rating (별점) — int
  • review_detail (상세리뷰) — text
  • review_image_url (사진리뷰경로) — varchar(255)

users (회원)

  • user_id (아이디) — varchar(50) — Primary key — NOT NULL — 아이디
  • user_name (이름) — varchar(50) — NOT NULL — 이름
  • user_password (비밀번호) — varchar(200) — NOT NULL — mysql password 사용
  • user_birth (생일) — varchar(8) — NOT NULL — 생년월일 : 19840503
  • user_auth (회원종류) — varchar(10) — NOT NULL — 권한: ROLE_ADMIN,ROLE_USER
  • user_point (포인트) — int — NOT NULL — default : 1000000
  • created_at (생성일자) — datetime — NOT NULL — 가입 일자
  • latest_login_at (마지막로그인일자) — datetime — 마지막 로그인 일자