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