Acorn

테이블 (10)

leports (레포츠 상품 정보) (Untitled3)

  • leports_id (Key) — varchar2(255) — 기본 키 — NOT NULL
  • partner_id (Key2) — varchar2(255) — 외래 키 → partner (파트너 정보).partner_id — NOT NULL
  • leports_name (Field) — varchar2(255)
  • leports_main_img (Field2) — varchar2(255)
  • leports_sub_img1 (Field3) — varchar2(255)
  • leports_sub_img2 (Field4) — varchar2(255)
  • leports_sub_img3 (Field5) — varchar2(255)
  • leports_intro (Field6) — varchar2(255)
  • leports_summary (Field7) — varchar2(255)
  • leports_area_code (Field8) — varchar2(255)
  • leports_type_code (Field9) — varchar2(255)
  • leports_price (Field10) — number(8,0)
  • leports_max_capacity (Field11) — number(3,0)
  • leports_regdate (Field12) — date

leports_review (레포츠 상품 리뷰) (Untitled5)

  • review_id (Key) — varchar2(255) — 기본 키 — NOT NULL
  • reserve_id (Key2) — varchar2(255) — 외래 키 → reservation (예약 정보).reserve_id — NOT NULL
  • review_num (Field) — number(8,0)
  • review_comment (Field2) — varchar2(255)
  • review_regdate (Field3) — date

member (회원 정보) (Untitled)

  • user_id (Key) — varchar2(255) — 기본 키 — NOT NULL
  • user_email (Field) — varchar2(255)
  • user_pw (Field2) — varchar2(255)
  • user_name (Field3) — varchar2(255)
  • email_verify (Field4) — number(1,0)
  • partner_verify (Field5) — number(1,0)
  • salt (Field6) — varchar2(255)

partner (파트너 정보) (Untitled2)

  • partner_id (Key) — varchar2(255) — 기본 키 — NOT NULL
  • user_id (Key2) — varchar2(255) — 외래 키 → member (회원 정보).user_id — NOT NULL
  • partner_comname (Field) — varchar2(255)
  • partner_comaddress (Field2) — varchar2(255)
  • partner_detail_comaddress (Field3) — varchar2(255)
  • partner_postnum (Field4) — varchar2(255)
  • partner_business_license (Field5) — varchar2(255)
  • partner_business_license_img (Field6) — varchar2(255)

qa_board (고객센터 게시글) (Untitled6)

  • qa_id (Key) — varchar2(255) — 기본 키 — NOT NULL
  • user_id (Key2) — varchar2(255) — 외래 키 → member (회원 정보).user_id — NOT NULL
  • qa_num (Field) — number(8,0)
  • qa_title (Field2) — varchar2(255)
  • qa_type (Field3) — varchar2(255)
  • qa_content (Field4) — varchar2(255)
  • qa_reserve_id (Field5) — number(8,0)
  • qa_phone (Field6) — varchar2(255)
  • qa_regidate (Field7) — date

qa_board_answer (고객센터 답글) (Untitled7)

  • qa_answer_id (Key) — varchar2(255) — 기본 키 — NOT NULL
  • qa_id (Key2) — varchar2(255) — 외래 키 → qa_board (고객센터 게시글).qa_id — NOT NULL
  • qa_answer_content (Field) — varchar2(255)
  • qa_answer_regdate (Field2) — date

reservation (예약 정보) (Untitled4)

  • reserve_id (Key) — varchar2(255) — 기본 키 — NOT NULL
  • user_id (Key2) — varchar2(255) — 외래 키 → member (회원 정보).user_id — NOT NULL
  • leports_id (Key3) — varchar2(255) — 외래 키 → leports (레포츠 상품 정보).leports_id — NOT NULL
  • reserve_persons (Field) — number(3,0)
  • reserve_name (Field2) — varchar2(255)
  • reserve_phone (Field3) — varchar2(255)
  • reserve_paymethod (Field4) — varchar2(255)
  • reserve_date (Field5) — date

trade_board (중고/대여 거래 게시글) (Untitled8)

  • trade_board_id (Key) — varchar2(255) — 기본 키 — NOT NULL
  • user_id (Key2) — varchar2(255) — 외래 키 → member (회원 정보).user_id — NOT NULL
  • trade_board_num (Field) — number(8,0)
  • trade__main_img (Field2) — varchar2(255)
  • trade_sub_img1 (Field3) — varchar2(255)
  • trade_sub_img2 (Field4) — varchar2(255)
  • trade_sub_img3 (Field5) — varchar2(255)
  • trade_title (Field6) — varchar2(255)
  • trade_description (Field7) — varchar2(255)
  • trade_type (Field8) — varchar2(4)
  • trade_area (Field9) — varchar2(255)
  • trade_phone (Field10) — varchar2(255)
  • trade_price (Field11) — number(8,0)
  • trade_regdate (Field12) — date

trade_board_comment (중고/대여 거래 댓글) (Untitled9)

  • trade_comment_id (Key) — varchar2(255) — 기본 키 — NOT NULL
  • trade_board_id (Key2) — varchar2(255) — 외래 키 → trade_board (중고/대여 거래 게시글).trade_board_id — NOT NULL
  • user_id (Key3) — varchar2(255) — 외래 키 → member (회원 정보).user_id — NOT NULL
  • trade_comment_num (Field) — number(8,0)
  • trade_comment_comments (Field2) — varchar2(255)
  • trade_comment_regidate (Field3) — date

wishlist (위시리스트) (Untitled10)

  • wishlist_id (Key) — varchar2(255) — 기본 키 — NOT NULL
  • user_id (Key2) — varchar2(255) — 외래 키 → member (회원 정보).user_id — NOT NULL
  • leports_id (Key3) — varchar2(255) — 외래 키 → leports (레포츠 상품 정보).leports_id — NOT NULL