asdf

Tables (20)

item

  • item_no — number — Primary key — NOT NULL
  • category_no — varchar2(30) — NOT NULL
  • item_stock — number — NOT NULL
  • item_brand — varchar2(50) — NOT NULL
  • item_name — varchar2(50) — NOT NULL
  • item_price — number — NOT NULL
  • item_desc — varchar2(1000) — NOT NULL
  • item_enroll_date — date — NOT NULL

item_cart

  • cart_no — number — Primary key — NOT NULL
  • member_id — varchar2(20) — NOT NULL
  • item_no — number — NOT NULL
  • rent_opt_no — varchar2(30) — NOT NULL
  • item_quantity — number — NOT NULL

item_image

  • item_image_no — number — Primary key — NOT NULL
  • item_no — number — NOT NULL
  • item_image_type_no — varchar2(30) — NOT NULL
  • item_image_default — varchar2(100)
  • item_image_renamed — varchar2(100)

item_image_type

  • item_image_type_no — varchar2(30) — Primary key — NOT NULL
  • item_image_type_title — varchar2(30) — NOT NULL — 상품이미지 / 상세설명이미지

item_qna

  • item_qna_no — number — Primary key — NOT NULL
  • member_id — varchar2(20) — NOT NULL
  • item_no — number — NOT NULL
  • item_qna_content — varchar2(3000) — NOT NULL
  • item_qna_ans_yn — char(1) — NOT NULL
  • item_qna_date — date — NOT NULL

item_qna_ans

  • item_qna_ans_no — number — Primary key — NOT NULL
  • item_qna_no — number — NOT NULL
  • item_qna_ans_writer — varchar2(20) — NOT NULL — 관리자
  • item_qna_ans_content — varchar2(3000) — NOT NULL
  • item_qna_ans_date — date — NOT NULL

item_rent_each

  • item_each_no — number — Primary key — NOT NULL
  • item_no — number — NOT NULL
  • item_rent_yn — char(1)
  • rent_opt_no — varchar2(30)
  • item_rent_start — date
  • item_rent_end — date
  • item_rent_user — varchar2(20)

item_rent_option

  • rent_opt_no — varchar2(30) — Primary key — NOT NULL
  • rent_opt — varchar2(30) — NOT NULL — 7일/14일/30일/3개월/6개월.12개월
  • rent_opt_disc_rate — number — NOT NULL — 기간별 고정 할인율 적용

item_review

  • review_no — number — Primary key — NOT NULL
  • order_details_no — number — NOT NULL
  • review_writer — varchar2(20) — NOT NULL
  • review_date — date — NOT NULL
  • review_star — number — NOT NULL
  • review_content — varchar2(1000) — NOT NULL
  • review_image — varchar2(300)
  • review_image_rename — varchar2(300)
  • review_readCount — number — NOT NULL
  • item_no — number

item_when_category

  • category_no — varchar2(30) — Primary key — NOT NULL
  • category_when — varchar2(60) — NOT NULL — 반려동물,육아,파티,운동,여행,캠핑

item_wishlist

  • wish_no — number — Primary key — NOT NULL
  • member_id — varchar2(20) — NOT NULL
  • item_no — number — NOT NULL
  • rent_opt_no — varchar2(30) — NOT NULL

member

  • member_id — varchar2(20) — Primary key — NOT NULL
  • member_name — varchar2(50) — NOT NULL
  • member_password — varchar2(200) — NOT NULL
  • member_phone — varchar2(20) — NOT NULL
  • member_email — varchar2(255) — NOT NULL
  • member_postcode — number — NOT NULL — 우편번호
  • member_address — varchar2(255) — NOT NULL
  • member_detail_address — varchar2(255) — NOT NULL
  • member_hobby1 — varchar2(100)
  • member_hobby2 — varchar2(100)
  • member_quit_yn — char(1) — NOT NULL
  • member_enroll_date — date — NOT NULL

member_point

  • point_no — number — Primary key — NOT NULL
  • member_id — varchar2(20) — NOT NULL
  • point_status — char(1) — NOT NULL — U(사용)/A(적립)
  • point_amount — number — NOT NULL
  • point_change_reason — varchar2(1000) — NOT NULL — 구매/상품 리뷰
  • point_change_date — date — NOT NULL

order_detail

  • order_details_no — number — Primary key — NOT NULL
  • order_no — varchar2(30) — NOT NULL
  • member_id — varchar2(20) — NOT NULL
  • item_no — number
  • rent_opt_no — varchar2(30)
  • order_quantity — number
  • order_status_no — varchar2(30) — NOT NULL
  • review_yn — char(1) — NOT NULL
  • order_cancel_no — varchar2(30)

order_detail_cancel

  • order_cancel_no — varchar2(30) — Primary key — NOT NULL
  • order_cancel_status — varchar2(30) — NOT NULL — 주문취소/상품교환/상품반품

order_sheet

  • order_no — varchar2(30) — Primary key — NOT NULL
  • member_id — varchar2(20) — NOT NULL
  • order_date — date — NOT NULL
  • order_pay_method — varchar2(20) — NOT NULL — 카드/실시간계좌이체/네이버페이?
  • order_pay_status — char(1) — NOT NULL — 결제완료/결제실패
  • order_total_item_ea — number — NOT NULL
  • order_total_price — number — NOT NULL
  • order_use_point — number — NOT NULL
  • imp_uid — varchar2(30)

order_status

  • order_status_no — varchr2(30) — Primary key — NOT NULL
  • order_status — varchar2(30) — NOT NULL — 주문완료/배송준비중/배송중/배송완료/구매확정

personal_qna

  • p_qna_no — number — Primary key — NOT NULL
  • member_id — varchar2(20) — NOT NULL
  • p_qna_type_no — varchar2(30) — NOT NULL
  • p_qna_title — varchar2(100) — NOT NULL
  • p_qna_content — varchar2(3000) — NOT NULL
  • p_qna_date — date — NOT NULL
  • p_ans_yn — char(1) — NOT NULL — 답변대기/답변완료
  • p_qna_image — varchar2(300)

personal_qna_ans

  • p_qna_ans_no — number — Primary key — NOT NULL
  • p_qna_no — number — NOT NULL
  • p_qna_ans_writer — varchar2(20) — NOT NULL — 관리자
  • p_qna_ans_date — date — NOT NULL
  • p_qna_ans_content — varchar2(1000) — NOT NULL

personal_qna_type

  • p_qna_type_no — varchar2(30) — Primary key — NOT NULL
  • p_qna_type — varchar2(30) — NOT NULL — 상품문의/배송문의/기타문의