ServletJSP

Tables (4)

. (wifi_info)

  • id — Integer — Primary key
  • X_SWIFI_MGR_NO (Field) — Text — Primary key
  • X_SWIFI_WRDOFC (Field2) — Text
  • X_SWIFI_MAIN_NM (Field3) — Text
  • X_SWIFI_ADRES1 (Field4) — Text
  • X_SWIFI_ADRES2 (Field5) — Text
  • X_SWIFI_INSTL_FLOOR (Field6) — Text
  • X_SWIFI_INSTL_TY (Field7) — Text
  • X_SWIFI_INSTL_MBY (Field8) — Text
  • X_SWIFI_SVC_SE (Field9) — Text
  • X_SWIFI_CMCWR (Field10) — Text
  • X_SWIFI_CNSTC_YEAR (Field11) — Text
  • X_SWIFI_INOUT_DOOR (Field12) — Text
  • X_SWIFI_REMARS3 (Field13) — Text
  • LAT (Field14) — Text
  • LNT (Field15) — Text
  • WORK_DTTM (Field16)

. (search_history)

  • id (Key) — Integer — Primary key — NOT NULL
  • LAT (Field) — Text
  • LNT (Field2) — Text
  • search_dttm (Field3) — Text

. (bookmark_list)

  • id (Key) — Integer — Primary key — NOT NULL
  • mgr_no (id) — Integer — Foreign key → ..id — NOT NULL
  • group_id (Key2) — Integer — Foreign key → ..id — NOT NULL
  • registered_dttm (Field3) — Text

. (bookmark_group)

  • id (Key) — Integer — Primary key — NOT NULL
  • bookmark_name (Field) — Text
  • order_no (Field2) — Integer
  • registered_dttm (Field3) — Text
  • updated_dttm (Field4) — Text