newbalance

Tables (18)

Coupon (쿠폰 테이블)

  • coupon_id (쿠폰아이디) — Primary key — NOT NULL
  • use_member_id (회원아이디) — Foreign key → Member.member_id — NOT NULL
  • coupon_benefit (쿠폰혜택)
  • coupon_title (쿠폰이름)
  • coupon_period (쿠폰 사용기간)
  • coupon_code (쿠폰 코드)
  • created_date (등록날짜)
  • created_by (등록자)
  • modified_date (수정날짜)
  • modified_by (수정자)
  • coupon_status (쿠폰 상태 값)

FAQ (FAQ 테이블)

  • faq_id (FAQ 아이디) — Primary key — NOT NULL
  • faq_question (FAQ 질문)
  • faq_answer (FAQ 답변)
  • created_date (등록날짜)
  • created_by (등록자)
  • modified_date (수정날짜)
  • modified_by (수정자)

Member (회원테이블)

  • member_id (회원 고유번호) — Primary key — NOT NULL
  • id (아이디) — NOT NULL
  • password (비밀번호) — NOT NULL
  • name (이름) — NOT NULL
  • email (이메일) — NOT NULL
  • sex (성별) — NOT NULL
  • year_of_birth (출생년도) — NOT NULL
  • createdby (생성자) — NOT NULL
  • created_date (생성날짜) — NOT NULL
  • phone_number (전화번호) — NOT NULL
  • member_grade (회원등급) — NOT NULL

Order_Cancel (주문 취소 테이블)

  • order_cancel_id (주문 취소 아이디) — Primary key — NOT NULL
  • order_id (주문아이디) — Foreign key → Orders.order_id — NOT NULL
  • cancel_date (취소 신청 날짜)
  • cancel_status (주문 취소 상태 값)
  • cancel_price (취소금액)

Orders (주문 테이블)

  • order_id (주문아이디) — Primary key — NOT NULL
  • member_id (회원아이디) — Foreign key → Member.member_id — NOT NULL
  • product_id (상품아이디) — Foreign key → Product.product_id — NOT NULL
  • order_code (주문번호)
  • order_price (주문금액)
  • order_date (주문일시)
  • order_payment (결제방법)
  • order_status (주문상태)

Product (상품테이블)

  • product_id (상품아이디) — Primary key — NOT NULL
  • category_id (카테고리 고유번호) — Foreign key → category.category_id — NOT NULL
  • product_title (상품이름)
  • product_content (상품내용)
  • product_price (상품가격)
  • created_date (등록날짜)
  • created_by (등록자)
  • modified_date (수정날짜)
  • modified_by (수정자)
  • product_code (스타일코드)
  • product_contry (제조국)
  • manufacture_date (제조년월)
  • material (소재)
  • features (상품 특징)
  • Field
  • Field2

Product_inquiry (상품문의)

  • inquiry_id (Key) — Primary key — NOT NULL
  • product_id (상품아이디) — Foreign key → Product.product_id — NOT NULL
  • category_id (카테고리 고유번호) — Foreign key → Product.category_id — NOT NULL
  • inquiry_title (문의제목)
  • inquiry_content (문의내용)
  • inquiry_image (이미지 경로)
  • inquiry_status (공개여부)

Product_opt (옵션테이블)

  • option_id (옵션아이디) — Primary key — NOT NULL
  • product_id (상품아이디) — Foreign key → Product.product_id — NOT NULL
  • color (색상)
  • size (사이즈)
  • quantity (수량)

category (카테고리 테이블)

  • category_id (카테고리 고유번호) — Primary key — NOT NULL
  • category_name (카테고리 명)
  • category_ref (카테고리 그룹)
  • category_step (카테고리 계층)

comment (댓글 테이블)

  • comment_id (Key) — Primary key — NOT NULL
  • product_review_id (Key2) — Foreign key → product_review.product_review_id — NOT NULL
  • member_id (회원아이디) — Foreign key → Member.member_id — NOT NULL
  • answer_num (해당댓글의 자식댓글 수)
  • comment_content (댓글 내용)
  • del_yn (삭제여부)
  • modified_date (수정날짜)
  • modifiend_by (수정자)
  • created_date (등록날짜)
  • created_by (등록자)
  • parent_num (부모댓글 아이디)
  • ref (댓글 그룹 번호)
  • ref_order (댓글 그룹 순서)
  • step (댓글 계층)

delivery_addr (배송지 테이블)

  • delivery_addr_id (Key) — Primary key — NOT NULL
  • member_id (회원아이디) — Foreign key → Member.member_id — NOT NULL
  • name (수령인 이름)
  • zipcode (우편번호)
  • addr (주소)
  • addr_detail (상세주소)
  • tel (수령인 전화번호)
  • req (요청사항)

favorite (관심상품)

  • favorite_id (관심상품 아이디) — Primary key — NOT NULL
  • member_id (회원아이디) — Foreign key → Member.member_id — NOT NULL
  • product_id (상품아이디) — Foreign key → Product.product_id — NOT NULL
  • category_id (카테고리 고유번호) — Foreign key → Product.category_id — NOT NULL

file_info (파일 정보 테이블)

  • file_id (Key) — Primary key — NOT NULL
  • file_path (파일 경로)

notice (공지사항 테이블)

  • notice_id (공지사항 아이디) — Primary key — NOT NULL
  • notice_title (공지사항 제목)
  • created_date (등록날짜)
  • created_by (등록자)
  • modified_date (수정날짜)
  • modified_by (수정자)
  • notice_count (조회수)

product_image (상품 이미지 테이블)

  • product_id (상품 아이디) — Foreign key → Product.product_id — NOT NULL
  • file_id (파일 아이디) — Foreign key → file_info.file_id — NOT NULL

product_review (Untitled)

  • product_review_id (Key) — Primary key — NOT NULL
  • product_id (상품아이디) — Foreign key → Product.product_id — NOT NULL
  • review_content (리뷰내용)
  • score (별점)
  • created_date (등록날짜)
  • created_by (등록자)

review_image (리뷰 이미지 테이블)

  • product_review_id (Key) — Foreign key → product_review.product_review_id — NOT NULL
  • file_id (Key2) — Foreign key → file_info.file_id — NOT NULL

today_product (오늘 본 상품)

  • today_product_id (Key) — Primary key — NOT NULL
  • member_id (회원아이디) — Foreign key → Member.member_id — NOT NULL
  • product_id (상품아이디) — Foreign key → Product.product_id — NOT NULL
  • category_id (카테고리 고유번호) — Foreign key → Product.category_id — NOT NULL