mission1

Tables (4)

bookmark

  • BOOKMARK_ID — INTEGER — Primary key — NOT NULL
  • 관리번호 (X_SWIFI_MGR_NO) — TEXT — Foreign key → wifi.관리번호 — NOT NULL
  • GROUP_ID — INTEGER — Foreign key → bookmark_group.GROUP_ID — NOT NULL
  • 북마크 이름 (BOOKMARK_NAME) — TEXT — NOT NULL
  • 와이파이명 (X_SWIFI_MAIN_NM) — TEXT — NOT NULL
  • 등록일자 (CREATE_DATE) — TEXT — NOT NULL

bookmark_group

  • GROUP_ID — INTEGER — Primary key — NOT NULL
  • 북마크 이름 (BOOKMARK_NAME) — TEXT — NOT NULL
  • 순서 (SEQUENCE) — INTEGER — NOT NULL
  • 등록일자 (CREATE_DATE) — TEXT — NOT NULL
  • 수정일자 (MODIFY_DATE) — TEXT

history

  • HISTORY_ID — INTEGER — Primary key — NOT NULL
  • 조회일자 (LOOK_DATE) — TEXT — NOT NULL
  • X좌표 (LOOK_LAT) — REAL — NOT NULL
  • Y좌표 (LOOK_LNT) — REAL — NOT NULL

wifi

  • 관리번호 (X_SWIFI_MGR_NO) — TEXT — Primary key — NOT NULL
  • 자치구 (X_SWIFI_WRDOFC) — TEXT
  • 와이파이명 (X_SWIFI_MAIN_NM) — 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
  • WIFI접속환경 (X_SWIFI_REMARS3) — TEXT
  • X좌표 (LAT) — REAL
  • Y좌표 (LNT) — REAL
  • 작업일자 (WORK_DTTM) — TEXT