캠핑장

테이블 (20)

Copy Of Untitled (Reviews)

  • Key (campsite_id) — INT — 기본 키 — NOT NULL
  • Field (review) — VARCHAR(1000)
  • Key (user_id) — INT — 외래 키 → User.Key — NOT NULL

Untitled (Link)

  • Field (directionV) — VARCHAR(4000)
  • Field (tel) — VARCHAR(300)
  • Field (homepage) — VARCHAR(4000)
  • Field (resveUrl) — VARCHAR(4000)
  • Field (resveCl) — VARCHAR(100)
  • Key (campsite_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL

Untitled (Campsite_SbrsCl)

  • Key (campsite_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (sbrsCl_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (SbrsCl)

  • Key (sbrsCl_id) — INT — 기본 키 — NOT NULL
  • Field (sbrsCl_name) — VARCHAR(100) — NOT NULL

Untitled (Campsite_Tag)

  • Key (campsite_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (tag_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (Tag)

  • Key (tag_id) — INT — 기본 키 — NOT NULL
  • Field (tag_name) — VARCHAR(30) — NOT NULL

Untitled (Image)

  • Field (firstImageUrlV) — VARCHAR(300)
  • Key (campsite_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (Site)

  • Field (sitedStnc) — INT
  • Field (siteMg1Width) — INT
  • Field (siteMg2Width) — INT
  • Field (siteMg3Width) — INT
  • Field2 (siteMg1Vrticl) — INT
  • Field (siteMg2Vrticl) — INT
  • Field (siteMg3Vrticl) — INT
  • Field (siteMg1Co) — INT
  • Field (siteMg2Co) — INT
  • Field (siteMg3Co) — INT
  • Key (campsite_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (BusinessInfo)

  • Field (bizrnoV) — VARCHAR(100)
  • Field (insrncAt) — Boolean — NOT NULL — 운영영업배상책임보험가입여부
  • Key (campsite_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (DetailFeatures)

  • Field (induty) — VARCHAR(200)
  • Field (lctCl) — VARCHAR(50)
  • Field (themaEnvrnCl) — VARCHAR(300)
  • Field (animalCmgCl) — VARCHAR(100)
  • Field (tourEraClV) — VARCHAR(200)
  • Field (tooltip) — VARCHAR(4000)
  • Field (featureNmV) — VARCHAR(4000)
  • Field (lineIntro) — VARCHAR(100)
  • Field (intro) — VARCHAR(4000)
  • Key (campsite_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL

Untitled (Management)

  • Field (mangeDivNm) — VARCHAR(20)
  • Field (manageSttus) — VARCHAR(20)
  • Field (hvofBgnde) — VARCHAR(20)
  • Field (hvofEnddleV) — VARCHAR(20)
  • Field (operDeCl) — VARCHAR(30)
  • Field2 (operPdCl) — VARCHAR(50)
  • Key (campsite_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (NearbyFacility)

  • Field (posblFcltyCl) — VARCHAR(300)
  • Field (posblFcltyEtc) — VARCHAR(300)
  • Field (clturEventAt) — Boolean — NOT NULL
  • Field (clturEvent) — VARCHAR(200)
  • Field (exprnProgrmAt) — Boolean — NOT NULL
  • Field (exprnProgrm) — VARCHAR(300)
  • Key (campsite_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (ConvenienceFacility)

  • Field (sbrsEtc) — VARCHAR(200)
  • Key (campsite_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (Facility)

  • Field (toiletCo) — INT
  • Field (swrmCo) — INT
  • Field (wtrplCo) — INT
  • Field (brazierCl) — VARCHAR(20)
  • Key (campsite_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (CampingType)

  • Field (gnrlSiteCo) — INT
  • Field (autoSiteCo) — INT
  • Field (glampSiteCo) — INT
  • Field (caravSiteCo) — INT
  • Field (indvdlCaravSiteCo) — INT
  • Field (glampInnerFclty) — VARCHAR(100)
  • Field (caravInnerFclty) — VARCHAR(100)
  • Field (trlerAcmpnyAt) — Boolean — NOT NULL
  • Field (caravAcmpnyAt) — Boolean — NOT NULL
  • Field (eqpmnLendCl) — VARCHAR(100)
  • Key (campsite_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (UnderInfo)

  • Field (allar) — VARCHAR(20)
  • Field (siteBottomCl1) — INT
  • Field (siteBottomCl2) — INT
  • Field (siteBottomCl3) — INT
  • Field (siteBottomCl4) — INT
  • Field (siteBottomCl5) — INT
  • Key (campsite_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (Address)

  • Field (doNm) — VARCHAR(20)
  • Field (sigunguNm) — VARCHAR(20)
  • Field (zipcode) — VARCHAR(20)
  • Field2 (addr1) — VARCHAR(50)
  • Field (addr2) — VARCHAR(30)
  • Field (mapX) — VARCHAR(20)
  • Field2 (mapY) — VARCHAR(20)
  • Key (campsite_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (Campsite)

  • Key (campsite_id) — INT — 기본 키 — NOT NULL
  • Field (campsite_name) — VARCHAR(30) — NOT NULL

User (user)

  • Key (user_id) — INT — 기본 키 — NOT NULL
  • Field (email) — VARCHAR(50) — NOT NULL
  • Field (password) — VARCHAR(30) — NOT NULL
  • Field (nickname) — VARCHAR(30) — NOT NULL
  • Field (address) — VARCHAR(100) — NOT NULL
  • Field (admin) — Boolean — NOT NULL
  • Field (birth) — DATETIME — NOT NULL

likes (Likes)

  • Key (campsite_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — INT — 외래 키 → User.Key — NOT NULL