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