런닝맨
테이블 (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