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