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