예스다이빙

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