CIRCUIT
Tables (17)
CIRCUIT_COURSE
- COURSE ID (COURSE_ID) — BIGINT — NOT NULL
- COURSE NAME GR ID (COURSE_NAME_GR_ID) — BIGINT
- COURSE TYPE (COURSE_TYPE) — INT
- COURSE 길이 (COURSE_LENGTH) — BINGINT
CIRCUIT_NAME
- 이름ID (NAME_ID) — BIGINT — Primary key — NOT NULL
- TRANSLATION유무 (TRANSLITERATION_TYPE) — BIGINT
- 언어코드 (LANGUAGE_CODE) — BIGINT
- BASE NAME (NAME) — NVARCHAR(255)
- 이명정보유무 (IS_EXONYM) — BIGINT
CIRCUIT_NAME_GROUP
- NAME GROUP ID (NAME_GROUP_ID) — BIGINT — Primary key — NOT NULL
- 그룹TYPE (NAME_GROUP_TYPE) — BIGINT — 자택/직장
- 이름ID (NAME_ID) — BIGINT
- NAME ORDER (NAME_ORDER) — BIGINT
CIRCUIT_NAME_GROUP (MDB_CIRCUIT_NAME_GROUP)
- 이름ID (NAME_ID) — BIGINT — NOT NULL
- 그룹TYPE (NAME_GROUP_TYPE) — BIGINT — NOT NULL — 자택/직장
- NAME ORDER (NAME_ORDER) — BIGINT — NOT NULL
CIRCUIT_NAME_GROUP(HERE)
- 이름ID (NAME_ID) — INT — Primary key — NOT NULL
- 이름그룹TYPE (NAME_GROUP_ID) — INT — NOT NULL — 자택/직장
- NAME ORDER (NAME_ORDER) — BIGINT — NOT NULL
CIRCUIT_POI
- POI ID (POI_ID) — BIGINT — NOT NULL
- PARENT ID (PARENT_ID) — BIGINT — 관리자, 골드, 실버, 브론즈
- 서킷명칭 (C_NAME_GR_ID) — BIGINT
- 종별 (FEAT_TYPE) — INT
- 서브종별 (FEAT_SUB_TYPE) — INT
- 전화번호 (TEL_NUM) — NVARCHAR(255)
- LINK ID (LINK_ID) — BIGINT
- 표시X좌표 (DISPLAY_X) — INT
- 표시Y좌표 (DISPLAY_Y) — INT
- 안내X좌표 (GUIDE_X) — INT
- 안내Y좌표 (GUIDE_Y) — INT
CONN_INFO
- LINK_MAP ID (LINK_MAP_ID) — BIGINT — NOT NULL
- 진출노드ID (TO_NODE_ID) — NVARCHAR(255)
- 진입링크ID (IN_LINK_ID) — VARCHAR2(255)
- CIRCUIT IN/OUT 정보 (CIRCUIT_INOUT_INFO) — INT
LAB_INFO
- LINK MAP ID (LINK_MAP_ID) — BIGINT — NOT NULL
- LINK ID (LINK_ID) — BIGINT
- LAB TYPE (LAB_TYPE) — INT
- LAB NAME GROUP ID (LAB_NAME_GR_ID) — NVARCHAR2(255)
- LAB_XY — NVARCHAR(255)
- DIRECTION — INT
- COURSE ID (COURSE_ID) — INT
MULTI_CIRCUIT
- LINK ID (LINK_ID2) — INT — NOT NULL
- COURSE ID (COURSE_ID) — INT — NOT NULL — 숫자4자리
- 서킷ID (CIRCUIT_ID) — INT — NOT NULL
- 서킷TYPE (CIRCUIT_LINK_TYPE) — INT
- 이름그룹ID (NAMEGROUP_ID) — INT
- 영역MBR (BOUNDARY_MBR) — NVARCHAR(255)
- 영역MBR WGS84 (BOUNDARY_MBR_WGS84) — NVARCHAR(255)
- 영역 POLYGON NUM 개수 (BOUNDARY_POLYGON_NUM_POINT) — INT
- 영역POLYGON (BOUNDARY_POLYGON) — IMAGE — 정상/휴면
- 영역POLYGON OBJ (BOUNDARY_POLYGON_OBJ) — GEOM
- 영역POLYGON WGS84 (BOUNDARY_POLYGON_OBJ_WGS84) — GEOM
- DIRECTION — INT
MULTI_CIRCUIT_CONNINFO
- 진입링크ID (IN_LINK_ID) — INT — NOT NULL
- 진출노드ID (TO_NODE_ID) — INT — NOT NULL
- 서킷INOUT정보 (CIRCUIT_INOUT_INFO) — INT
MULTI_CIRCUIT_COURSE
- 서킷ID (CIRCUIT_ID) — INT — Primary key — NOT NULL
- 코스ID (COURSE_ID) — INT — NOT NULL
- 코스길이 (COURSE_LENGTH) — INT
- 이름그룹ID (NAMEGROUP_ID) — INT
MULTI_CIRCUIT_LABINTO (MULTI_CIRCUIT_LABINFO)
- LINK ID (LINK_ID) — INT — Primary key — NOT NULL
- LAB타입 (LAB_TYPE) — INT — NOT NULL
- 방향 (DIRECTION) — INT — NOT NULL
- 서킷ID (CIRCUIT_ID) — INT — NOT NULL
- 코스ID (COURSE_ID) — INT — NOT NULL
- 이름그룹ID (NAMEGROUP_ID) — INT — NOT NULL
- LAB좌표 (LAB_XY) — NVARCHAR(255) — NOT NULL
- LAB좌표WGS84 (LAB_XY_WGS84) — NVARCHAR(255) — NOT NULL
MULTI_LINK
- LINK ID (LINK_ID) — INT — Primary key — NOT NULL
- 시작NODE ID (FROM_NODE_ID) — INT
- 시작TILE ID (FROM_TILE_ID) — INT
- 끝NODE ID (END_NODE_ID) — INT
- 끝TILE ID (END_TILE_ID) — INT
- 운전방향 (DRIVING_SIDE) — TINYINT
- LINK 길이 (LINK_LEN) — INT
- 평균속도 (AVG_SPEED) — INT
- START 각도 (FROM_ANGLE) — INT
- END 각도 (TO_ANGLE) — INT
- FUNCTIONAL CLASS (FUNCTION_CLASS) — TINYINT
- ADMIN ROAD CLASS (ADMIN_ROAD_CLASS) — TINYINT
- CONTROLL ACCESS (CONTROLLED_ACCESS) — TINYINT
- NUM INTERSECTS (NUM_INTERSECTS) — TINYINT
- TRAVEL DIRECTION (TRAVEL_DIRECTION) — TINYINT
- THROUGHT TRAFFIC (THROUGHT_TRAFFIC) — TINYINT
- MULTI DIGITIZED (MULTI_DIGITIZED) — TINYINT
- LINK TYPE (LINK_TYPE) — TINYINT
- NUM POINT (NUM_POINT) — INT
- GEOM — IMAGE
- GEOM WGS84 (GEOM_WGS84) — GEOM
- NUM ADAS POINT (NUM_ADAS_POINT) — INT
- ADASGEOM — IMAGE
MULTI_LINK_SA_GRP_GEOM_TEMP
- 서킷ID (CIRCUIT_ID) — INT — Primary key — NOT NULL
- POINT개수 (NUM_POINT) — INT
- 영역OBJ (BOUNDARY_POLYGON_OBJ) — GEOM
- 영역 (BOUNDARY_POLYGON) — GEOM
MULTI_LINK_SA_GRP_TEMP
- 서킷ID (CIRCUIT_ID) — INT — Primary key — NOT NULL
- 영역OBJ (BOUNDARY_POLYGON_OBJ) — GEOM
- 영역 (BOUNDARY_POLYGON) — GEOM
- GEOM길이 (GEOM_LEN) — BIGINT
MULTI_NAME_ADMIN
- 서킷ID (CIRCUIT_ID) — INT — NOT NULL
- 국가 NAME 그룹 ID (COUNTRY_ADMIN_NAMEGROUP_ID) — INT
- 주NAME그룹 ID (STATE_ADMIN_NAMEGROUP_ID) — INT
- CITY NAME 그룹ID (CITY_ADMIN_NAMEGROUP_ID) — INT
RTM_CIRCUIT
- LINK MAP ID (LINK_MAP_ID) — BIGINT — NOT NULL
- LINK ID (LINK_ID) — BIGINT
- COURSE ID (COURSE_ID) — INT
- 링크타입 (C_LINK_TYPE) — BIGINIT
- FLAG (C_FLAG) — INT — 1~9
- NAME GROUP ID (C_NAME_GR_ID) — BIGINIT
- COUNTRY NAME (COUNTRY_NAME_GR_ID) — BIGINIT
- STATE 명칭 ID (STATE_NAME_GR_ID) — BIGINIT
- CITY 명칭 ID (CITY_NAME_GR_ID) — BIGINIT — 웹/카카오
- 영역정보 (BOUNDARY_POLYGON) — NVARCHAR(255)
- 영역MBR (BOUNDARY_MBR) — NVARCHAR(255)
- ETC — NVARCHAR(255)