쇼핑몰설계 다나와방

테이블 (30)

Members (members)

  • Member Num (member_num) — NUMBER — 기본 키 — NOT NULL — autoincrement
  • Member Name (member_name) — VARCHAR2 — NOT NULL
  • Member ID (member_id) — varchar2 — NOT NULL
  • Member Password (member_password) — VARCHAR2 — NOT NULL
  • Member Email (member_email) — VARCHAR2 — NOT NULL
  • Member Phone (member_phone) — VARCHAR2
  • Member Address (member_address) — varchar2
  • Member Postnum (member_postnum) — varchar2
  • Is Admin (is_admin) — varchar2 — NOT NULL — admin:관리자 user:회원
  • Admin Code (admin_code) — varchar2 — NOT NULL
  • Member Delete (member_delete) — VARCHAR2 — NOT NULL — FALSE:사용자에게 보여짐 TRUE: 관리자에게만 보여짐
  • Created At (created_at) — date — NOT NULL

Order Cancel Products (order_cancel_products)

  • Order Cancel Products Id (order_cancel_product_id) — NUMBER — 기본 키 — NOT NULL — autoincrement
  • Order Cancel Id (order_cancel_id) — NUMBER — 외래 키 → 결제취소.Order Cancel Id — NOT NULL
  • Order Id (order_Id) — NUMBER — 외래 키 → 결제취소.Order Id — NOT NULL
  • Order Product Id (order_product_id) — NUMBER — 외래 키 → 주문상품.Order Product Id — NOT NULL
  • Order Product Option Id (order_product_option_id) — NUMBER — 외래 키 → 주문 상품 옵션.Order Product Option Id — NOT NULL
  • Member Num (member_num) — NUMBER — 외래 키 → 결제취소.Member Num — NOT NULL
  • Order Cancel Product Count (order_cancel_product_count) — NUMBER — NOT NULL

결제 (purchase)

  • Purchase Id (purchase_id) — NUMBER — 기본 키 — NOT NULL — autoincrement
  • Order Id (order_Id) — NUMBER — 외래 키 → 주문.Order Id — NOT NULL
  • Member Num (member_num) — NUMBER — 외래 키 → 주문.Member Num — NOT NULL
  • Purchase Pay (purchase_pay) — NUMBER — NOT NULL
  • Purchase Status (purchase_status) — VARCHAR2 — NOT NULL — complete: 완료, cancel: 취소, error: 에러
  • PG Name (pg_name) — VARCHAR2 — NOT NULL
  • Installment Month (installment_month) — NUMBER
  • Purchase Created At (created_at) — DATE — NOT NULL

결제취소 (order_cancel)

  • Order Cancel Id (order_cancel_id) — NUMBER — 기본 키 — NOT NULL — autoincrement
  • Order Id (order_Id) — NUMBER — 외래 키 → 주문.Order Id — NOT NULL
  • Member Num (member_num) — NUMBER — 외래 키 → 주문.Member Num — NOT NULL
  • Purchase Cancel Reason (purchase_cancel_reason) — VARCHAR2 — NOT NULL
  • Created At (created_at) — DATE — NOT NULL
  • Complete At (complete_At) — DATE — NOT NULL

고객센터 1대1 게시판 (board)

  • CS One to One Id (cs_one_to_one_id) — varchar2 — 기본 키 — NOT NULL
  • CS One to One Reply Id (cs_one_to_one_reply_id) — NUMBER — 외래 키 → 고객센터 1대1 답글.CS One to One Reply Id — NOT NULL
  • Member Num (member_num) — NUMBER — 외래 키 → Members.Member Num — NOT NULL — autoincrement
  • one_board Title (one_board_title) — VARCHAR2
  • one_board Content (one_board_content) — VARCHAR2
  • one_create At (one_create_at) — DATE
  • one_board Writer (one_board_writer) — VARCHAR2
  • one_reply Status (one_reply_status) — VARCHAR2
  • one_board Password (one_board_password) — VARCHAR2
  • one_delete Yn (one_delete_yn) — VARCHAR2

고객센터 1대1 답글 (comment)

  • CS One to One Reply Id (cs_one_to_one_reply_id) — NUMBER — 기본 키 — NOT NULL
  • one_reply Writer (one_reply_writer) — VARCHAR2
  • one_content — VARCHAR2
  • one_create At (one_create_at) — DATE
  • one_reply Info (one_reply_info) — VARCHAR2
  • one_delete Yn (one_delete_yn) — VARCHAR2
  • Member Num (member_num) — NUMBER — 외래 키 → Members.Member Num — NOT NULL — autoincrement

고객센터 FAQ 게시판 (customer service board)

  • CS FAQ Id (cs_faq_id) — number — 기본 키 — NOT NULL
  • CS FAQ Category (cs_faq_category) — varchar2 — 기본 키 — NOT NULL
  • faq_board Title (faq_board_title) — VARCHAR2
  • faq_board Content (faq_board_content) — VARCHAR2
  • faq_delete Yn (faq_delete_yn) — VARCHAR2
  • Member Num (member_num) — NUMBER — 외래 키 → Members.Member Num — NOT NULL — autoincrement

고객센터 공지사항 게시판 (customer notice board)

  • CS Notice Id (cs_notice_id) — varchar2 — 기본 키 — NOT NULL
  • notice_board Title (notice_board_title) — VARCHAR2
  • notice_board Content (notice_board_content) — VARCHAR2
  • notice_create At (notice_create_at) — DATE
  • notice_board Writer (notice_board_writer) — VARCHAR2
  • notice_delete Yn (notice_delete_yn) — VARCHAR2
  • Member Num (member_num) — NUMBER — 외래 키 → Members.Member Num — NOT NULL — autoincrement

교환 (exchange)

  • Exchange Id (exchange_id) — NUMBER — 기본 키 — NOT NULL — autoincrement
  • Take Back Id (take_back_id) — NUMBER — 외래 키 → 반품.Take Back Id — NOT NULL
  • Order Id (order_Id) — NUMBER — 외래 키 → 반품.Order Id — NOT NULL
  • Member Num (member_num) — NUMBER — 외래 키 → 반품.Member Num — NOT NULL
  • Exchange Reason (exchange_reason) — VARCHAR2 — NOT NULL
  • Exchange Status (exchange_status) — VARCHAR2 — NOT NULL — complete: 교환완료, cancel: 교환취소, waiting:교환대기, impossible: 교환불가
  • Created At (created_at) — DATE — NOT NULL
  • Complete At (complete_at) — DATE — NOT NULL

교환 상품 (exchange_products)

  • Exchange Product Id (exchange_product_id) — NUMBER — 기본 키 — NOT NULL — autoincrement
  • Exchange Id (exchange_id) — NUMBER — 외래 키 → 교환.Exchange Id — NOT NULL
  • Take Back Id (take_back_id) — NUMBER — 외래 키 → 교환.Take Back Id — NOT NULL
  • Order Id (order_Id) — NUMBER — 외래 키 → 교환.Order Id — NOT NULL
  • Order Product Id (order_product_id) — NUMBER — 외래 키 → 주문상품.Order Product Id — NOT NULL
  • Order Product Option Id (order_product_option_id) — NUMBER — 외래 키 → 주문 상품 옵션.Order Product Option Id — NOT NULL
  • Member Num (member_num) — NUMBER — 외래 키 → 교환.Member Num — NOT NULL
  • Exchange Product Count (exchange_product_count) — NUMBER — NOT NULL

반품 (take_back)

  • Take Back Id (take_back_id) — NUMBER — 기본 키 — NOT NULL — autoincrement
  • Order Id (order_Id) — NUMBER — 외래 키 → 주문.Order Id — NOT NULL
  • Member Num (member_num) — NUMBER — 외래 키 → 주문.Member Num — NOT NULL
  • Take Back Status (take_back_status) — VARCHAR2 — NOT NULL — complete: 반품완료, cancel: 반품취소, waiting: 반품대기, impossible: 반품불가
  • Created At (created_at) — DATE — NOT NULL
  • Complete At (complete_at) — DATE — NOT NULL

배달원 (delivery_workers)

  • delivery_worker_id — NUMBER — 기본 키 — NOT NULL — autoincrement
  • delivery_company_id — NUMBER — 외래 키 → 배송사.delivery_company_id — NOT NULL — autoincrement
  • delivery_worker_name — varchar2 — NOT NULL
  • delivery_worker_phone — NUMBER — NOT NULL

배송 (deliveries)

  • deliverie_id — NUMBER — 기본 키 — NOT NULL — autoincrement
  • delivery_company_id — NUMBER — 외래 키 → 배송사.delivery_company_id — NOT NULL — autoincrement
  • order_Id — NUMBER — NOT NULL
  • member_id (member_num) — NUMBER — NOT NULL
  • tracking_number — NUMBER — NOT NULL

배송 현황 (delivery_move_progress)

  • delivery_move_progress_id — NUMBER — 기본 키 — NOT NULL — autoincrement
  • deliverie_id (deliverie_id2) — NUMBER — 외래 키 → 배송.deliverie_id — NOT NULL — autoincrement
  • delivery_company_id (delivery_company_id2) — NUMBER — 외래 키 → 배송.delivery_company_id — NOT NULL — autoincrement
  • order_Id — NUMBER — NOT NULL
  • member_id — NUMBER — NOT NULL
  • time — DATE — NOT NULL
  • location — varchar2 — NOT NULL
  • status — varchar2 — NOT NULL

배송사 (delivery)

  • delivery_company_id — NUMBER — 기본 키 — NOT NULL — autoincrement
  • delivery_company_name — varchar2 — NOT NULL
  • delivery_company_phone — varchar2 — NOT NULL

상품 (products)

  • Product Id (product_id) — NUMBER — 기본 키 — NOT NULL — autoincrement
  • Product Name (product_name) — VARCHAR2 — NOT NULL
  • Product Content (product_content) — VARCHAR2
  • Product Status (product_status) — VARCHAR2 — NOT NULL — sales: 판매중, soldout: 품절
  • Product View Status (product_view_status) — VARCHAR2 — NOT NULL — all: 모든 이용자한테 노출, admin: 관리자한테 노출
  • Product Delete (product_delete) — VARCHAR2 — NOT NULL — N:모든 이용자한테 노출, Y:관리자한테 노출
  • Product Created At (product_created_at) — DATE — NOT NULL
  • Product Updated At (product_updated_at) — DATE — NOT NULL
  • Category Id (category_id) — NUMBER — 외래 키 → 상품카테고리.Category Id — NOT NULL — autoincrement
  • Category Code (category_code) — VARCHAR2 — 외래 키 → 상품카테고리.Category Code — NOT NULL — 001002카테고리 001상품 002

상품 옵션 (product_options)

  • Product Option Id (product_option_id) — NUMBER — 기본 키 — NOT NULL — autoincrement
  • Product Id (product_id) — NUMBER — 외래 키 → 상품.Product Id — NOT NULL
  • Product Option Name (product_option_name) — VARCHAR2
  • Product Option Value (product_option_value) — VARCHAR2
  • Product Option Key Value (product_option_key_value) — VARCHAR2
  • Product Option List Price (product_option_list_price) — NUMBER — NOT NULL
  • Product Option Price (product_option_price) — NUMBER — NOT NULL
  • Product Option Status (product_option_status) — VARCHAR2 — NOT NULL — sales: 판매중, soldout: 품절
  • Product Option Type (product_option_type) — VARCHAR2 — NOT NULL — select: 선택, necessary: 필수
  • Product Option Rep (product_option_rep) — VARCHAR2 — NOT NULL — true: 대표, false: 기본
  • Product Option Delete (product_option_delete) — VARCHAR2 — NOT NULL

상품 이미지 파일 (products_files)

  • Products Image Id (products_image_id) — NUMBER — 기본 키 — NOT NULL — autoincrement
  • Product Id (product_id) — NUMBER — 외래 키 → 상품.Product Id — NOT NULL — autoincrement
  • Products Image Type (product_image_type) — VARCHAR2 — thumbnail: 목록 이미지, detail: 상세 이미지, basic: 기본 이미지)
  • Products Image Name (product_image_name) — VARCHAR2 — NOT NULL
  • Product Image Url (product_image_url) — VARCHAR2
  • Product Image Size (product_image_size) — NUMBER — NOT NULL

상품카테고리 (categories)

  • Category Id (category_id) — NUMBER — 기본 키 — NOT NULL — autoincrement
  • Category Code (category_code) — VARCHAR2 — 기본 키 — NOT NULL — 001002카테고리 001상품 002
  • Category Name (category_name) — VARCHAR2 — NOT NULL
  • Category Depth (category_depth) — NUMBER — NOT NULL
  • Cateogry delete (cateogry_delete) — VARCHAR2 — NOT NULL — N:모든 이용자한테 노출, Y:관리자한테 노출

셀프가이드 게시판 (CopyOfcustomer notice board)

  • Self Guide Id (self_guide_id) — number — 기본 키 — NOT NULL
  • self_board Title (self_board_title) — VARCHAR2
  • self_board_thumbnail_image — VARCHAR2 — thumbnail: 목록 이미지, detail: 상세 이미지
  • self_board_board Writer (self_board_board_writer) — VARCHAR2
  • self_board_create At (self_board_create_at) — DATE
  • self_board_delete Yn (self_board_delete_yn) — VARCHAR2
  • Member Num (member_num) — NUMBER — 외래 키 → Members.Member Num — NOT NULL — autoincrement

스토어 게시판 (store board)

  • Store_Id (store_id) — varchar2 — 기본 키 — NOT NULL
  • Member Num (member_num) — NUMBER — 외래 키 → Members.Member Num — NOT NULL — autoincrement
  • Product Id (product_id) — NUMBER — 외래 키 → 상품.Product Id — NOT NULL — autoincrement
  • Store Board Writer (store_board_writer) — VARCHAR2
  • Store Product Price (store_product_price) — NUMBER
  • Store Product Brand (store_product_brand) — VARCHAR2
  • Store Product Option (store_product_option) — VARCHAR2
  • Store Product Sale (store_product_sale) — NUMBER
  • Store Product Status (store_product_status) — VARCHAR2
  • Store Delivery Price (store_delivery_price) — NUMBER
  • Store Board Tip (store_board_tip) — VARCHAR2
  • Store Product Image (store_product_image) — VARCHAR2
  • Store Detail Product Image (store_detail_product_image) — VARCHAR2
  • Store Create At (store_create_at) — DATE
  • Store Delete Yn (store_delete_yn) — VARCHAR2

입고 (Untitled2)

    장바구니 (cart products)

    • Cart Product Id (cart_product_id) — NUMBER — 기본 키 — NOT NULL — autoincrement
    • Member Num (member_num) — NUMBER — 외래 키 → Members.Member Num — NOT NULL — autoincrement
    • Product Option Id (product_option_id) — NUMBER — 외래 키 → 상품 옵션.Product Option Id — NOT NULL — autoincrement
    • Product Id (product_id2) — NUMBER — 외래 키 → 상품 옵션.Product Id — NOT NULL
    • Cart Status (cart_status) — varchar2 — create: 생성, order: 주문, complete: 완료, cancel: 취소
    • Cart Id (cart_id) — NUMBER

    장바구니 옵션 (cart_product_options)

    • Cart Product Option Id (cart_product_option_id) — NUMBER — 외래 키 → 장바구니.Product Option Id — NOT NULL — autoincrement
    • Cart Product Id (cart_product_id) — NUMBER — 외래 키 → 장바구니.Cart Product Id — NOT NULL — autoincrement
    • Member Num (member_num2) — NUMBER — 외래 키 → 장바구니.Member Num — NOT NULL — autoincrement
    • Product Id (product_id2) — NUMBER — 외래 키 → 장바구니.Product Id — NOT NULL
    • Cart Product Option Count (cart_product_option_count) — NUMBER — NOT NULL

    주문 (orders)

    • Order Id (order_Id) — NUMBER — 기본 키 — NOT NULL — autoincrement
    • Member Num (member_num) — NUMBER — 외래 키 → Members.Member Num — NOT NULL
    • Orderer Name (orderer_name) — VARCHAR2 — NOT NULL
    • Orderer Email (orderer_email) — VARCHAR2 — NOT NULL
    • Orderer Phone (orderer_phone) — VARCHAR2 — NOT NULL
    • Orderer Postnum (orderer_postnum) — varchar2
    • Orderer Address (orderer_address) — VARCHAR2 — NOT NULL
    • Orderer Address Detail (orderer_address_detail) — VARCHAR2 — NOT NULL
    • Orderer Request Content (orderer_request_content) — VARCHAR2
    • Delivery Price (delivery_price) — NUMBER — NOT NULL
    • Total Price (total_price) — NUMBER — NOT NULL — 총상품가격 + 배송비- 포인트
    • Pay Type (pay_type) — VARCHAR2 — NOT NULL — credit/debit card: 신용/체크카드, pay:페이
    • Card Type (card_type) — varchar2 — 신용/체크카드
    • Installment (installment) — varchar2 — 100만원이상 결제시 3개월 무이자할부
    • Order Status (order_status) — VARCHAR2 — NOT NULL — waiting: 대기중, order_complete: 주문완료, order_cancel: 주문취소, purchase_complete: 결제완료, purchase_cancel: 결제취소, delivery: 배송중,…
    • Order Created At (created_at) — DATE — NOT NULL
    • complete_date — DATE

    주문 상품 옵션 (order_product_options)

    • Order Product Option Id (order_product_option_id) — NUMBER — 기본 키 — NOT NULL — autoincrement
    • Order Product Id (order_product_id) — NUMBER — 외래 키 → 주문상품.Order Product Id — NOT NULL
    • Product Option Id (product_option_id) — NUMBER — 외래 키 → 상품 옵션.Product Option Id — NOT NULL
    • Order Product Option Name (order_product_option_name) — VARCHAR2 — NOT NULL
    • Order Product Option Value (order_product_option_value) — VARCHAR2 — NOT NULL
    • Order Product Option Price (order_product_option_price) — VARCHAR2 — NOT NULL
    • Order Product Option Key Value (order_product_option_key_value) — VARCHAR2 — NOT NULL
    • Order Product Option Count (order_product_option_count) — NUMBER — NOT NULL
    • Order Product Option Status (order_product_option_status) — VARCHAR2 — NOT NULL — order_cancel: 주문취소, delivery: 배송, delivery_ complete: 배송완료

    주문상품 (orders_products)

    • Order Product Id (order_product_id) — NUMBER — 기본 키 — NOT NULL — autoincrement
    • Order Id (order_Id) — NUMBER — 외래 키 → 주문.Order Id — NOT NULL
    • Member Num (member_num) — NUMBER — 외래 키 → 주문.Member Num — NOT NULL
    • Product Id (product_id) — NUMBER — 외래 키 → 상품 옵션.Product Id — NOT NULL
    • Order Product Name (order_product_name) — VARCHAR2 — NOT NULL
    • Image Name (image_name) — VARCHAR2 — NOT NULL
    • Image Url (image_url) — VARCHAR2 — NOT NULL

    출고 (outbound_shipping)

    • Outbound Id (outbound_id) — NUMBER — 기본 키 — NOT NULL — autoincrement
    • Order Id (order_Id) — NUMBER — 외래 키 → 주문.Order Id — NOT NULL
    • Member Num (member_num) — NUNBER — 외래 키 → 주문.Member Num — NOT NULL
    • delivery_company_id — NUMBER — 외래 키 → 배송사.delivery_company_id — NOT NULL — autoincrement
    • Tracking Number (tracking_number) — NUMBER — NOT NULL
    • Outbound Status (outbound_status) — VARCHAR2 — NOT NULL — true: 출고완료, false: 출고대기중
    • Outbound Created At (outbound_created_at) — DATE — NOT NULL

    프로모션 게시판 (CopyOfCopyOfcustomer notice board)

    • Promotion Id (promotion_id) — number — 기본 키 — NOT NULL
    • promotion_board Title (promotion_board_title) — VARCHAR2
    • promotion_board_thumbnail_image (promotion_image) — VARCHAR2 — thumbnail: 목록 이미지, detail: 상세 이미지
    • promotion_board Writer (promotion_board_writer) — VARCHAR2
    • promotion_board_create At (promotion_board_create_at) — DATE
    • promotion_board_delete Yn (promotion_board_delete_yn) — VARCHAR2
    • Member Num (member_num) — NUMBER — 외래 키 → Members.Member Num — NOT NULL — autoincrement

    회원 별 댓글 (Untitled)

    • Comment Id (comment_id) — NUMBER — 기본 키 — NOT NULL
    • Comment Id (Field) — DATE
    • comment_member_writer — VARCHAR2
    • comment_board_name — VARCHAR2
    • comment_create_at — DATE
    • comment_content — VARCHAR2
    • Member Num (member_num) — NUMBER — 외래 키 → Members.Member Num — NOT NULL — autoincrement