런닝맨

테이블 (6)

rn_arealist (관광지리스트)

  • P.K (idx) — int — 기본 키 — NOT NULL
  • (al_name) — varchar(255) — NOT NULL
  • (al_addr) — varchar(255)
  • (al_lat) — float
  • (al_lon) — float
  • (al_active) — int — NOT NULL

rn_gamelist (게임리스트)

  • P.K (idx) — int — 기본 키 — NOT NULL
  • (ga_name) — varchar(255) — NOT NULL
  • (ga_active) — int — NOT NULL

rn_member (회원정보)

  • Key (idx) — int — 기본 키 — NOT NULL
  • (mb_id) — varchar(255) — NOT NULL
  • Field (mb_password) — varchar(255) — NOT NULL
  • Field (mb_name) — varchar(50) — NOT NULL
  • Field (mb_addr1) — varchar(255) — NOT NULL
  • Field (mb_addr2) — varchar(255) — NOT NULL
  • Field (mb_phone) — varchar(20) — NOT NULL
  • Field (mb_wdate) — timestemp — NOT NULL
  • Field (mb_fcm) — varchar(255) — NOT NULL
  • Field (mb_state) — int(1) — NOT NULL
  • Field (mb_type) — int(11) — NOT NULL

rn_missionlist (미션리스트)

  • P.K (idx) — int — 기본 키 — NOT NULL
  • Key (mi_useridx) — int — 외래 키 → rn_member.Key — NOT NULL
  • Key (mi_areaidx) — int — 외래 키 → rn_arealist.P.K — NOT NULL
  • Key (mi_touridx) — int — 외래 키 → rn_tourlist.P.K — NOT NULL
  • Key (mi_gameidx) — int — 외래 키 → rn_gamelist.P.K — NOT NULL
  • Key (mi_obidx) — int — 외래 키 → rn_oblist.P.K — NOT NULL
  • (mi_result) — int(1) — NOT NULL

rn_oblist (AR리스트)

  • P.K (idx) — int — 기본 키 — NOT NULL
  • Field (ob_name) — varchar(255) — NOT NULL
  • Field (ob_active) — int — NOT NULL

rn_tourlist (투어리스트)

  • P.K (idx) — int — 기본 키 — NOT NULL
  • (to_name) — varchar(255) — NOT NULL
  • (to_addr) — varchar(255)
  • (to_lat) — float
  • (to_lon) — float
  • (to_active) — int — NOT NULL