시스매니저
테이블 (7)
tbl_city (Untitled)
- city_id — int — 기본 키 — NOT NULL
- country_code (country_id) — varchar
- city_name — varchar
- longitude — real
- latitude — real
tbl_city_blocks (Untitled2)
- ip_start_number — int — 기본 키 — NOT NULL
- ip_end_number — int — 기본 키 — NOT NULL
- city_id (city_id2) — int — 외래 키 → tbl_city.city_id — NOT NULL
tbl_continent (Untitled4)
- continent_id — int — 기본 키 — NOT NULL
- lang — varchar
- continent_code — vaschar
- longitude — real
- latitude — real
- description — varchar
- reg_date — date
- modify_date — date
tbl_continent_country (Untitled7)
- continent_id — int — 기본 키 — NOT NULL
- country_id — int — 기본 키 — NOT NULL
tbl_country (Untitled3)
- country_id — int — 기본 키 — NOT NULL
- lang — varchar
- country_code — varchar
- country_name — varchar
- longitude — real
- latitude — real
- description — varchar
- reg_date — date
- modify_date — date
- continent_name — varchar
- continent_code — varchar
tbl_country_city (Untitled6)
- city_id (Key) — int — 기본 키 — NOT NULL
- country_id (Key2) — int — 기본 키 — NOT NULL
tbl_geoip (Untitled5)
- ip_index — int — 기본 키 — NOT NULL
- ip_start — varchar
- ip_start_number — int
- ip_end_number — int
- country_code — varchar
- country_name — varchar
- mac_address — varchar
- is_private_ip — boolean