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