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