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 — 마지막 로그인 일자