KoreAqua

Tables (18)

AdminDTO (admin)

  • AdminDTO (Key) — Primary key — NOT NULL
  • Userid (아이디) — VARCHAR2(10)
  • Passwd (비밀번호) — VARCHAR2(10)

AreaDTO (Travel_Area)

  • AreaDTO (Key) — Primary key — NOT NULL
  • RESULTCODE (결과코드) — VARCHAR2(5)
  • RESULTMSG (출결결과메세지) — VARCHAR2(20)
  • INTRO (미리보기) — VARCHAR2(3000)
  • REGION (지역) — VARCHAR2(10)
  • SEARCHTYPE (검색) — VARCHAR2(10)
  • SEARCHTYPECD (검색코드) — VARCHAR2(10)
  • TITLE (제목) — VARCHAR2(3000)
  • REGIONCD (지역코드) — VARCHAR2(10)
  • NUMOFROWS (페이지당내용갯수) — VARCHAR2(5)
  • PAGENO (페이지번호) — VARCHAR2(5)
  • TOTALCOUNT (총 갯수) — VARCHAR2(5)
  • RIMAGE (이미지) — VARCHAR2(5)

AreaPageDTO (Untitled)

  • AreaPageDTO (Key) — Primary key — NOT NULL
  • List (리스트) — List
  • CurPage (현재페이지 번호) — int
  • PerPage (한 페이지 당 게시물 수) — int
  • TotalCount (전체 게시물 수) — VARCHAR2(5)
  • AreaDTO (Key2) — Foreign key → AreaDTO.AreaDTO — NOT NULL

BeachDTO (Untitled2)

  • BeachDTO (Key) — Primary key — NOT NULL
  • sidoNm (시,도명) — OpenApi
  • gugunNm (구,군명) — OpenApi
  • staNm (정점명) — OpenApi
  • resNum (조사 차수) — OpenApi
  • resLoc (조사지점) — OpenApi
  • res1 (대장균) — OpenApi
  • res2 (장구균) — OpenApi
  • resYn (적합여부) — OpenApi
  • resYear (조사년도) — OpenApi
  • resDate (조사일자) — OpenApi
  • resKnd (조사종류) — OpenApi
  • resLocDetail (조사지점 설명) — OpenApi
  • lat (위도) — OpenApi
  • lon (경도) — OpenApi

CourseDTO (CopyOfTravel_AreaDTO)

  • CourseDTO (Key) — Primary key — NOT NULL
  • RESULTCODE (결과코드) — VARCHAR2(5)
  • RESULTMSG (출결결과메세지) — VARCHAR2(20)
  • COURSE (코스) — VARCHAR2(3000)
  • INTRO (미리보기) — VARCHAR2(3000)
  • REGION (지역) — VARCHAR2(10)
  • SEARCHTYPE (검색) — VARCHAR2(10)
  • SEARCHTYPECD (검색코드) — VARCHAR2(10)
  • TITLE (제목) — VARCHAR2(3000)
  • NUMOFROWS (페이지당내용갯수) — VARCHAR2(5)
  • PAGENO (페이지번호) — VARCHAR2(5)
  • TOTALCOUNT (총 갯수) — VARCHAR2(5)
  • RIMAGE (이미지) — VARCHAR2(5)

CoursePageDTO (CopyOfUntitled)

  • CoursePageDTO (Key) — Primary key — NOT NULL
  • List (리스트) — List
  • CurPage (현재페이지 번호) — int
  • PerPage (한 페이지 당 게시물 수) — int
  • TotalCount (전체 게시물 수) — VARCHAR2(5)
  • CourseDTO (Key2) — Foreign key → CourseDTO.CourseDTO — NOT NULL

DayDTO (Untitled3)

  • DayDTO (Key) — Primary key — NOT NULL
  • date (날짜) — OpenApi
  • taste (맛) — OpenApi
  • smell (냄새) — OpenApi
  • chromaticity (색도) — OpenApi
  • pH (pH농도) — OpenApi
  • turbidity (탁도) — OpenApi
  • residualCI (잔류염소) — OpenApi

DictionDTO (Diction)

  • DictionDTO (Key) — Primary key — NOT NULL
  • resultCode (지역코드) — VARCHAR2(5)
  • resultMsg (출력결과메세지) — VARCHAR2(20)
  • cNm (한자명) — VARCHAR2(100)
  • eNm (영문명) — VARCHAR2(1000)
  • explain (설명) — VARCHAR2(3000)
  • hNm (한글명) — VARCHAR2(100)
  • rgsdt (등록일자) — VARCHAR2(100)
  • numOfRows (페이지당내용갯수) — VARCHAR2(10)
  • pageNo (페이지번호) — VARCHAR2(5)
  • totalCount (총갯수) — VARCHAR2(5)

DictionPageDTO (Untitled9)

  • DictionPageDTO (Key) — Primary key — NOT NULL
  • DictionDTO (Key2) — Foreign key → DictionDTO.DictionDTO — NOT NULL
  • list (리스트) — List
  • CurPage (현재페이지 번호) — int
  • PerPage (한 페이지 당 게시물 수) — int
  • TotalCount (전체 게시물 수) — VARCHAR2(5)

MSWInfoDTO (Untitled8)

  • WMSWInfoDTO (Key) — Primary key — NOT NULL
  • MineralSpringWaterDTO (Key2) — Foreign key → MineralSpringWaterDTO.MineralSpringWaterDTO — NOT NULL
  • mnrlspNm (약수터명) — VARCHAR2(100)
  • doNm (도) — VARCHAR2(100)
  • siGuNm (시군) — VARCHAR2(100)
  • latitude (위도) — VARCHAR2(100)
  • longitude (경도) — VARCHAR2(100)

MainPage (Untitled15)

  • admin_district (Key3) — Foreign key → admin_district.admin_district — NOT NULL
  • AdminDTO (Key5) — Foreign key → AdminDTO.AdminDTO — NOT NULL
  • Key (Key6) — Foreign key → SubcribeDTO.Key — NOT NULL
  • BeachDTO (Key7) — Foreign key → BeachDTO.BeachDTO — NOT NULL
  • WMSWInfoDTO (Key8) — Foreign key → MSWInfoDTO.WMSWInfoDTO — NOT NULL
  • PageQnaDTO (Key4) — Foreign key → PageQnaDTO.PageQnaDTO — NOT NULL
  • AreaPageDTO (Key) — Foreign key → AreaPageDTO.AreaPageDTO — NOT NULL
  • DictionPageDTO (Key2) — Foreign key → DictionPageDTO.DictionPageDTO — NOT NULL
  • CoursePageDTO (Key9) — Foreign key → CoursePageDTO.CoursePageDTO — NOT NULL

MineralSpringWaterDTO (Untitled6)

  • MineralSpringWaterDTO (Key) — Primary key — NOT NULL
  • mnrlspNm (약수터명) — OpenApi
  • rdnmadr (소재지도로명주소) — OpenApi
  • lnmadr (소재지지번주소) — OpenApi
  • latitude (위도) — OpenApi
  • longitude (경도) — OpenApi
  • appnDate (지정일자) — OpenApi
  • dayUseCn (일평균이용인구수) — OpenApi
  • qltwtrInspctDate (수질검사일자) — OpenApi
  • qltwtrInspctResultType (수질검사결과구분) — OpenApi
  • improptIem (부적합항목) — OpenApi
  • phoneNumber (관리기관전화번호) — OpenApi
  • institutionNm (관리기관명) — OpenApi
  • referenceDate (데이터기준일자) — OpenApi
  • insttCode (제공기관코드) — OpenApi
  • institutionNm (제공기관기관명) — OpenApi

MonthDTO (Untitled7)

  • MonthDTO (Key) — Primary key — NOT NULL
  • site (정수장명) — OpenApi
  • date (채수일자) — OpenApi
  • bacteria (일반세균) — OpenApi
  • totalColi (총대장균군) — OpenApi
  • coli (대장균/불원성대장균군) — OpenApi
  • ammonia (암모니아성질소) — OpenApi
  • nnitrogen (질산성질소) — OpenApi
  • evaresi (증발잔류물) — OpenApi
  • taste (맛) — OpenApi
  • smell (냄새) — OpenApi
  • chromaticity (색도) — OpenApi
  • pH (pH농도) — OpenApi
  • turbidity (탁도) — OpenApi
  • residualCI (잔류염소) — OpenApi

PageQnaDTO (Untitled10)

  • PageQnaDTO (Key) — Primary key — NOT NULL
  • QnaDTO (Key2) — Foreign key → QnaDTO.QnaDTO — NOT NULL
  • List (리스트) — List
  • curPage (현재 페이지) — int
  • PerPage (한 페이지 당 게시물 수) — int
  • TotalCount (전체 게시물 수) — int

QnaDTO (Untitled11)

  • QnaDTO (Key) — Primary key — NOT NULL
  • num (번호) — NUMBER(4, 0)
  • title (제목) — VARCHAR2(200)
  • author (작성자) — VARCHAR2(20)
  • email (이메일) — VARCHAR2(50)
  • passwd (비밀번호) — VARCHAR2(20)
  • content (내용) — VARCHAR2(4000)
  • fileName (파일명) — VARCHAR2(50)
  • writeday (작성일자) — DATE
  • readCnt (조회수) — NUMBER(4, 0)
  • repRoot (Field10) — NUMBER(4, 0)
  • repStep (Field11) — NUMBER(4, 0)
  • repIndent (Field12) — NUMBER(4, 0)

SubcribeDTO (Untitled13)

  • Key — Primary key — NOT NULL
  • usermail — VARCHAR2(50)

WeekDTO (Untitled14)

  • WeekDTO (Key) — Primary key — NOT NULL
  • cltdt (측정일자) — OpenApi
  • bacteria (일반세균) — OpenApi
  • totalColi (총대장균군) — OpenApi
  • coli (대장균/불원성대장균군) — OpenApi
  • ammonia (암모니아성질소) — OpenApi
  • nnitrogen (질산성질소) — OpenApi
  • evaresi (증발잔류물) — OpenApi

admin_district (Untitled5)

  • admin_district (Key) — Primary key — NOT NULL
  • DayDTO (Key4) — Foreign key → DayDTO.DayDTO — NOT NULL
  • WeekDTO (Key3) — Foreign key → WeekDTO.WeekDTO — NOT NULL
  • MonthDTO (Key2) — Foreign key → MonthDTO.MonthDTO — NOT NULL
  • sido (시도) — OpenApi
  • sigun (시군) — OpenApi
  • dong (동) — OpenApi
  • sgccd (지자체코드) — OpenApi
  • sitecd (지역코드) — OpenApi