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