tourtour

Tables (18)

pic_comment

  • cmt_uid — NUMBER — Primary key — NOT NULL
  • pc_uid — NUMBER — Foreign key → picture.pc_uid — NOT NULL
  • us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
  • cmt_contents — VARCHAR2(100)
  • cmt_date — DATE — NOT NULL

pic_lib

  • pl_uid — NUMBER — Primary key — NOT NULL
  • pc_uid — NUMBER — Foreign key → picture.pc_uid — NOT NULL
  • pl_name — VARCHAR2(20)
  • pl_type — VARCHAR2(10) — NOT NULL
  • pl_size — NUMBER
  • pl_path — VARCHAR2(20) — NOT NULL

pic_like

  • us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
  • pc_uid — NUMBER — Foreign key → picture.pc_uid — NOT NULL
  • pic_like_ck — NUMBER

pic_tag

  • pic_uid — NUMBER — Foreign key → picture.pc_uid — NOT NULL
  • tag_uid — NUMBER — Foreign key → tag.tag_uid — NOT NULL

picture

  • pc_uid — NUMBER — Primary key — NOT NULL
  • us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
  • pc_contents — VARCHAR2(400)
  • pc_hits — NUMBER
  • pc_location — NUMBER
  • pc_focus — NUMBER
  • pc_with — NUMBER
  • pc_write_date — DATE — NOT NULL
  • pc_del_ck — NUMBER

place

  • place_uid — NUMBER — Primary key — NOT NULL
  • contentid — NUMBER — NOT NULL
  • contenttypeid — NUMBER — NOT NULL
  • title — VARCHAR2(40) — NOT NULL
  • mapx — FLOAT — NOT NULL
  • mapy — FLOAT — NOT NULL
  • areaCode — NUMBER
  • sigunguCode — NUMBER
  • addr1 — VARCHAR2(200)
  • tel — VARCHAR2(20)
  • firstimage2 — VARCHAR2(100)
  • pl_viewcnt — NUMBER

place_like

  • us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
  • place_uid — NUMBER — Foreign key → place.place_uid — NOT NULL
  • lc_like_ck — NUMBER

review

  • us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
  • place_uid — NUMBER — Foreign key → place.place_uid — NOT NULL
  • rv_content — CLOB
  • rv_rate — NUMBER
  • rv_write_date — DATE — NOT NULL

tag

  • tag_uid — number — Primary key — NOT NULL
  • tag_name — VARCHAR2(20)

tour

  • tu_uid — NUMBER — Primary key — NOT NULL
  • us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
  • tu_title — VARCHAR2(100) — NOT NULL
  • tu_hits — NUMBER
  • tu_period — NUMBER
  • tu_location — NUMBER
  • tu_with — NUMBER
  • tu_focus — NUMBER
  • tu_del_ck — NUMBER
  • tu_write_date — DATE — NOT NULL
  • tu_start_tour — DATE — NOT NULL

tour_day

  • day_uid — NUMBER — Primary key — NOT NULL
  • tu_uid — NUMBER — Foreign key → tour.tu_uid — NOT NULL
  • tu_day — number — NOT NULL

tour_like

  • tu_uid — NUMBER — Foreign key → tour.tu_uid — NOT NULL
  • us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
  • tu_like_ck — NUMBER

tour_location

  • lc_uid — NUMBER — Primary key — NOT NULL
  • place_uid — NUMBER — Foreign key → place.place_uid — NOT NULL
  • day_uid — NUMBER — Foreign key → tour_day.day_uid — NOT NULL
  • tu_uid — NUMBER — Foreign key → tour_day.tu_uid — NOT NULL

tour_memo

  • memo_uid — NUMBER — Primary key — NOT NULL
  • day_uid — NUMBER — Foreign key → tour_day.day_uid — NOT NULL
  • tu_uid — NUMBER — Foreign key → tour_day.tu_uid — NOT NULL
  • memo_contents — VARCHAR2(400)

tour_tag

  • tu_uid — NUMBER — Foreign key → tour.tu_uid — NOT NULL
  • tag_uid — NUMBER — Foreign key → tag.tag_uid — NOT NULL

user_authority

  • us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
  • us_authority — NUMBER — NOT NULL

user_log

  • log_uid — NUMBER — Primary key — NOT NULL
  • log_contents — VARCHAR2(40)
  • log_date — DATE — NOT NULL

users

  • us_uid — NUMBER — Primary key — NOT NULL
  • us_id — VARCHAR2(20) — NOT NULL
  • us_pw — VARCHAR2(20) — NOT NULL
  • us_email — VARCHAR2(40) — NOT NULL
  • us_nickName — VARCHAR2(20)
  • us_gender — NUMBER
  • us_birth — DATE
  • us_memo — VARCHAR2(100)
  • us_join_date — DATE
  • us_pic — VARCHAR2(20)
  • us_exit_ck — NUMBER
  • us_exit_date — DATE