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)