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