public-wifi-infomation
Tables (4)
bookMark (북마크)
- id — INTEGER — Primary key — NOT NULL
- groupId (그룹 식별자) — INTEGER — Foreign key → bookMarkGroup.id — NOT NULL
- wifiId (wifi 식별자) — TEXT — Foreign key → wifi.X_SWIFI_MGR_NO
- createDate (생성일자) — TIMESTAMP — NOT NULL
bookMarkGroup (북마크 그룹)
- id — INTEGER — Primary key — NOT NULL
- seq (순서) — INTEGER — NOT NULL
- name (이름) — TEXT — NOT NULL
- createDate (생성일자) — Timestamp
- updateDate (수정일자) — Timestamp
history (검색 기록)
- id — INTEGER — Primary key
- LAT (Y좌표) — NUMERIC
- LNT (X좌표) — NUMERIC
- searchDate (검색일자) — TIMESTAMP
wifi (와이파이 정보)
- X_SWIFI_MGR_NO (관리번호) — TEXT — Primary key
- X_SWIFI_WRDOFC (자치구) — TEXT
- X_SWIFI_MAIN_NM (wifi 명) — TEXT
- X_SWIFI_ADRES1 (도로명 주소) — TEXT
- X_SWIFI_ADRES2 (상세주소) — TEXT
- X_SWIFI_INSTL_FLOOR (설치 위치 (층)) — TEXT
- X_SWIFI_INSTL_TY (설치 유형) — TEXT
- X_SWIFI_INSTL_MBY (설치 기관) — TEXT
- X_SWIFI_SVC_SE (서비스 구분) — TEXT
- X_SWIFI_CMCWR (망종류) — TEXT
- X_SWIFI_CNSTC_YEAR (설치년도) — INTEGER
- X_SWIFI_INOUT_DOOR (실내외 구분) — TEXT
- X_SWIFI_REMARS3 (wifi 접속환경) — INTEGER
- LAT (Y좌표) — NUMERIC
- LNT (X좌표) — NUMERIC
- WORK_DTTM (작업일자) — TIMESTAMP