시스매니저

테이블 (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