moseory

moseory erd

Tables (12)

high_category (상위 카테고리)

  • code (상위카테고리코드) — varchar2(50) — Primary key — NOT NULL
  • name (상위카테고리이름) — varchar2(50) — NOT NULL

low_category (하위 카테고리)

  • code (하위카테고리코드) — varchar2(50) — Primary key — NOT NULL
  • high_code (상위카테고리코드) — varchar2(50) — Foreign key → high_category.code — NOT NULL
  • name (하위카테고리이름) — varchar2(50) — NOT NULL

member (회원)

  • id (회원ID) — varchar2(50) — Primary key — NOT NULL
  • password (비밀번호) — varchar2(50) — NOT NULL
  • name (이름) — varchar2(50) — NOT NULL
  • password_check (비밀번호 확인 답변) — varchar2(255) — NOT NULL
  • zipcode (우편번호) — varchar2(50) — NOT NULL
  • address1 (주소1) — varchar2(255) — NOT NULL
  • address2 (주소2) — varchar2(255) — NOT NULL
  • phone (핸드폰번호) — varchar2(20) — NOT NULL
  • email (이메일) — varchar2(255) — NOT NULL
  • joindate (가입일) — date
  • point (적립금) — number
  • amount (총구매금액) — number
  • enabled (계정 사용 가능 여부) — char(1) — NOT NULL

order (주문)

  • no (주문번호) — number — Primary key — NOT NULL
  • member_id (회원ID) — varchar2(50) — Foreign key → member.id — NOT NULL
  • order_date (주문일자) — date — NOT NULL
  • delivery_charge (배송비) — number — NOT NULL
  • state (주문상태) — varchar2(30) — NOT NULL

order_detail (주문 상세 정보)

  • order_no (주문번호) — number — Foreign key → order.no — NOT NULL
  • product_detail_no (상품 상세 정보 번호) — number — Foreign key → product_detail.no — NOT NULL — auto_increment
  • amount (상품 결제 금액) — number — NOT NULL
  • discount (할인 금액) — number — NOT NULL
  • point (적립 금액) — number
  • quantity (수량) — number — NOT NULL

product (상품)

  • code (상품코드) — varchar2(50) — Primary key — NOT NULL
  • name (상품명) — varchar2(250) — NOT NULL
  • price (상품가격) — number — NOT NULL
  • cell_count (상품 판매량) — number — NOT NULL
  • wish_count (관심 상품 등록 개수) — number — NOT NULL
  • grade_avg (평균 평점) — number(1,1) — NOT NULL
  • high_code (상위카테고리코드) — varchar2(50) — Foreign key → high_category.code — NOT NULL
  • low_code (하위카테고리코드) — varchar2(50) — Foreign key → low_category.code — NOT NULL

product_detail (상품 상세 정보)

  • no (상품 상세 정보 번호) — number — Primary key — NOT NULL — auto_increment
  • product_code (상품코드) — varchar2(50) — Foreign key → product.code — NOT NULL
  • product_color (상품 색상) — varchar2(50)
  • product_size (상품 사이즈) — varchar2(50)
  • stock (재고) — number — NOT NULL

qna (Q&A)

  • no (Q&A 번호) — number — Primary key — NOT NULL — auto_increment
  • product_code (상품코드) — varchar2(50) — Foreign key → product.code
  • subject (제목) — varchar2(250) — NOT NULL
  • content (내용) — varchar2(2000) — NOT NULL
  • writer (작성자) — varchar2(50) — NOT NULL
  • regdate (작성일) — date — NOT NULL
  • ucc_url (UCC URL) — varchar2(500)
  • password (비밀번호) — varchar2(50) — NOT NULL — 글과 답글 조회, 수정, 삭제 시 필요한 비밀번호
  • seceret (공개/비공개) — boolean — NOT NULL
  • hit (조회수) — number — NOT NULL
  • reply_count (댓글수) — number — NOT NULL
  • group (원글 그룹) — number — NOT NULL
  • depth (글 단계) — number — NOT NULL
  • step (글순서) — number — NOT NULL
  • pseq (원글 번호) — number — NOT NULL
  • answer (답글개수) — number — NOT NULL

qna_reply (Q&A 댓글)

  • no (댓글 번호) — number — Primary key — NOT NULL — auto_increment
  • qna_no (Q&A 번호) — number — Foreign key → qna.no — NOT NULL — auto_increment
  • writer (댓글 작성자) — varchar2(50) — NOT NULL
  • reply (댓글) — varchar2(2000) — NOT NULL
  • password (비밀번호) — varchar2(50) — NOT NULL — 댓글 수정, 삭제시 필요한 비밀번호
  • regdate (작성일) — date — NOT NULL

review (리뷰)

  • no (리뷰 번호) — number — Primary key — NOT NULL — auto_increment
  • product_code (상품코드) — varchar2(50) — Foreign key → product.code — NOT NULL
  • member_height (신장) — varchar2(10)
  • member_weight (몸무게) — varchar2(10)
  • content (내용) — varchar2(2000) — NOT NULL
  • file_path (첨부파일) — varchar2(500)
  • writer (작성자) — varchar2(50) — NOT NULL
  • regdate (작성일) — date — NOT NULL
  • grade (평점) — number — NOT NULL
  • hit (조회수) — number — NOT NULL
  • reply_count (댓글 개수) — number — NOT NULL
  • like_count (좋아요 개수) — number — NOT NULL

shopping_cart (장바구니)

  • no (장바구니 번호) — number — Primary key — NOT NULL — auto_increment
  • member_id (회원ID) — varchar2(50) — Foreign key → member.id — NOT NULL
  • product_detail_no (상품 상세 정보 번호) — number — Foreign key → product_detail.no — NOT NULL — auto_increment
  • quantity (수량) — number — NOT NULL

wish_list (관심상품)

  • member_id (회원ID) — varchar2(50) — Foreign key → member.id — NOT NULL
  • product_code (상품코드) — varchar2(50) — Foreign key → product.code — NOT NULL