PickPick

테이블 (12)

PP_bung

  • Key (bung_num) — NUMBER(20) — 기본 키 — NOT NULL
  • res_num — NUMBER(20) — 외래 키 → PP_reservation.res_num — NOT NULL
  • suk_num — NUMBER(20) — 외래 키 → PP_sukso.suk_num — NOT NULL
  • mem_id — VARCHAR2(20) — 외래 키 → 멤버 기본 정보.mem_id — NOT NULL
  • bung_title — VARCHAR2(20) — NOT NULL
  • bung_contents — VARCHAR2(3000) — NOT NULL
  • bung_inputdate — DATE
  • bung_cate — VARCHAR2(30)

PP_message

  • msg_num — NUMBER(20) — 기본 키 — NOT NULL
  • mem_id — VARCHAR2(20) — 외래 키 → 멤버 기본 정보.mem_id — NOT NULL
  • suk_num — NUMBER(20) — 외래 키 → PP_sukso.suk_num — NOT NULL
  • msg_title — VARCHAR2(300) — NOT NULL
  • sender_mem_id — VARCHAR2(20) — NOT NULL
  • receiver_mem_id — VARCHAR2(20) — NOT NULL
  • msg_contents — VARCHAR2(3000) — NOT NULL
  • msg_date — DATE

PP_reservation

  • res_num — NUMBER(20) — 기본 키 — NOT NULL
  • mem_id — VARCHAR2(20) — 외래 키 → 멤버 기본 정보.mem_id — NOT NULL
  • res_inputdate — DATE
  • res_resdate — DATE — NOT NULL
  • res_outdate — DATE — NOT NULL
  • res_pop — NUMBER(5) — NOT NULL
  • res_parking — NUMBER(1)
  • res_pet — NUMBER(1)
  • res_message — VARCHAR2(3000)
  • res_price — NUMBER(20) — NOT NULL
  • res_state — NUMBER(1)

PP_review

  • rev_num — NUMBER(20) — 기본 키 — NOT NULL
  • suk_num — NUMBER(20) — 외래 키 → PP_sukso.suk_num — NOT NULL
  • mem_id — VARCHAR2(20) — 외래 키 → 멤버 기본 정보.mem_id — NOT NULL
  • rev_star_clean — NUMBER(1)
  • rev_star_access — NUMBER(1)
  • rev_star_faci — NUMBER(1)
  • rev_star_service — NUMBER(1)
  • rev_star_AVG — NUMBER(1)
  • rev_title — VARCHAR2(30)
  • rev_contents — VARCHAR2(3000)
  • rev_files_orz — VARCHAR2(300)
  • rev_files_saved — VARCHAR2(100)
  • rev_date — DATE

PP_suk_files

  • suk_num — NUMBER(20) — 외래 키 → PP_sukso.suk_num — NOT NULL
  • suk_files_num — NUMBER(20)
  • suk_files_orz — VARCHAR2(300)
  • suk_files_saved — VARCHAR2(100)

PP_suk_spec

  • suk_num — NUMBER(20) — 외래 키 → PP_sukso.suk_num — NOT NULL
  • suk_visitcount — NUMBER(5)
  • suk_bed — NUMBER(5)
  • suk_restroom — NUMBER(5)
  • suk_parking — NUMBER(1)
  • suk_kitchin — NUMBER(1)
  • suk_bbq — NUMBER(1)
  • suk_maxmember — NUMBER(5)
  • suk_cctv — NUMBER(1)
  • suk_pet — NUMBER(1)
  • suk_floor — NUMBER(5)
  • suk_elev — NUMBER(1)
  • suk_wifi — NUMBER(1)
  • suk_laundary — NUMBER(1)
  • suk_notice — VARCHAR2(3000)

PP_sukso

  • suk_num — NUMBER(20) — 기본 키 — NOT NULL
  • mem_id — VARCHAR2(20) — 외래 키 → 멤버 기본 정보.mem_id — NOT NULL
  • suk_name — VARCHAR2(30) — NOT NULL
  • suk_address — VARCHAR2(300) — NOT NULL
  • suk_location — VARCHAR2(30)
  • suk_nearby — VARCHAR2(20)
  • suk_visit — NUMBER(20)
  • suk_price1 — NUMBER(20) — NOT NULL
  • suk_files_orz — VARCHAR2(300)
  • suk_files_saved — VARCHAR2(100)

intag

  • suk_num — NUMBER(20) — 외래 키 → PP_sukso.suk_num — NOT NULL
  • id — NUMBER(10) — 외래 키 → tags.id — NOT NULL
  • input_person — NUMBER(10)

tags

  • id — NUMBER(10) — 기본 키 — NOT NULL
  • name — VARCHAR2(50) — NOT NULL

멤버 기본 정보 (PP_member)

  • mem_id — VARCHAR2(20) — 기본 키 — NOT NULL
  • mem_password — VARCHAR2(200) — NOT NULL
  • mem_nickname — VARCHAR2(24) — NOT NULL
  • mem_email — VARCHAR2(100) — NOT NULL
  • mem_phone — VARCHAR2(20) — NOT NULL
  • mem_gender — VARCHAR2(12)
  • mem_address — VARCHAR2(300) — NOT NULL
  • mem_role — VARCHAR2(20)
  • mem_joindate — DATE
  • mem_state — NUMBER(1)

투숙객 (PP_member_user)

  • mem_id — VARCHAR2(20) — 외래 키 → 멤버 기본 정보.mem_id — NOT NULL
  • user_reported — NUMBER(5)
  • user_totalspend — NUMBER(30) — NOT NULL
  • user_tripcount — NUMBER(20) — NOT NULL
  • user_milelage — NUMBER(20)
  • user_grade — NUMBER(1)

호스트 (PP_member_host)

  • mem_id — VARCHAR2(20) — 외래 키 → 멤버 기본 정보.mem_id — NOT NULL
  • host_count — NUMBER(20) — NOT NULL
  • host_reported — NUMBER(5)
  • host_grade — NUMBER