Tibero Schema Console
Tibero 6
Postgres
INVALID 18
EMAS · 2026-06-18 19:52:10 +0900 · Tibero Tibero_6.0.166454_JDBC_1.6_release_20190918 6.0.
Tables
317
317 valid
Rows
182,387,283
315 counted
Columns
6,470
432 indexes
Invalid
18
2 count timeout
Largest Tables
actual count 기준 상위 테이블
Rows
UDRS_MEAS_DATA_CHG_HIS (측정 데이터 처리 이력)32,299,649 rows
UDRS_ANZE_SAMP_RSLT (샘플분석결과)27,247,008 rows
UDRS_ANZE_RPT_DET (시험 성적서 상세)21,973,341 rows
UDRS_MEAS_DATA_ATCH (측정 데이터 첨부파일)16,689,516 rows
MGMT_LOGIN_HIS (사용자 로그인 이력)11,776,435 rows
ST_SEMS_MEAS6,081,892 rows
ECOLAB_ATCH_FILE_MAP (에코랩첨부파일매핑)5,773,024 rows
ECOLAB_ATCH_FILE (에코랩첨부파일)5,760,581 rows
UDRS_MEAS_PLAN (시료 측정 계획)3,658,162 rows
UDRS_MEAS_DATA (시료 측정 데이터)3,652,346 rows
UDRS_MEAS_DATA_SAMP (측정데이터-샘플)3,648,980 rows
UDRS_MEAS_DATA_FAC (현장측정 배출사업장)3,648,472 rows
Object State
schema object status
FUNCTION
INVALID
13FUNCTION
VALID
39INDEX
VALID
461LOB
VALID
29PACKAGE
VALID
1PACKAGE BODY
VALID
1PROCEDURE
INVALID
5PROCEDURE
VALID
1SEQUENCE
VALID
129TABLE
VALID
317Domain Prefix
table prefix 기준 table 분포
UDRS
72 tables
MGMT
42 tables
ECOLAB
5 tables
CONT
40 tables
ST
10 tables
COMM
53 tables
MEAS
3 tables
SEMS
10 tables
SVC
29 tables
SV
16 tables
RAWS
6 tables
ACCESS
1 tables
TMP
4 tables
COPY
1 tables
Keys & Constraints
schema integrity map
129 sequences
Primary Keys
259Unique
16Foreign Keys
79Empty Tables
17FNC_GET_ANZE_OBEY_YN_20230117
FUNCTION
FNC_GET_ANZE_OBEY_YN_AUTO
FUNCTION
FNC_GET_ANZE_OBEY_YN_NEW
FUNCTION
FNC_GET_CONTRACT_FAC_LIST_NAME
FUNCTION
FNC_GET_CONTRACT_ITEM_LIST_NAME_TEST
FUNCTION
FNC_GET_DSPL_LIST_NAME
FUNCTION
FNC_GET_DUP_CONT_LIST_NAME
FUNCTION
FNC_GET_MEAS_ITEM_DEF_COUNT
FUNCTION
FNC_GET_MEAS_ITEM_SUB_COUNT
FUNCTION
FNC_GET_MEAS_PLC_NAME2
FUNCTION
FNC_GET_MEAS_PLC_NAME_250303
FUNCTION
FNC_GET_NAME_LIST
FUNCTION
FNC_GET_REWARD_LIST_NAME
FUNCTION
MIG_MEAS_EQUIP_NO_LIST_NAME
PROCEDURE
MIG_SMPL_CTOR_LIST_NAME
PROCEDURE
MIG_UDRS_MEAS_CAR_DAILY_SUB
PROCEDURE
MIG_UDRS_MEAS_DATA_AIR_DET
PROCEDURE
UPDATE_ERR_ITEM
PROCEDURE