test

Tables (5)

Node (노드)

  • 노드ID (Key) — int64 — Primary key — NOT NULL
  • 노드타입 (type) — int
  • 명칭 (name) — String

link (링크)

  • 링크ID (link_id) — int64 — Primary key — NOT NULL
  • 노드ID(시작) (fnode_id) — int64 — Foreign key → Node.노드ID — NOT NULL
  • 노드ID(종료) (tnode_id) — int64 — Foreign key → Node.노드ID — NOT NULL
  • Field

temp_serve_line_volume_4_down

  • ord — INT(11) — Primary key — NOT NULL
  • f_vnode_id — INT(11) — Primary key — NOT NULL
  • t_vnode_id — INT(11) — Primary key — NOT NULL
  • serve_line_vcode — INT(11) — Primary key — NOT NULL
  • min_type — INT(11) — Primary key — NOT NULL
  • f_node_name — VARCHAR(45)
  • tpassenger — DOUBLE

tmobile_zone_sido_shp_2017

  • OGR_FID — INT(11) — NOT NULL
  • SHAPE — GEOMETRY — NOT NULL
  • zone_id — VARCHAR(13)
  • name — VARCHAR(30)
  • lon — DOUBLE(19,11)
  • lat — DOUBLE(19,11)
  • areavalue — DOUBLE(19,6)
  • full_name — VARCHAR(50)
  • SPATIAL — INDEX

zone_shp_sido_2017

  • OGR_FID — INT(11) — NOT NULL
  • SHAPE — GEOMETRY — NOT NULL
  • zone_id — DECIMAL(10,0)
  • lon — DOUBLE(19,11)
  • lat — DOUBLE(19,11)
  • name — VARCHAR(50)
  • full_name — VARCHAR(58)
  • areavalue — DOUBLE(19,6)
  • SPATIAL — INDEX