HYOSINSA

Tables (15)

QnA (문의)

  • qna_num (문의번호) — LONG — Primary key — NOT NULL
  • num (회원번호) — VARCHAR(20) — Foreign key → user.num — NOT NULL
  • prd_num (상품번호) — LONG — Foreign key → product.prd_num — NOT NULL
  • category_num (카테고리번호) — LONG — Foreign key → product.category_num — NOT NULL
  • qna_title (문의제목) — VARCHAR(50)
  • qna_content (문의내용) — VARCHAR(1000)
  • qna_regdate (문의작성일) — DATETIME
  • qna_moddate (문의수정일) — DATETIME
  • qna_secret (비밀글여부) — INT
  • qna_answer (답변내용) — VARCHAR(255)
  • qna_check (답변여부) — INT

QnA_imge (문의이미지)

  • qna_img_num (문의이미지번호) — LONG — Primary key — NOT NULL
  • qna_num (문의번호) — LONG — Foreign key → QnA.qna_num — NOT NULL
  • qna_img_name (문의이미지명) — VARCHAR(255)

admin (관리자)

  • adm_num (관리자번호) — LONG — Primary key — NOT NULL
  • adm_id (관리자아이디) — VARCHAR(20)
  • adm_password (관리자비밀번호) — VARCHAR(255)
  • adm_name (관리자이름) — VARCHAR(10)
  • adm_email (관리자이메일) — VARCHAR(50)
  • adm_phone (관리자전화번호) — VARCHAR(20)

board (게시판)

  • board_num (게시글번호) — LONG — Primary key — NOT NULL
  • adm_num (관리자번호) — LONG — Foreign key → admin.adm_num — NOT NULL
  • board_title (게시글제목) — VARCHAR(50)
  • board_content (게시글내용) — VARCHAR(1000)
  • board_category (게시글카테고리) — INT
  • board_regdate (게시글작성일) — DATETIME
  • board_moddate (게시글수정일) — DATETIME
  • board_hit (게시글조회수) — INT

board_image (게시판이미지)

  • board_img_num (게시글이미지번호) — INT — Primary key — NOT NULL
  • board_num (게시글번호) — LONG — Foreign key → board.board_num — NOT NULL
  • board_img_name (게시글이미지명) — VARCHAR(20)

cart (장바구니)

  • cart_num (장바구니번호) — LONG — Primary key — NOT NULL
  • num (회원번호) — LONG — Foreign key → user.num — NOT NULL
  • prd_num (상품번호) — LONG — Foreign key → product.prd_num — NOT NULL
  • category_num (카테고리번호) — INT — Foreign key → product.category_num — NOT NULL
  • cart_quantity (장바구니수량) — INT
  • cart_date (장바구니에담은날짜) — DATETIME

order (주문)

  • ord_num (주문번호) — LONG — Primary key — NOT NULL
  • num (회원번호) — LONG — Foreign key → user.num — NOT NULL
  • prd_num (상품번호) — LONG — Foreign key → product.prd_num — NOT NULL
  • category_num (카테고리번호) — INT — Foreign key → product.category_num — NOT NULL
  • ord_quantity (주문수량) — INT
  • ord_status (주문상태) — INT
  • ord_date (주문날짜) — DATETIME
  • ord_price (주문금액) — INT

product (상품)

  • prd_num (상품번호) — LONG — Primary key — NOT NULL
  • category_num (카테고리번호) — INT — Foreign key → product_category.category_num — NOT NULL
  • prd_name (상품명) — VARCHAR(50)
  • prd_price (가격) — INT
  • prd_content (상품설명) — VARCHAR(1000)
  • prd_regdate (등록일) — DATETIME
  • prd_status (판매상태) — INT

product_category (카테고리)

  • category_num (카테고리번호) — INT — Primary key — NOT NULL
  • category_name (카테고리명) — VARCHAR(20)

product_color (색상)

  • prd_num (상품번호) — LONG — Foreign key → product.prd_num — NOT NULL
  • prd_color (색상명) — VARCHAR(20)

product_images (상품이미지)

  • prd_img_num (상품이미지번호) — LONG — Primary key — NOT NULL
  • prd_num (상품번호) — LONG — Foreign key → product.prd_num — NOT NULL
  • prd_img_name (상품이미지명) — VARCHAR(255)
  • prd_img_thumbnail (대표이미지여부) — INT

product_size (사이즈)

  • prd_num (상품번호) — LONG — Foreign key → product.prd_num — NOT NULL
  • prd_size (사이즈) — VARCHAR(20)

review (리뷰)

  • rev_num (리뷰번호) — LONG — Primary key — NOT NULL
  • prd_num (상품번호) — LONG — Foreign key → product.prd_num — NOT NULL
  • num (회원번호) — LONG — Foreign key → user.num — NOT NULL
  • category_num (카테고리번호) — INT — Foreign key → product.category_num — NOT NULL
  • rev_title (리뷰제목) — VARCHAR(50)
  • rev_content (리뷰내용) — VARCHAR(1000)
  • rev_scope (리뷰별점) — INT
  • rev_ regdate (리뷰작성일) — DATETIME
  • rev_moddate (리뷰수정일) — DATETIME

review_image (리뷰이미지)

  • rev_img_num (리뷰이미지번호) — LONG — Primary key — NOT NULL
  • rev_num (리뷰번호) — LONG — Foreign key → review.rev_num — NOT NULL
  • prd_num (상품번호) — LONG — Foreign key → review.prd_num — NOT NULL
  • num (회원번호) — LONG — Foreign key → review.num — NOT NULL
  • category_num (카테고리번호) — INT — Foreign key → review.category_num — NOT NULL
  • rev_img_name (리뷰이미지명) — VARCHAR(255)

user (회원)

  • num (회원번호) — LONG — Primary key — NOT NULL
  • user_id (유저아이디) — VARCHAR(20)
  • password (비밀번호) — VARCHAR(255)
  • name (이름) — VARCHAR(10)
  • email (이메일) — VARCHAR(50)
  • gender (성별) — INT
  • address (주소) — VARCHAR(255)
  • zip_code (우편번호) — INT
  • phone (전화번호) — VARCHAR(20)
  • regdate (가입일) — DATETIME
  • withdraw (탈퇴여부) — INT