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 — 상품문의/배송문의/기타문의