회사

테이블 (60)

EVENT_TIME

  • SEQ — NUMBER — 기본 키 — NOT NULL
  • NAME — VARCHAR(200)
  • TIME — VARCHAR(30)
  • TYPE — CHAR(1)

TVO_AIRKOREA_STATUS_INFO

  • SVC_CODE — VARCHAR(2) — 기본 키 — NOT NULL
  • AREA_CODE — VARCHAR(5) — 기본 키 — NOT NULL
  • AREA_NAME — VARCHAR(30)
  • WT_ID — VARCHAR(8) — NOT NULL
  • WT_NAME — VARCHAR(100)
  • AIR_TIME — VARCHAR(16)
  • SO2_VALUE — VARCHAR(10)
  • CO_VALUE — VARCHAR(10)
  • O3_VALUE — VARCHAR(10)
  • NO2_VALUE — VARCHAR(10)
  • PM10_VALUE — VARCHAR(10)
  • PM10_GRADE — CHAR(1)
  • PM25_VALUE — VARCHAR(10)
  • PM25_GRADE — CHAR(1)
  • WEATHER_TIME — VARCHAR(12)
  • RNST — VARCHAR(5)
  • RNYN — VARCHAR(5)
  • EXPECT_TEMPE — VARCHAR(4)
  • WEATHER — VARCHAR(20)
  • WEATHER_CODE — VARCHAR(5)
  • UPSERT_DATE — VARCHAR(14)

TVO_API_OFFER_PACKET_LOG

  • SERV_SEQ — NUMBER
  • USER_EMAIL — VARCHAR(50)
  • OFFER_DATE — DATE
  • OFFER_PACKET_VOLMUE — NUMBER
  • API_SEQ — NUMBER
  • COL_DATE — VARCHAR(14)

TVO_API_OFFER_STATUS

  • API_URI — VARCHAR(50) — 기본 키 — NOT NULL
  • SERV_SEQ — NUMBER — 기본 키 — NOT NULL
  • USER_EMAIL — VARCHAR(50) — 기본 키 — NOT NULL
  • LAST_OFFER_DATE — DATE
  • LIMIT_HITS_CNT — NUMBER
  • LIMIT_STANDARDS — CHAR(1)
  • HITS_CNT — NUMBER
  • API_URI_COMMENT — VARCHAR(60) — ARCHAR(60
  • API_SEQ — NUMBER
  • COL_DATE — VARCHAR(14)

TVO_AREA_EQ_STATUS_INFO

  • AREA_CODE — CHAR(5) — 기본 키 — NOT NULL
  • SERV_SEQ — NUMBER — 기본 키 — NOT NULL
  • WIRE_CNT — NUMBER
  • WIRELESS_CNT — NUMBER
  • OBSTACLE_CNT — NUMBER
  • REC_BPM_TOTAL — NUMBER
  • REC_PPM_TOTAL — NUMBER
  • LOSSVAL_TOTAL — NUMBER
  • DISCONN_CNT — NUMBER
  • BRANCH_CNT — NUMBER
  • TRN_BPM_TOTAL — NUMBER
  • TRN_PPM_TOTAL — NUMBER
  • OBSTACLE_TYPE_WARNING — NUMBER
  • OBSTACLE_TYPE_CAUTION — NUMBER
  • OBSTACLE_TYPE_CHECK — NUMBER

TVO_AREA_EQ_STATUS_LOG

  • AREA_CODE — CHAR(5) — 기본 키 — NOT NULL
  • COLLECTION_DATE — CHAR(8) — 기본 키 — NOT NULL
  • SERV_SEQ — NUMBER — 기본 키 — NOT NULL
  • COLLECTION_TIME — CHAR(6) — 기본 키 — NOT NULL
  • REC_PPM_TOTAL — NUMBER
  • REC_BPM_TOTAL — NUMBER
  • LOSSVAL_TOTAL — NUMBER
  • OBSTACLE_CNT — NUMBER
  • TRN_PPM_TOTAL — NUMBER
  • TRN_BPM_TOTAL — NUMBER
  • WIRE_CNT — NUMBER
  • WIRELESS_CNT — NUMBER
  • BRANCH_CNT — NUMBER

TVO_AREA_INFO

  • AREA_CODE — CHAR(5) — 기본 키 — NOT NULL
  • UPPER_CODE — CHAR(5) — 기본 키 — NOT NULL
  • SERV_SEQ — NUMBER — 기본 키 — NOT NULL
  • AREA_NM — VARCHAR(40) — NOT NULL
  • ORDER_ORDER — NUMBER
  • MAP_X — VARCHAR(11)
  • MAP_Y — VARCHAR(11)

TVO_AREA_INFO_DEFAULT

  • AREA_CODE — CHAR(5) — NOT NULL
  • AREA_NM — VARCHAR(40) — NOT NULL
  • UPPER_CODE — CHAR(5) — NOT NULL
  • ORDER_ORDER — NUMBER
  • MAP_X — VARCHAR(11)
  • MAP_Y — VARCHAR(11)

TVO_BRANCH_DATA_SMS

  • BRANCH_CODE — NUMBER
  • SEND_MONTH — CHAR(6)
  • SMS_TYPE — CHAR(3)
  • NOW_DATA — NUMBER
  • MANAGER_NM — VARCHAR(12)
  • MANAGER_PHONENUM — VARCHAR(20)
  • REGDATE — VARCHAR(14)

TVO_BRANCH_EQ_STATUS_202303

  • COLLECTION_DATE — CHAR(8) — 기본 키 — NOT NULL
  • SERV_SEQ — NUMBER — 기본 키 — NOT NULL
  • AREA_CODE — CHAR(5) — 기본 키 — NOT NULL
  • BRANCH_CODE — NUMBER — 기본 키 — NOT NULL
  • MODEL_CODE — CHAR(5) — 기본 키 — NOT NULL
  • CPU_AVG_USAGE — NUMBER — NOT NULL
  • CPU_MAX_USAGE — NUMBER — NOT NULL
  • CPU_MAX_USAGE_TIME — CHAR(6) — NOT NULL
  • MEMORY_AVG_USAGE — NUMBER — NOT NULL
  • MEMORY_MAX_USAGE — NUMBER — NOT NULL
  • MEMORY_MAX_USAGE_TIME — CHAR(6) — NOT NULL
  • REC_BPM_AVG — NUMBER — NOT NULL
  • REC_BPM_MAX — NUMBER — NOT NULL
  • REC_BPM_ACC — NUMBER — NOT NULL
  • REC_BPM_MAX_TIME — CHAR(6) — NOT NULL
  • REC_PPM_AVG — NUMBER — NOT NULL
  • REC_PPM_MAX — NUMBER — NOT NULL
  • REC_PPM_ACC — NUMBER — NOT NULL
  • REC_PPM_MAX_TIME — CHAR(6) — NOT NULL
  • TRN_BPM_AVG — NUMBER
  • TRN_BPM_MAX — NUMBER
  • TRN_BPM_ACC — NUMBER
  • TRN_BPM_MAX_TIME — CHAR(6)
  • TRN_PPM_AVG — NUMBER
  • TRN_PPM_MAX — NUMBER
  • TRN_PPM_ACC — NUMBER
  • TRN_PPM_MAX_TIME — CHAR(6)
  • DEVICE_ACCESSOR_UV — NUMBER — NOT NULL

TVO_BRANCH_EQ_STATUS_STAT

  • COLLECTION_DATE — CHAR(8) — NOT NULL
  • COL_TIME — CHAR(2) — NOT NULL
  • CPU_AVG_USAGE — NUMBER — NOT NULL
  • CPU_MAX_USAGE — NUMBER — NOT NULL
  • CPU_MAX_USAGE_TIME — CHAR(6) — NOT NULL
  • MEMORY_AVG_USAGE — NUMBER — NOT NULL
  • MEMORY_MAX_USAGE — NUMBER — NOT NULL
  • MEMORY_MAX_USAGE_TIME — CHAR(6) — NOT NULL
  • REC_BPM_AVG — NUMBER — NOT NULL
  • REC_BPM_MAX — NUMBER — NOT NULL
  • REC_BPM_ACC — NUMBER — NOT NULL
  • REC_BPM_MAX_TIME — CHAR(6) — NOT NULL
  • REC_PPM_AVG — NUMBER — NOT NULL
  • REC_PPM_MAX — NUMBER — NOT NULL
  • REC_PPM_ACC — NUMBER — NOT NULL
  • REC_PPM_MAX_TIME — CHAR(6) — NOT NULL
  • TRN_BPM_AVG — NUMBER
  • TRN_BPM_MAX — NUMBER
  • TRN_BPM_ACC — NUMBER
  • TRN_BPM_MAX_TIME — CHAR(6)
  • TRN_PPM_AVG — NUMBER
  • TRN_PPM_MAX — NUMBER
  • TRN_PPM_ACC — NUMBER
  • TRN_PPM_MAX_TIME — CHAR(6)
  • BRANCH_CODE — NUMBER — NOT NULL
  • AREA_CODE — CHAR(5)
  • SERV_SEQ — NUMBER
  • BEFORE_BRANCH_CODE — NUMBER
  • BEFORE_AREA_CODE — CHAR(5)
  • MODEL_CODE — CHAR(5)

TVO_BRANCH_INFO

  • BRANCH_CODE — NUMBER — 기본 키 — NOT NULL
  • SERV_SEQ — NUMBER — 기본 키 — NOT NULL
  • BRANCH_NM — VARCHAR(300) — NOT NULL
  • REGUSER_EMAIL — VARCHAR(50) — NOT NULL
  • REGDATE — CHAR(14) — NOT NULL
  • AREA_CODE — CHAR(5) — NOT NULL
  • UPTUSER_EMAIL — VARCHAR(50) — NOT NULL
  • UPTDATE — CHAR(14) — NOT NULL
  • BRANCH_ADDR — VARCHAR(200)
  • BRANCH_FULL_NM — VARCHAR(200) — NOT NULL
  • MANAGER_NM — VARCHAR(20)
  • MANAGER_PHONENUM — VARCHAR(11)
  • IMEI — CHAR(15)
  • COMM_PATH_CODE — CHAR(3) — NOT NULL
  • MAP_X — VARCHAR(11)
  • MAP_Y — VARCHAR(11)
  • SMS_USE_YN — CHAR(1)
  • SMS_START_TIME — CHAR(6)
  • SMS_END_TIME — CHAR(6)
  • SMS_GROUP_SEQ — NUMBER
  • ADSL_NUM1 — VARCHAR(20)
  • ADSL_NUM2 — VARCHAR(20)
  • ADSL_NUM3 — VARCHAR(20)
  • MODIFY_FLAG — CHAR(1)
  • STATE_MEMO — VARCHAR(1000)
  • CONTROL — CHAR(1)

TVO_BRANCH_INTER_STATUS_STAT

  • REC_BPM_MAX — NUMBER
  • REC_BPM_AVG — NUMBER
  • COLLECTION_DATE — CHAR(8) — NOT NULL
  • REC_BPM_ACC — NUMBER
  • REC_PPM_MAX — NUMBER
  • REC_PPM_AVG — NUMBER
  • REC_PPM_ACC — NUMBER
  • TRN_BPM_MAX — NUMBER
  • TRN_BPM_AVG — NUMBER
  • TRN_BPM_ACC — NUMBER
  • TRN_PPM_MAX — NUMBER
  • TRN_PPM_AVG — NUMBER
  • TRN_PPM_ACC — NUMBER
  • COL_TIME — CHAR(2) — NOT NULL
  • PORT_CODE — CHAR(3) — NOT NULL
  • BRANCH_CODE — NUMBER — NOT NULL

TVO_BRANCH_MANAGER_INFO

  • MANAGER_SEQ — NUMBER — 기본 키 — NOT NULL
  • BRANCH_CODE — NUMBER — 기본 키 — NOT NULL
  • MANAGER_NM — VARCHAR(50)
  • MANAGER_PHONENUM — VARCHAR(11)
  • REGDATE — CHAR(14)
  • REGUSER_EMAIL — VARCHAR(50)
  • UPTDATE — CHAR(14)
  • UPTUSER_EMAIL — VARCHAR(50)
  • SMS_GROUP_SEQ — NUMBER

TVO_BRANCH_OBSTACLE_STAT

  • IMPORTANT_CNT — NUMBER
  • CRITICAL_CNT — NUMBER
  • SERIOUS_CNT — NUMBER
  • WARN_CNT — NUMBER
  • OCCUR_DATE — CHAR(8) — NOT NULL
  • BRANCH_CODE — NUMBER — NOT NULL
  • OCCUR_TIME — CHAR(2) — NOT NULL
  • OBSTACLE_CNT — NUMBER
  • BEFORE_BRANCH_CODE — NUMBER

TVO_COMMON_CODE

  • BIGCLASS_CODE — CHAR(3) — 기본 키 — NOT NULL
  • MIDDLECLASS_CODE — CHAR(3) — 기본 키 — NOT NULL
  • SMALLCLASS_CODE — CHAR(3) — 기본 키 — NOT NULL
  • BIGCLASS_NM — VARCHAR(50)
  • ORDER_ORDER — NUMBER
  • MIDDLECLASS_NM — VARCHAR(50)
  • SMALLCLASS_NM — VARCHAR(50)
  • DEL_YN — CHAR(1) — NOT NULL

TVO_COMMON_EACH_CODE

  • BIGCLASS_CODE — CHAR(3) — 기본 키 — NOT NULL
  • MIDDLECLASS_CODE — CHAR(3) — 기본 키 — NOT NULL
  • SMALLCLASS_CODE — CHAR(3) — 기본 키 — NOT NULL
  • SERV_SEQ — NUMBER — 기본 키 — NOT NULL
  • BIGCLASS_NM — VARCHAR(50)
  • ORDER_ORDER — NUMBER
  • MIDDLECLASS_NM — VARCHAR(70)
  • SMALLCLASS_NM — VARCHAR(50)
  • DEL_YN — CHAR(1) — NOT NULL

TVO_COMMON_EACH_CODE_DEFAULT

  • BIGCLASS_CODE — CHAR(3) — NOT NULL
  • SMALLCLASS_CODE — CHAR(3) — NOT NULL
  • BIGCLASS_NM — VARCHAR(50)
  • MIDDLECLASS_CODE — CHAR(3) — NOT NULL
  • ORDER_ORDER — NUMBER
  • MIDDLECLASS_NM — VARCHAR(50)
  • SMALLCLASS_NM — VARCHAR(50)
  • DEL_YN — CHAR(1) — NOT NULL

TVO_DASHBOARD_INFO

  • DASHBOARD_URL — VARCHAR(50) — NOT NULL
  • AREA_CODE — CHAR(5)
  • REG_DATE — VARCHAR(14)
  • USE_YN — CHAR(1)
  • SERV_SEQ — NUMBER

TVO_DASHBOARD_STAT

  • REG_DATE — CHAR(14) — 기본 키 — NOT NULL
  • AREA_CODE — CHAR(5) — 기본 키 — NOT NULL
  • AREA_NM — VARCHAR(20)
  • RUNNING_BUS — NUMBER
  • TOTAL_BUS — NUMBER
  • ERROR1 — NUMBER
  • ERROR2 — NUMBER
  • ERROR3 — NUMBER
  • M8 — VARCHAR(20)
  • DAY18 — VARCHAR(10)
  • DAY19 — VARCHAR(10)
  • DAY20 — VARCHAR(10)
  • DAY21 — VARCHAR(10)
  • DAY22 — VARCHAR(10)
  • DAY23 — VARCHAR(10)
  • DAY24 — VARCHAR(10)
  • DAY25 — VARCHAR(10)
  • DAY26 — VARCHAR(10)
  • DAY27 — VARCHAR(10)
  • DAY28 — VARCHAR(10)
  • DAY29 — VARCHAR(10)
  • DAY30 — VARCHAR(10)
  • DAY31 — VARCHAR(10)

TVO_EQ_ADD_INFO_LOG_202303

  • COL_DATE — CHAR(8) — 기본 키 — NOT NULL
  • COL_TIME — CHAR(6) — 기본 키 — NOT NULL
  • SERV_SEQ — NUMBER — 기본 키 — NOT NULL
  • IMEI — CHAR(15) — 기본 키 — NOT NULL
  • LATITUDE — VARCHAR(15)
  • LONGITUDE — VARCHAR(15)
  • APN — VARCHAR(50)
  • SSID — VARCHAR(200)
  • REGDATE — VARCHAR(14)

TVO_EQ_CONTROL_INFO

  • CONTROL_SEQ — NUMBER — 기본 키 — NOT NULL
  • CONTROL_TITLE — VARCHAR(300)
  • PARAM — VARCHAR(200)
  • CONTROL_TYPE — CHAR(3) — NOT NULL
  • CONTROL_CODE — CHAR(3) — NOT NULL
  • SERV_SEQ — NUMBER — NOT NULL
  • REGUSER_EMAIL — VARCHAR(20)
  • REGDATE — CHAR(14)
  • CONTROL_TARGET — CHAR(3)
  • CONTROL_ALL — CHAR(1)
  • RESERVE_DATE — CHAR(14)
  • EXPIRED_DATE — CHAR(14)

TVO_EQ_CONTROL_PROCESS

  • CONTROL_ORDER_SEQ — NUMBER — 기본 키 — NOT NULL
  • IMEI — CHAR(15) — 기본 키 — NOT NULL
  • REG_TIME — CHAR(14)
  • REGUSER_EMAIL — VARCHAR(50)
  • PARAM — VARCHAR(200)
  • CONTROL_CODE — CHAR(3) — NOT NULL
  • PROCESS_STATUS_CODE — CHAR(3) — NOT NULL
  • CONTROL_SEQ — NUMBER
  • CONTROL_SEARCH_CNT — NUMBER
  • CONTROL_FAIL_MSG — VARCHAR(100)
  • RESERVE_DATE — CHAR(14)
  • EXPIRED_DATE — CHAR(14)

TVO_EQ_CONTROL_PROCESS_LOG

  • CONTROL_PROCESS_SEQ — NUMBER — 기본 키 — NOT NULL
  • IMEI — CHAR(15) — 기본 키 — NOT NULL
  • CONTROL_ORDER_SEQ — NUMBER — 기본 키 — NOT NULL
  • PROCESS_TIME — CHAR(14)
  • PROCESS_MEMO — VARCHAR(100)
  • PROCESS_STATUS_CODE — CHAR(3)

TVO_EQ_CONTROL_TARGET

  • CONTROL_SEQ — NUMBER
  • TARGET_NAME — VARCHAR(200)

TVO_EQ_INFO

  • IMEI — CHAR(15) — 기본 키 — NOT NULL
  • PHONENUM — VARCHAR(11)
  • MEMO — VARCHAR(1000)
  • AUTO_SWITCHING_MODE_YN — CHAR(1)
  • WIRE_IP_ADDR — VARCHAR(15)
  • WIRE_GW_ADDR — VARCHAR(15)
  • WIRE_SM_ADDR — VARCHAR(15)
  • THRESHOLD_APP_YN — CHAR(1) — NOT NULL
  • EQ_STATUS_NORMAL_YN — CHAR(1)
  • INTRODUCTION_DATE — CHAR(14) — NOT NULL
  • UPT_DATE — CHAR(14) — NOT NULL
  • MODEL_CODE — CHAR(5)
  • COMM_FIRST_CODE — VARCHAR(3)
  • POSSESSION_YN — CHAR(1) — NOT NULL
  • FIRM_VER — VARCHAR(15)
  • EQ_POSSESSION_MANAGER — VARCHAR(100)
  • PING_TIMEOUT_COUNT — NUMBER
  • SERV_SEQ — NUMBER — NOT NULL
  • MAC_ADDR — VARCHAR(30) — NOT NULL

TVO_EQ_MODEL_INFO

  • MODEL_CODE — CHAR(5) — 기본 키 — NOT NULL
  • SERV_SEQ — NUMBER — 기본 키 — NOT NULL
  • MODEL_NM — VARCHAR(40) — NOT NULL
  • MAKER — CHAR(3) — NOT NULL
  • CONTACT — VARCHAR(11)
  • USE_YN — CHAR(1)
  • REGUSER_EMAIL — VARCHAR(50) — NOT NULL
  • REGDATE — CHAR(14) — NOT NULL
  • IMG_URL — VARCHAR(200)
  • UPTDATE — CHAR(14)

TVO_EQ_STATUS_INFO

  • IMEI — CHAR(15) — 기본 키 — NOT NULL
  • BM_NUM — NUMBER
  • RSSI — NUMBER
  • FIRM_VER — VARCHAR(15)
  • COMM_STATUS_CODE — VARCHAR(3) — NOT NULL
  • CPU_USAGE — NUMBER
  • MEMORY_USAGE — NUMBER
  • REC_PPM — NUMBER
  • COMM_PATH_CODE — VARCHAR(3) — NOT NULL
  • WIRELESS_IP_ADDR — VARCHAR(15)
  • LOSSVAL — NUMBER
  • MAC_ADDR — VARCHAR(23)
  • REC_BPM — NUMBER
  • LAST_COMM_TIME — CHAR(14)
  • CPU_AVG — NUMBER
  • MEMORY_AVG — NUMBER
  • CPU_MAX — NUMBER
  • MEMORY_MAX — NUMBER
  • CPU_MAX_OCCUR_TIME — CHAR(6)
  • MEMORY_MAX_OCCUR_TIME — CHAR(6)
  • TRN_PPM — NUMBER
  • TRN_BPM — NUMBER
  • FIRM_UPDATE_PROCESS_YN — CHAR(1) — NOT NULL
  • LOCK_YN — CHAR(1) — NOT NULL
  • TRN_BPM_AVG — NUMBER
  • TRN_BPM_ACC — NUMBER
  • TRN_BPM_MAX — NUMBER
  • TRN_PPM_AVG — NUMBER
  • TRN_PPM_MAX — NUMBER
  • TRN_PPM_ACC — NUMBER
  • LOSSVAL_AVG — NUMBER
  • LOSSVAL_MAX — NUMBER
  • LOSSVAL_ACC — NUMBER
  • TRN_BPM_MAX_OCCUR_TIME — CHAR(6)
  • TRN_PPM_MAX_OCCUR_TIME — CHAR(6)
  • REC_BPM_AVG — NUMBER
  • REC_BPM_MAX — NUMBER
  • REC_BPM_ACC — NUMBER
  • REC_BPM_MAX_OCCUR_TIME — CHAR(6)
  • REC_PPM_AVG — NUMBER
  • REC_PPM_MAX — NUMBER
  • REC_PPM_ACC — NUMBER
  • REC_PPM_MAX_OCCUR_TIME — CHAR(6)
  • CPU_MAX_AVG — NUMBER
  • MEMORY_MAX_AVG — NUMBER
  • LOSSVAL_MAX_OCCUR_TIME — CHAR(6)
  • OBSTACLE_COUNT — NUMBER
  • PING_ADDR — VARCHAR(15)
  • WIRELESS_CHANGE_DELAY_TIME — NUMBER
  • NOTEBOOK_CONNECT_COUNT — NUMBER
  • EQ_TRN_PPM_AVG — NUMBER
  • EQ_REC_PPM_AVG — NUMBER
  • EQ_TRN_BPM_AVG — NUMBER
  • EQ_REC_BPM_AVG — NUMBER
  • EQ_LOSSVAL_AVG — NUMBER
  • MEMORY_TOTAL — NUMBER
  • OB_CPU — VARCHAR(20)
  • OB_MEM — VARCHAR(20)
  • OB_TBPS — VARCHAR(20)
  • OB_RBPS — VARCHAR(20)
  • … +9

TVO_EQ_STATUS_LOG_20230321

  • COLLECTION_DATE — CHAR(8) — 기본 키 — NOT NULL
  • COL_TIME — CHAR(6) — 기본 키 — NOT NULL
  • IMEI — CHAR(15) — 기본 키 — NOT NULL
  • TRN_PPM — NUMBER — 기본 키 — NOT NULL
  • REC_PPM — NUMBER — 기본 키 — NOT NULL
  • TRN_BPM — NUMBER — 기본 키 — NOT NULL
  • REC_BPM — NUMBER — 기본 키 — NOT NULL
  • MDN — VARCHAR(11)
  • WIRE_IP_ADDR — VARCHAR(15)
  • WIRE_SM_ADDR — VARCHAR(15)
  • WIRE_GW_ADDR — VARCHAR(15)
  • WIRELESS_IP_ADDR — VARCHAR(15)
  • MAC_ADDR — VARCHAR(23)
  • COMM_PATH_CODE — VARCHAR(3)
  • USIM_CONNECT_YN — CHAR(1)
  • COMM_FIRST_CODE — VARCHAR(3)
  • AUTO_SWITCHING_MODE_YN — CHAR(1)
  • INTERFACE_COUNT — NUMBER
  • STATUS_INFO_COUNT — NUMBER
  • CPU_USAGE — NUMBER
  • MEMORY_TOTAL — NUMBER
  • MEMORY_USAGE — NUMBER
  • LOSSVAL — NUMBER
  • MDN_LENGTH — NUMBER
  • WIRELESS_CHANGE_DELAY_TIME — NUMBER
  • NOTEBOOK_CONNECT_COUNT — NUMBER
  • EQ_TRN_PPM_AVG — NUMBER
  • EQ_REC_PPM_AVG — NUMBER
  • EQ_TRN_BPM_AVG — NUMBER
  • EQ_REC_BPM_AVG — NUMBER
  • EQ_LOSSVAL_AVG — NUMBER
  • PING_TIMEOUT_COUNT — NUMBER
  • BM_NUM — NUMBER
  • FIRM_VER — VARCHAR(15)
  • RSSI — NUMBER
  • HOUR — CHAR(2)
  • MIN — CHAR(2)
  • PORT_STATUS_COUNT — NUMBER

TVO_EVENT_INFO

  • EVENT_SEQ — NUMBER — 기본 키 — NOT NULL
  • EVENT_OCCURDATE — CHAR(14)
  • MSG — VARCHAR(200)
  • IMEI — CHAR(15) — NOT NULL
  • EVENT_TYPE_CODE — CHAR(3) — NOT NULL
  • SERV_SEQ — NUMBER — NOT NULL

TVO_EXTERNAL_BANNER_INFO

  • SVC_CODE — CHAR(2) — 기본 키 — NOT NULL
  • SORT_NUM — NUMBER — 기본 키 — NOT NULL
  • COL_DATE — CHAR(14) — NOT NULL
  • REG_NUM — VARCHAR(10)
  • TITLE — VARCHAR(600)
  • ORI_IMG_NM — VARCHAR(200)
  • NEW_IMG_NM — VARCHAR(200) — NOT NULL
  • IMG_HREF — VARCHAR(200)
  • DESCRIPTION — VARCHAR(2000)

TVO_FAKE_EQ_SET_INFO

  • MOVE_YN — CHAR(1)
  • LAST_COMM_TIME — CHAR(14)
  • CPU_MAX_USE — NUMBER
  • CPU_MIN_USE — NUMBER
  • MEMORY_MAX_USE — NUMBER
  • MEMORY_MIN_USE — NUMBER
  • TRN_PPS_MAX_USE — NUMBER
  • TRN_PPS_MIN_USE — NUMBER
  • REC_PPS_MAX_USE — NUMBER
  • REC_PPS_MIN_USE — NUMBER
  • TRN_BPS_MAX_USE — NUMBER
  • TRN_BPS_MIN_USE — NUMBER
  • REC_BPS_MAX_USE — NUMBER
  • REC_BPS_MIN_USE — NUMBER
  • RSSI_MAX_USE — NUMBER
  • RSSI_MIN_USE — NUMBER
  • PING_DELAY_MAX_TIME — NUMBER
  • PING_DELAY_MIN_TIME — NUMBER
  • REGUSER_EMAIL — VARCHAR(30)
  • REGDATE — CHAR(14)
  • UPTUSER_EMAIL — VARCHAR(30)
  • UPTDATE — CHAR(14)

TVO_GROUP_USAGE_RANGE_CNT_STAT_2023

  • COL_DATE — CHAR(6) — 기본 키 — NOT NULL
  • SERV_SEQ — NUMBER — 기본 키 — NOT NULL
  • AREA_NM — VARCHAR(40) — 기본 키 — NOT NULL
  • RANGE1 — NUMBER
  • RANGE2 — NUMBER
  • RANGE3 — NUMBER
  • RANGE4 — NUMBER
  • RANGE5 — NUMBER
  • RANGE6 — NUMBER
  • RANGE7 — NUMBER
  • RANGE8 — NUMBER
  • RANGE9 — NUMBER
  • RANGE10 — NUMBER
  • RANGE11 — NUMBER
  • RANGE12 — NUMBER
  • RANGE13 — NUMBER
  • RANGE14 — NUMBER
  • RANGE15 — NUMBER
  • RANGE16 — NUMBER
  • RANGE17 — NUMBER
  • RANGE18 — NUMBER
  • RANGE19 — NUMBER
  • RANGE20 — NUMBER
  • RANGE21 — NUMBER
  • RANGE22 — NUMBER
  • RANGE23 — NUMBER
  • GROUP_SUM — NUMBER

TVO_INTER_INFO

  • IMEI — CHAR(15) — 기본 키 — NOT NULL
  • PORT_CODE — VARCHAR(3) — 기본 키 — NOT NULL
  • PORT_NM — VARCHAR(20)

TVO_INTER_STATUS_INFO

  • IMEI — CHAR(15) — 기본 키 — NOT NULL
  • PORT_CODE — VARCHAR(3) — 기본 키 — NOT NULL
  • PORT_CONN_YN — CHAR(1) — NOT NULL
  • REC_BPM — NUMBER
  • TRN_PPM — NUMBER
  • INNER_ASSIGN_IP_ADDR — VARCHAR(15)
  • TRN_BPM — NUMBER
  • REC_PPM — NUMBER
  • REC_BPM_AVG — NUMBER
  • REC_BPM_MAX — NUMBER
  • REC_BPM_ACC — NUMBER
  • REC_PPM_AVG — NUMBER
  • REC_PPM_MAX — NUMBER
  • REC_PPM_ACC — NUMBER
  • LOSSVAL_AVG — NUMBER
  • LOSSVAL_MAX — NUMBER
  • LOSSVAL_ACC — NUMBER
  • TRN_BPM_AVG — NUMBER
  • TRN_BPM_MAX — NUMBER
  • TRN_BPM_ACC — NUMBER
  • TRN_PPM_AVG — NUMBER
  • TRN_PPM_MAX — NUMBER
  • TRN_PPM_ACC — NUMBER
  • LOSSVAL — NUMBER
  • PORT_TYPE — CHAR(1)

TVO_LOGIN_CLUSTER

  • SESSION_ID — CHAR(36) — NOT NULL
  • USER_ID — VARCHAR(100)
  • SERV_SEQ — NUMBER
  • REG_DATE — CHAR(14)

TVO_MENU_AUTH_MAPPING

  • AUTH_CODE — CHAR(3) — 기본 키 — NOT NULL
  • GROUP_CODE — CHAR(3) — 기본 키 — NOT NULL
  • MENU_ID — CHAR(6) — 기본 키 — NOT NULL
  • SERV_SEQ — NUMBER — 기본 키 — NOT NULL
  • REGDATE — VARCHAR(14)
  • REGUSER_EMAIL — VARCHAR(50)
  • OPEN_YN — CHAR(1) — NOT NULL

TVO_MENU_AUTH_MAPPING_DEFAULT

  • AUTH_CODE — CHAR(3) — NOT NULL
  • GROUP_CODE — CHAR(3) — NOT NULL
  • MENU_ID — CHAR(6) — NOT NULL
  • REGDATE — VARCHAR(14)
  • REGUSER_EMAIL — VARCHAR(50)
  • OPEN_YN — CHAR(1) — NOT NULL

TVO_MENU_INFO

  • MENU_ID — CHAR(6) — 기본 키 — NOT NULL
  • MENU_DEPTH — NUMBER — NOT NULL
  • MENU_NM — VARCHAR(200)
  • MENU_URL — VARCHAR(200)
  • POPUP_YN — CHAR(1) — NOT NULL
  • USE_YN — CHAR(1) — NOT NULL
  • ADMIN_YN — CHAR(1) — NOT NULL
  • UPPER_MENU — CHAR(6) — NOT NULL

TVO_NOTICE_INFO

  • NOTICE_SEQ — NUMBER — 기본 키 — NOT NULL
  • NOTICE_TITLE — VARCHAR(200) — NOT NULL
  • NOTICE_CONTENT — VARCHAR(2000) — NOT NULL
  • NOTICE_WIDTH — NUMBER — NOT NULL
  • NOTICE_HEIGHT — NUMBER — NOT NULL
  • NOTICE_OPEN_YN — CHAR(1) — NOT NULL
  • NOTICE_DEL_YN — CHAR(1) — NOT NULL
  • REGUSER_EMAIL — VARCHAR(20) — NOT NULL
  • REGDATE — CHAR(14) — NOT NULL
  • UPTUSER_EMAIL — VARCHAR(20)
  • UPTDATE — CHAR(14)

TVO_NOTICE_SERV_MAPPING

  • NOTICE_SEQ — NUMBER
  • SERV_SEQ — NUMBER
  • REGUSER_EMAIL — VARCHAR(20) — NOT NULL
  • REGDATE — CHAR(14) — NOT NULL

TVO_OBSTACLE_CODE_INFO

  • OBSTACLE_CODE — CHAR(5) — 기본 키 — NOT NULL
  • SERV_SEQ — NUMBER — 기본 키 — NOT NULL
  • OBSTACLE_CODE_NM — VARCHAR(50)
  • OBSTACLE_LV_CODE — CHAR(3)
  • SEND_YN — CHAR(1) — NOT NULL
  • SMS_WORDS — VARCHAR(200)
  • VIEW_EXPRESS_MESSAGE — VARCHAR(100)
  • GROUP_CODE — CHAR(3) — NOT NULL
  • AUTH_CODE — CHAR(3) — NOT NULL

TVO_OBSTACLE_CODE_INFO_DEFAULT

  • OBSTACLE_CODE — CHAR(5) — NOT NULL
  • OBSTACLE_CODE_NM — VARCHAR(50)
  • OBSTACLE_LV_CODE — CHAR(3)
  • SEND_YN — CHAR(1) — NOT NULL
  • SMS_WORDS — VARCHAR(200)
  • VIEW_EXPRESS_MESSAGE — VARCHAR(100)
  • GROUP_CODE — CHAR(3) — NOT NULL
  • AUTH_CODE — CHAR(3) — NOT NULL

TVO_OBSTACLE_INFO

  • OBSTACLE_SEQ — NUMBER — 기본 키 — NOT NULL
  • OBSTACLE_OCCURDATE — CHAR(14)
  • MSG — VARCHAR(200)
  • MEMO — VARCHAR(200)
  • OBSTACLE_RESTORE_YN — CHAR(1)
  • PROCESSDATES — CHAR(14)
  • PROCESSUSER_EMAIL — VARCHAR(50)
  • WIRE_IP_ADDR — VARCHAR(15)
  • CPU_USAGE — NUMBER
  • WIRELESS_IP_ADDR — VARCHAR(15)
  • RSSI — NUMBER
  • BM_NUM — NUMBER
  • MEMORY_USAGE — NUMBER
  • TRN_BPM — NUMBER
  • TRN_PPM — NUMBER
  • LOSSVAL — NUMBER
  • OBSTACLE_CODE — CHAR(5)
  • REC_BPM — NUMBER
  • REC_PPM — NUMBER
  • COMM_PATH_CODE — VARCHAR(3)
  • COMM_FIRST_CODE — VARCHAR(3)
  • AUTO_SWITCHING_MODE_YN — CHAR(1)
  • COMM_STATUS_CODE — VARCHAR(3)
  • WIRE_GW_ADDR — VARCHAR(15)
  • WIRE_SM_ADDR — VARCHAR(15)
  • MAC_ADDR — VARCHAR(23)
  • LOCK_YN — CHAR(1)
  • IMEI — CHAR(15) — NOT NULL
  • PING_ADDR — VARCHAR(15)
  • WIRELESS_CHANGE_DELAY_TIME — NUMBER
  • NOTEBOOK_CONNECT_COUNT — NUMBER
  • EQ_TRN_PPM_AVG — NUMBER
  • EQ_REC_PPM_AVG — NUMBER
  • EQ_TRN_BPM_AVG — NUMBER
  • EQ_REC_BPM_AVG — NUMBER
  • EQ_LOSSVAL_AVG — NUMBER
  • LAST_COMM_TIME — CHAR(14)
  • FIRM_UPDATE_PROCESS_YN — CHAR(1)
  • SERV_SEQ — NUMBER

TVO_OBSTACLE_INFO_SHUTTLEBUS

  • OBSTACLE_SEQ — NUMBER — 기본 키 — NOT NULL
  • OBSTACLE_OCCURDATE — CHAR(14)
  • MSG — VARCHAR(200)
  • MEMO — VARCHAR(200)
  • OBSTACLE_RESTORE_YN — CHAR(1)
  • PROCESSDATES — CHAR(14)
  • PROCESSUSER_EMAIL — VARCHAR(50)
  • WIRE_IP_ADDR — VARCHAR(15)
  • CPU_USAGE — NUMBER
  • WIRELESS_IP_ADDR — VARCHAR(15)
  • RSSI — NUMBER
  • BM_NUM — NUMBER
  • MEMORY_USAGE — NUMBER
  • TRN_BPM — NUMBER
  • TRN_PPM — NUMBER
  • LOSSVAL — NUMBER
  • OBSTACLE_CODE — CHAR(5)
  • REC_BPM — NUMBER
  • REC_PPM — NUMBER
  • COMM_PATH_CODE — VARCHAR(3)
  • COMM_FIRST_CODE — VARCHAR(3)
  • AUTO_SWITCHING_MODE_YN — CHAR(1)
  • COMM_STATUS_CODE — VARCHAR(3)
  • WIRE_GW_ADDR — VARCHAR(15)
  • WIRE_SM_ADDR — VARCHAR(15)
  • MAC_ADDR — VARCHAR(23)
  • LOCK_YN — CHAR(1)
  • IMEI — CHAR(15) — NOT NULL
  • PING_ADDR — VARCHAR(15)
  • WIRELESS_CHANGE_DELAY_TIME — NUMBER
  • NOTEBOOK_CONNECT_COUNT — NUMBER
  • EQ_TRN_PPM_AVG — NUMBER
  • EQ_REC_PPM_AVG — NUMBER
  • EQ_TRN_BPM_AVG — NUMBER
  • EQ_REC_BPM_AVG — NUMBER
  • EQ_LOSSVAL_AVG — NUMBER
  • LAST_COMM_TIME — CHAR(14)
  • FIRM_UPDATE_PROCESS_YN — CHAR(1)
  • SERV_SEQ — NUMBER

TVO_RECEIPT_INFO

  • RECEIPT_SEQ — NUMBER — 기본 키 — NOT NULL
  • RECEIPT_CODE — VARCHAR(20)
  • RECEIPT_STATUS — VARCHAR(20)
  • AREA_CODE — VARCHAR(20)
  • CAR_NUMBER — VARCHAR(20)
  • ATTACH_YN — CHAR(14)
  • RECEIPT_TITLE — VARCHAR(100)
  • REGDATE — CHAR(14)
  • UPTDATE — CHAR(14)
  • USER_NM — VARCHAR(30)
  • USER_EMAIL — VARCHAR(50)
  • RECEIPT_CONTENT — VARCHAR(5000)
  • FILE_NM — VARCHAR(5000)
  • RECEIPT_DATE — CHAR(14)
  • COMPLETE_DATE — CHAR(14)
  • RECEIPT_YN — CHAR(1)
  • COMPLETE_YN — CHAR(1)
  • RECEIPT_USER_NM — VARCHAR(50)
  • RECEIPT_USER_EMAIL — VARCHAR(30)
  • SERV_SEQ — NUMBER
  • RECEIPT_REPLY — VARCHAR(3000)
  • RECEIPT_CONTENT2 — VARCHAR(3000)
  • NOTICE_YN — CHAR(1)
  • ORGFILE_NM — VARCHAR(100)

TVO_SCHEDULE_INFO

  • STAT_TARGET — VARCHAR(40) — 기본 키 — NOT NULL
  • UPT_DATE — CHAR(8) — NOT NULL
  • UPT_TIME — CHAR(6) — NOT NULL
  • STAT_TARGET_NM — VARCHAR(150)

TVO_SEOUL_BANNER_LINK_INFO

  • SORT — NUMBER — 기본 키 — NOT NULL
  • ORI_IMG_NM — VARCHAR(50) — 기본 키 — NOT NULL
  • COL_DATE — CHAR(14) — NOT NULL
  • NEW_IMG_NM — VARCHAR(20) — NOT NULL
  • TITLE — VARCHAR(600) — NOT NULL
  • IMG_HREF — VARCHAR(200) — NOT NULL

TVO_SERV_INFO

  • SERV_SEQ — NUMBER — 기본 키 — NOT NULL
  • SERV_DEL_YN — CHAR(1) — NOT NULL
  • SERV_NAME — VARCHAR(200)
  • SERV_MAIN_FILE — VARCHAR(50) — NOT NULL
  • SERV_MONITORING_YN — CHAR(1) — NOT NULL
  • SERV_SMS_TYPE — CHAR(3)
  • REGUSER_EMAIL — VARCHAR(40)
  • REGDATE — VARCHAR(14)
  • UPTUSER_EMAIL — VARCHAR(40)
  • UPTDATE — VARCHAR(14)
  • SERV_CD — CHAR(2)
  • LIMIT_LICENSE_CNT — NUMBER
  • RADIUS_USE_YN — CHAR(1)
  • CHANGE_USE_YN — CHAR(1)
  • MAP_USE_YN — CHAR(1)
  • DASHBOARD_USE_YN — CHAR(1)
  • OBSTACLE_SMS_USE_YN — CHAR(1)
  • MAIN_MAP_USE_YN — VARCHAR(1)
  • DNS_ADDR — VARCHAR(20)

TVO_SERV_USER_MAPPING

  • USER_EMAIL — VARCHAR(50)
  • SERV_SEQ — NUMBER
  • REGUSER_EMAIL — VARCHAR(50)
  • REGDATE — VARCHAR(14)

TVO_SHUTTLEBUS_OB_INFO

  • IMEI — CHAR(15) — 기본 키 — NOT NULL
  • SEQ — NUMBER — NOT NULL
  • MAC_ADDR — VARCHAR(30) — NOT NULL
  • SERV_SEQ — NUMBER — NOT NULL
  • CLASS_CODE — CHAR(3)
  • UPSERT_DATE — CHAR(14)

TVO_SMS_GROUP_INFO

  • SMS_GROUP_SEQ — NUMBER — 기본 키 — NOT NULL
  • SMS_GROUP_NM — VARCHAR(50) — NOT NULL
  • AREA_CODE — CHAR(5) — NOT NULL
  • SMS_USE_YN — CHAR(1)
  • SMS_START_TIME — CHAR(6)
  • SMS_END_TIME — CHAR(6)
  • REGDATE — CHAR(14)
  • REG_USER_EMAIL — VARCHAR(50)
  • SERV_SEQ — NUMBER — NOT NULL

TVO_SMS_SEND_LOG

  • SERV_SEQ — NUMBER — 기본 키 — NOT NULL
  • IMEI — CHAR(15) — 기본 키 — NOT NULL
  • SMS_SEQ — NUMBER — NOT NULL
  • USER_EMAIL — VARCHAR(50)
  • CMID — VARCHAR(32) — NOT NULL
  • BRANCH_CODE — NUMBER — NOT NULL
  • REG_DATE — VARCHAR(14)

TVO_TABLESPACE_OBSTACLE_MSG

  • CMID — VARCHAR(32) — 기본 키 — NOT NULL
  • UMID — VARCHAR(32)
  • MSG_TYPE — NUMBER(2,0)
  • STATUS — NUMBER(2,0)
  • CALL_STATUS — VARCHAR(4)
  • REQUEST_TIME — DATE — NOT NULL
  • SEND_TIME — DATE — NOT NULL
  • REPORT_TIME — DATE
  • DEST_PHONE — VARCHAR(16)
  • SEND_PHONE — VARCHAR(16)
  • DEST_NAME — VARCHAR(32)
  • SEND_NAME — VARCHAR(32)
  • SUBJECT — VARCHAR(64)
  • MSG_BODY — VARCHAR(2000)
  • NATION_CODE — VARCHAR(5)
  • SENDER_KEY — VARCHAR(40)
  • TEMPLATE_CODE — VARCHAR(30)
  • RESPONSE_METHOD — VARCHAR(8)
  • TIMEOUT — NUMBER(4,0)
  • RE_TYPE — VARCHAR(3)
  • RE_BODY — VARCHAR(2000)
  • RE_PART — VARCHAR(1)
  • WAP_URL — VARCHAR(80)
  • COVER_FLAG — NUMBER(1,0)
  • SMS_FLAG — NUMBER(1,0)
  • REPLY_FLAG — NUMBER(1,0)
  • RETRY_CNT — NUMBER(4,0)
  • ATTACHED_FILE — VARCHAR(1000)
  • VXML_FILE — VARCHAR(64)
  • USE_PAGE — NUMBER(4,0)
  • USE_TIME — NUMBER(4,0)
  • SN_RESULT — NUMBER(1,0)
  • TEL_INFO — VARCHAR(10)
  • CINFO — VARCHAR(32)
  • USER_KEY — VARCHAR(30)
  • AD_FLAG — VARCHAR(1)

TVO_THRESHOLD_INFO

  • SERV_SEQ — NUMBER — 기본 키 — NOT NULL
  • THRESHOLD_SEQ — NUMBER — 기본 키 — NOT NULL
  • CPU_MAX_WARN_USAGE — NUMBER
  • CPU_USAGE_MAINTAINTIME — NUMBER
  • MEMORY_MAX_ERR_USAGE — NUMBER
  • MEMORY_USAGE_MAINTAINTIME — NUMBER
  • EQ_CONN_GAP_THRESHOLD — NUMBER
  • EQ_CONN_GAP_WAIT_NUM — NUMBER
  • INSPECTION_TYPE_CODE — CHAR(3) — NOT NULL
  • INSPECTION_STARTDATE — CHAR(8)
  • INSPECTION_START_TIME — CHAR(4)
  • UPTUSER_EMAIL — VARCHAR(20)
  • UPTDATE — CHAR(14)
  • INSPECTION_ENDDATE — CHAR(8)
  • INSPECTION_FINISH_TIME — CHAR(4)
  • EQ_CONN_OBSTACLE_DECISION_YN — CHAR(1)
  • REC_BPM_MAX_ERR_USAGE — NUMBER
  • REC_BPM_USAGE_MAINTAINTIME — NUMBER
  • REC_PPM_MAX_ERR_USAGE — NUMBER
  • REC_PPM_USAGE_MAINTAINTIME — NUMBER
  • TRN_BPM_MAX_ERR_USAGE — NUMBER
  • TRN_BPM_USAGE_MAINTAINTIME — NUMBER
  • TRN_PPM_MAX_WARN_USAGE — NUMBER
  • TRN_PPM_USAGE_MAINTAINTIME — NUMBER
  • MEMORY_MAX_WARN_USAGE — NUMBER
  • REC_BPM_MAX_WARN_USAGE — NUMBER
  • TRN_BPM_MAX_WARN_USAGE — NUMBER
  • REC_PPM_MAX_WARN_USAGE — NUMBER
  • TRN_PPM_MAX_ERR_USAGE — NUMBER
  • CPU_MAX_ERR_USAGE — NUMBER
  • RSSI_THRESHOLD — NUMBER

TVO_THRESHOLD_INFO_DEFAULT

  • THRESHOLD_SEQ — NUMBER — NOT NULL
  • CPU_MAX_WARN_USAGE — NUMBER
  • CPU_USAGE_MAINTAINTIME — NUMBER
  • MEMORY_MAX_ERR_USAGE — NUMBER
  • MEMORY_USAGE_MAINTAINTIME — NUMBER
  • EQ_CONN_GAP_THRESHOLD — NUMBER
  • EQ_CONN_GAP_WAIT_NUM — NUMBER
  • INSPECTION_TYPE_CODE — CHAR(3) — NOT NULL
  • INSPECTION_STARTDATE — CHAR(8)
  • INSPECTION_START_TIME — CHAR(4)
  • UPTUSER_EMAIL — VARCHAR(20)
  • UPTDATE — CHAR(14)
  • INSPECTION_ENDDATE — CHAR(8)
  • INSPECTION_FINISH_TIME — CHAR(4)
  • EQ_CONN_OBSTACLE_DECISION_YN — CHAR(1)
  • REC_BPM_MAX_ERR_USAGE — NUMBER
  • REC_BPM_USAGE_MAINTAINTIME — NUMBER
  • REC_PPM_MAX_ERR_USAGE — NUMBER
  • REC_PPM_USAGE_MAINTAINTIME — NUMBER
  • TRN_BPM_MAX_ERR_USAGE — NUMBER
  • TRN_BPM_USAGE_MAINTAINTIME — NUMBER
  • TRN_PPM_MAX_WARN_USAGE — NUMBER
  • TRN_PPM_USAGE_MAINTAINTIME — NUMBER
  • MEMORY_MAX_WARN_USAGE — NUMBER
  • REC_BPM_MAX_WARN_USAGE — NUMBER
  • TRN_BPM_MAX_WARN_USAGE — NUMBER
  • REC_PPM_MAX_WARN_USAGE — NUMBER
  • TRN_PPM_MAX_ERR_USAGE — NUMBER
  • CPU_MAX_ERR_USAGE — NUMBER
  • RSSI_THRESHOLD — NUMBER

TVO_TOPIS_BUS_POS_INFO

  • PLAIN_NO — VARCHAR(20) — 기본 키 — NOT NULL
  • VEH_ID — VARCHAR(15) — 기본 키 — NOT NULL
  • ROUTE_ID — VARCHAR(10) — 기본 키 — NOT NULL
  • BUS_TYPE — CHAR(1) — NOT NULL
  • DATA_TM — CHAR(14) — NOT NULL
  • LONGITUDE — VARCHAR(10) — NOT NULL
  • LATITUDE — VARCHAR(10) — NOT NULL
  • BEFORE_LONGITUDE — VARCHAR(10)
  • BEFORE_LATITUDE — VARCHAR(10)
  • IS_RUN_YN — CHAR(1) — NOT NULL
  • STOP_FLAG — CHAR(1)
  • IS_LAST_YN — CHAR(1)
  • IS_FULL_FLAG — CHAR(1)
  • CONGESTION — CHAR(1)
  • NEXT_ST_ID — VARCHAR(15)
  • NEXT_ST_TM — VARCHAR(5)
  • LAST_STN_ID — VARCHAR(15)
  • LAST_ST_TM — VARCHAR(5)
  • FULL_SECT_DIST — VARCHAR(10)
  • TRN_STN_ID — VARCHAR(15)
  • SECTION_ID — VARCHAR(15)
  • SECT_ORD — VARCHAR(5)
  • SECT_DIST — VARCHAR(10)
  • RT_DIST — VARCHAR(10)
  • POS_LATI — VARCHAR(20)
  • POS_LONGI — VARCHAR(20)

TVO_TOPIS_BUS_ROUTE_INFO

  • ROUTE_ID — VARCHAR(10) — 기본 키 — NOT NULL
  • ROUTE_NM — VARCHAR(20) — 기본 키 — NOT NULL
  • ROUTE_TYPE — VARCHAR(2)
  • ROUTE_LENGTH — VARCHAR(10)
  • ROUTE_ST_NM — VARCHAR(50)
  • ROUTE_ED_NM — VARCHAR(50)
  • ROUTE_TERM — VARCHAR(3)
  • ROUTE_CORP_NM — VARCHAR(50)
  • ROUTE_PROC_DT — VARCHAR(14)

TVO_USER_CONN_LOG

  • LOG_SEQ — CHAR(5) — 기본 키 — NOT NULL
  • USER_EMAIL — VARCHAR(50) — 기본 키 — NOT NULL
  • CONNDATE — CHAR(14) — NOT NULL
  • CONN_IP — VARCHAR(15)

TVO_USER_INFO

  • USER_EMAIL — VARCHAR(50) — 기본 키 — NOT NULL
  • USER_NM — VARCHAR(30) — NOT NULL
  • AREA_CODE — CHAR(5)
  • PHONENUM — VARCHAR(11)
  • PASSWD — VARCHAR(100) — NOT NULL
  • REGDATE — CHAR(14)
  • UPTDATE — CHAR(14)
  • LAST_CONNDATE — CHAR(14)
  • SMS_REC_YN — CHAR(1) — NOT NULL
  • LAST_CONNIP — VARCHAR(15)
  • REGUSER_EMAIL — VARCHAR(50)
  • UPTUSER_EMAIL — VARCHAR(50)
  • AUTH_CODE — CHAR(3) — NOT NULL
  • EXPIREDDATE — CHAR(8)
  • EXTENSIONNUM — VARCHAR(11)
  • EXTENSIONUSE_YN — CHAR(1)
  • WORK_YN — CHAR(1)
  • GROUP_CODE — CHAR(3) — NOT NULL
  • SERV_SEQ — NUMBER
  • USER_CODE — CHAR(3) — NOT NULL
  • EQ_MODIFY_FLAG — CHAR(1)