poi_system

Tables (7)

index_working_template_n

  • id — int8 — Foreign key → map_area_index.id — NOT NULL
  • isGetData — int4

map_area_index

  • id — int8 — Primary key — NOT NULL
  • geom — geometry
  • idx_id — int8
  • map_id_cd_no — int8
  • map_id_nm — varchar

poi_category_code

  • id — int8 — Primary key — NOT NULL
  • dwid — int8
  • dwnm — varchar
  • block_group_name — varchar

poi_insert_result

  • seq — bigserial — Primary key — NOT NULL
  • place_url — varchar
  • place_name — varchar
  • category_group_name — varchar
  • road_address_name — varcahr
  • category_name — varchar
  • distance — varchar
  • phone — varchar
  • category_name (category_group_code) — varchar
  • x — float8
  • y — float8
  • address_name — varchar
  • id — varchar
  • shape — geometry
  • insert_date — Timestamp

poi_system (system_setting)

  • seq — int8 — Primary key — NOT NULL
  • work_status — int4
  • running_status — int4
  • idx_template_key — int4
  • code_template_key — int4
  • start_date — Timestamp
  • stop_date — Timestamp

poi_working_list_detail

  • poi_code_id — int8 — Foreign key → poi_working_template_n.id — NOT NULL
  • map_index_id — int8 — Foreign key → index_working_template_n.id — NOT NULL
  • default_template_1 — int4
  • special_template_1 — int4
  • default_template_n — int4
  • special_template_n — int4

poi_working_template_n

  • id — int8 — Foreign key → poi_category_code.id — NOT NULL
  • isGetData — int4