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