예스다이빙
테이블 (5)
국가, 도시코드 (CodeArea)
- Code — int — 기본 키 — PK
- Field (CodeName) — varchar(50)
- Field (LCode) — int
- Field (LCodeName) — int
- Field (Flag) — int
다이빙샵 코스 (ActivityCode)
- Field (ActCode) — int — 기본 키
- Field (CodeName) — varchar(50)
- Field (SubCodeName) — varchar(50)
- Field (Flag) — int
다이빙샵목록 (DSList)
- Key (DS_id) — 기본 키 — NOT NULL
- Field (MD_id) — int — 외래 키 → 메인노출DS.Field
- Code (CodeArea) — int — 외래 키 → 국가, 도시코드.Code — PK
- Field (DS_id2) — int — 외래 키 → 메인노출DS.Field
- Field (mb_id) — varchar(50)
- Field (DSName) — varchar(50)
- Field (DPName_En) — varchar(50)
- Field (DPContents) — text
- Field (DPContents_En) — text
- Field (DPLocation) — varchar(150)
- Field (DPInfo01) — varchar(150)
- Field (DPInfo02) — varchar(150)
- Field (DPInfo03) — varchar(150)
- Field (DPInfo01_En) — varchar(150)
- Field (DPInfo02_En) — varchar(150)
- Field (DPInfo03_En) — varchar(150)
- Field (DPTag) — varchar(150)
- Field (DPTag_En) — varhcar(150)
- Field (Regist_Day) — datetime
- Field (Flag) — int
다이빙포인트목록 (DPList)
- Key (DP_id) — 기본 키 — NOT NULL
- Code (CodeArea) — int — 외래 키 → 국가, 도시코드.Code — PK
- Field (mb_id) — varchar(50)
- Field (DPName) — varchar(50)
- Field (DPName_En) — varchar(50)
- Field (DPContents) — text
- Field (DPContents_En) — text
- Field (DPLocation) — varchar(150)
- Field (DPInfo01) — varchar(150)
- Field (DPInfo02) — varchar(150)
- Field (DPInfo03) — varchar(150)
- Field (DPInfo01_En) — varchar(150)
- Field (DPInfo02_En) — varchar(150)
- Field (DPInfo03_En) — varchar(150)
- Field (DPTag) — varchar(150)
- Field (DPTag_En) — varhcar(150)
- Field (Regist_Day) — datetime
- Field (Flag) — int
메인노출DS (MainDs)
- Field (MD_id) — int — 기본 키
- Field (DS_id) — int — 기본 키
- Field (Sort) — int
- Field (Regist_Day) — datetime
- Field (Flag) — int