회사
테이블 (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)