Sample
Tables (63)
BOT_ALARM_LOG
- SEQ — bigint — Primary key — NOT NULL
- ALM_TGT — int
- ALM_SEQ — varchar(150)
- ALM_TYPE — int
- ALM_ETC — varchar(255)
- REG_DT — datetime
- BOT_ID — bigint
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_ALARM_MEMBER
- SEQ — bigint — Primary key — NOT NULL
- ALM_TGT — int
- ALM_ID — varchar(150)
- EMP_NO — varchar(150)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_INTG_SCHEDULE_BOT_LIST
- SEQ — bigint — Primary key — NOT NULL
- SCH_ID — varchar(32) — NOT NULL
- BOT_ID — bigint — NOT NULL
- MOBILE_AGENTIP — varchar(50)
- MOBILE_DEVICEID — varchar(255)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_INTG_SCHEDULE_CMDLOG
- SEQ — bigint — Primary key — NOT NULL
- SCH_ID — varchar(32) — NOT NULL
- EVT_ID — int — NOT NULL
- EVT_DESC — ntext
- EVT_DT — char(8) — NOT NULL
- EVT_TM — char(9) — NOT NULL
- BOT_ID — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_INTG_SCHEDULE_EXCLUDE_DT
- SEQ — bigint — Primary key — NOT NULL
- SCH_ID — varchar(32) — NOT NULL
- EXCL_DT — char(8) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_INTG_SCHEDULE_EXCLUDE_TM
- SEQ — bigint — Primary key — NOT NULL
- SCH_ID — varchar(32) — NOT NULL
- EXCL_TM — char(8)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_INTG_SCHEDULE_LABEL
- LABEL_ID — bigint — Primary key — NOT NULL
- COMP_CD — varchar(150) — NOT NULL
- EMP_NO — varchar(150) — NOT NULL
- LABEL_NM — varchar(150) — NOT NULL
- COLOR_CD — varchar(10) — NOT NULL
- REG_DT — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_INTG_SCHEDULE_LABEL_INCL
- SEQ — bigint — Primary key — NOT NULL
- LABEL_ID — bigint — NOT NULL
- SCH_ID — varchar(32) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_INTG_SCHEDULE_LIST
- SCH_ID — varchar(32) — Primary key — NOT NULL
- COMP_CD — varchar(150) — NOT NULL
- SCH_NM — nvarchar(255) — NOT NULL
- BOX_ID — bigint — NOT NULL
- BOX_VER — bigint — NOT NULL
- SCH_MEMO — ntext
- REG_DT — datetime — NOT NULL
- OWNER — varchar(150) — NOT NULL
- START_DT — char(8) — NOT NULL
- START_TM — char(4) — NOT NULL
- END_DT — char(8) — NOT NULL
- END_TM — char(4) — NOT NULL
- RUN_COUNT — int — NOT NULL
- RUN_TYPE — int — NOT NULL
- RUN_EVR_TIME — int
- RECC_TYPE — int
- PERIODICITY — int
- WEEK_DAYS — int
- WEEK_OF_MONTH_TYPE — int
- DAY_NUMBERS — varchar(150)
- CUST_CODE — ntext
- CUST_REF_NET — ntext
- CUST_REF_COM — ntext
- CUST_REF_JAR — ntext
- EXCL_HOLIDAY — int
- EXCL_RUN_WEEK — char(7)
- EXCL_SCH_ID — varchar(32)
- EXCL_SCH_DATE — nchar(8)
- RUN_TM_LIMIT — int
- UNTIL_SUCCESS — int
- CHK_PREV_TASK — int
- LAST_RUN_DT — char(12)
- NEXT_RUN_DT — char(12)
- EXPIRED — int — NOT NULL
- USE_PAUSE — int — NOT NULL
- LOOP_END_DT — char(8)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_INTG_SCHEDULE_WEEKLY
- SEQ — bigint — Primary key — NOT NULL
- SCH_ID — varchar(32) — NOT NULL
- WEEK_NUMB — int — NOT NULL
- RUN_DOW — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_LIST
- BOT_ID — bigint — Primary key — NOT NULL
- COMP_CD — varchar(150) — NOT NULL
- BOT_NM — nvarchar(255) — NOT NULL
- BOT_IP — varchar(15) — NOT NULL
- BOT_PORT — int — NOT NULL
- BOT_MODE — int — NOT NULL
- STATUS — int — NOT NULL
- QUE_GRP — bigint — NOT NULL
- VM_ALIAS — nvarchar(255)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_QUEUE_GROUP
- QUE_GRP — bigint — Primary key — NOT NULL
- QUE_GRP_NM — nvarchar(255)
- COMP_CD — varchar(150) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_QUEUE_LABEL_INCL
- SEQ — bigint — Primary key — NOT NULL
- LABEL_ID — bigint — NOT NULL
- QUEUE_ID — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_QUEUE_LIST
- QUE_ID — bigint — Primary key — NOT NULL
- QUE_NM — nvarchar(255) — NOT NULL
- BOX_ID — bigint — NOT NULL
- BOX_VER — bigint — NOT NULL
- REG_DT — datetime — NOT NULL
- COMP_CD — varchar(150) — NOT NULL
- QUE_GRP — bigint — NOT NULL
- OWNER — varchar(150)
- DIRECT_BOT_ID — bigint
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_QUEUE_LOG
- SEQ — bigint — Primary key — NOT NULL
- BOT_ID — bigint — NOT NULL
- QUE_ID — bigint — NOT NULL
- STDT — char(8) — NOT NULL
- STTM — char(9)
- EDDT — char(8)
- EDTM — char(9)
- DURATION — int — NOT NULL
- SCRIPTFILEPATH — nvarchar(255) — NOT NULL
- LOGFILEPATH — nvarchar(255) — NOT NULL
- TERMINATEMODE — int — NOT NULL
- KILLCMDRECV — int — NOT NULL
- KILLCMDINFO — nvarchar(255)
- BOX_ID — int — NOT NULL
- BOX_VER — int — NOT NULL
- SERVERCOMMENT — ntext — text NUL
- MOBILE_AGENTIP — varchar(50)
- MOBILE_DEVICEID — varchar(255)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_QUEUE_MOBILE
- BOT_ID — bigint — Primary key — NOT NULL
- MOBILE_AGENTIP — varchar(50) — NOT NULL
- MOBILE_DEVICEID — varchar(255) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_QUEUE_RUN
- SEQ — bigint — Primary key — NOT NULL
- QUE_ID — bigint — NOT NULL
- BOT_ID — bigint
- EXEC_DT — datetime
- ODR_SEQ — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_SCHEDULE_BOT_LIST
- SEQ — bigint — Primary key — NOT NULL
- SCH_ID — bigint — NOT NULL
- BOT_ID — bigint — NOT NULL
- MOBILE_AGENTIP — varchar(50)
- MOBILE_DEVICEID — varchar(255)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_SCHEDULE_CLS2_WEEKLY
- SEQ — bigint — Primary key — NOT NULL
- SCH_ID — bigint — NOT NULL
- WEEK_NUMB — int — NOT NULL
- RUN_DOW — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_SCHEDULE_CMDLOG
- SEQ — bigint — Primary key — NOT NULL
- SCH_ID — bigint — NOT NULL
- EVT_ID — int — NOT NULL
- EVT_DESC — ntext
- EVT_DT — char(8) — NOT NULL
- EVT_TM — char(9) — NOT NULL
- BOT_ID — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_SCHEDULE_EXCLUDE_DT
- SEQ — bigint — Primary key — NOT NULL
- SCH_ID — bigint — NOT NULL
- EXCL_DT — char(8) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_SCHEDULE_EXCLUDE_TM
- SEQ — bigint — Primary key — NOT NULL
- SCH_ID — bigint — NOT NULL
- EXCL_TM — char(8)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_SCHEDULE_LIST
- SCH_ID — bigint — Primary key — NOT NULL
- COMP_CD — varchar(150) — NOT NULL
- SCH_NM — nvarchar(255) — NOT NULL
- BOX_ID — bigint — NOT NULL
- BOX_VER — bigint — NOT NULL
- SCH_MEMO — ntext
- REG_DT — datetime — NOT NULL
- OWNER — varchar(150)
- SCH_CLS — int — NOT NULL
- CLS0_TM — char(4)
- CLS1_TYPE — int
- CLS1_TM — int
- CLS1_LOOPEND_DT — char(8)
- CLS2_TYPE — int
- CLS2_DAY_TYPE — int
- CLS2_DAY_INTV — int
- CLS2_WEEK_INTV — int
- CLS2_WEEK_RUN — char(7)
- CLS2_MONTH_INTV — int
- CLS2_MONTH_TYPE — int
- CLS2_MONTH_CUSDAYS — varchar(83)
- CLS2_RUN_TM — char(4)
- CLS2_LOOPEND_DT — char(8)
- CLS3_CODE — ntext
- CLS3_REF_NET — ntext
- CLS3_REF_COM — ntext
- CLS3_REF_JAR — ntext
- CLS3_LOOPEND_DT — char(8)
- EXCL_HOLIDAY — int
- EXCL_RUN_WEEK — char(7)
- RUN_TM_LIMIT — int
- UNTIL_SUCCESS — int
- CHK_PREV_TASK — int
- LAST_RUN_DT — char(12)
- NEXT_RUN_DT — char(12)
- START_DT — char(8)
- EXPIRED — int — NOT NULL
- USE_PAUSE — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_SCHEDULE_LOG
- SEQ — bigint — Primary key — NOT NULL
- BOT_ID — bigint — NOT NULL
- UID — varchar(150) — NOT NULL
- SCH_NAME — nvarchar(255) — NOT NULL
- LABEL — varchar(150) — NOT NULL
- STDT — char(8) — NOT NULL
- STTM — char(9)
- EDDT — char(8)
- EDTM — char(9)
- DURATION — int — NOT NULL
- SCRIPTFILEPATH — nvarchar(255) — NOT NULL
- LOGFILEPATH — nvarchar(255) — NOT NULL
- TERMINATEMODE — int — NOT NULL
- KILLCMDRECV — int — NOT NULL
- KILLCMDINFO — nvarchar(255)
- BOX_ID — int — NOT NULL
- BOX_VER — int — NOT NULL
- SERVERCOMMENT — ntext — text NUL
- MOBILE_AGENTIP — varchar(50)
- MOBILE_DEVICEID — varchar(255)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_SCHEDULE_NOTEXECUTE_LIST
- SEQ — bigint — Primary key — NOT NULL
- SCH_TGT — int — NOT NULL
- SCH_ID — varchar(255) — NOT NULL
- BOT_ID — bigint — NOT NULL
- START_DT — datetime
- END_DT — datetime
- REG_DT — datetime
- SCH_INFO — text
- MOBILE_DEVICEID — varchar(255)
- MOBILE_AGENTIP — varchar(50)
- HDLR_DT — datetime
- HDLR_EMP_NO — varchar(150)
- STATUS — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_STATUS
- BOT_ID — bigint — Primary key — NOT NULL
- COMP_CD — varchar(150) — Primary key — NOT NULL
- STATUS — int — NOT NULL
- DETAIL_INFO — ntext
- MINI_VIEW — varbinary(max)
- UPDATE_DT — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_TASKERRORHANDLER
- ERR_ID — bigint — Primary key — NOT NULL
- ERR_DT — char(8) — NOT NULL
- ERR_TM — char(9) — NOT NULL
- TASK_TYPE — int — NOT NULL
- TASK_ID — bigint — NOT NULL
- HDLR_EMP_NO — varchar(150)
- HDLR_DT — char(8)
- HDLR_TM — char(9)
- HDLR_RESULT — int — NOT NULL
- AUTOCLOSE — int — NOT NULL
- PID — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOT_TRIGGER_LOG
- SEQ — bigint — Primary key — NOT NULL
- BOT_ID — bigint — NOT NULL
- TRG_ID — varchar(150) — NOT NULL
- TRG_NM — nvarchar(255) — NOT NULL
- TRG_TYPE — int — NOT NULL
- STDT — char(8) — NOT NULL
- STTM — char(9) — NOT NULL
- EDDT — char(8)
- EDTM — char(9)
- DURATION — int — NOT NULL
- SCRIPTFILEPATH — nvarchar(255) — NOT NULL
- LOGFILEPATH — nvarchar(255) — NOT NULL
- TERMINATEMODE — int — NOT NULL
- KILLCMDRECV — int — NOT NULL
- KILLCMDINFO — nvarchar(255)
- BOX_ID — int — NOT NULL
- BOX_VER — int — NOT NULL
- SERVERCOMMENT — ntext — text NUL
- MOBILE_AGENTIP — varchar(50)
- MOBILE_DEVICEID — varchar(255)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOX_ITEM
- ITEM_ID — bigint — Primary key — NOT NULL
- BOX_ID — bigint — NOT NULL
- ITEM_PATH — nvarchar(450) — NOT NULL
- ITEM_VERSION — int — NOT NULL
- ITEM_TYPE — int — NOT NULL
- ITEM_HASH — char(32) — NOT NULL
- REG_DT — datetime — NOT NULL
- ITEM_SIZE — bigint
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOX_LIST
- BOX_ID — bigint — Primary key — NOT NULL
- BOX_NM — nvarchar(255) — NOT NULL
- COMP_CD — varchar(150) — NOT NULL
- REG_EMP_NO — varchar(150) — NOT NULL
- REG_DT — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOX_LOCK
- SEQ — bigint — Primary key — NOT NULL
- BOX_ID — bigint — NOT NULL
- EMP_NO — varchar(150) — NOT NULL
- REG_DT — datetime — NOT NULL
- MEMO — ntext
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOX_LOCK_HISTORY
- SEQ — bigint — Primary key — NOT NULL
- BOX_ID — bigint — NOT NULL
- EMP_NO — varchar(150) — NOT NULL
- REG_DT — datetime — NOT NULL
- FIN_DT — datetime
- STATUS — int
- CANCEL_EMP_NO — varchar(150)
- MEMO — ntext
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOX_SHARE
- SEQ — bigint — Primary key — NOT NULL
- BOX_ID — bigint — NOT NULL
- SHARE_TYPE — int — NOT NULL
- SHARE_DATA — varchar(150) — NOT NULL
- PERMISSION — int — NOT NULL
- REG_DT — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOX_VERSION
- BOX_ID — bigint — Primary key — NOT NULL
- BOX_VER — bigint — Primary key — NOT NULL
- REG_EMP_NO — varchar(150) — NOT NULL
- REG_DT — datetime — NOT NULL
- MEMO — ntext
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
BOX_VERSION_DETAIL
- SEQ — bigint — Primary key — NOT NULL
- BOX_VER — bigint — NOT NULL
- BOX_ID — bigint — NOT NULL
- ITEM_ID — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_ADMIN
- COMP_CD — varchar(150) — Primary key — NOT NULL
- EMP_NO — varchar(150) — Primary key — NOT NULL
- ADMIN_LV — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_APPROVAL_BOX
- SEQ — bigint — Primary key — NOT NULL
- COMP_CD — varchar(150) — NOT NULL
- BOX_ID — bigint — NOT NULL
- BOX_VER — bigint — NOT NULL
- APRV_TYPE — int — NOT NULL
- APRV_STATUS — int — NOT NULL
- REQ_EMP_NO — varchar(150) — NOT NULL
- REQ_DT — datetime — NOT NULL
- RESP_EMP_NO — varchar(150)
- RESP_DT — datetime
- EXT_DATA — text
- MEMO — ntext
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_APPROVAL_RES
- SEQ — bigint — Primary key — NOT NULL
- COMP_CD — varchar(150) — NOT NULL
- RES_EDIT — int — NOT NULL
- RES_APRV_STATUS — int — NOT NULL
- REQ_EMP_NO — varchar(150) — NOT NULL
- REQ_DT — datetime — NOT NULL
- RESP_EMP_NO — varchar(150)
- RESP_DT — datetime
- MEMO — ntext
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_COMPANY
- COMP_CD — varchar(150) — Primary key — NOT NULL
- COMP_NM — nvarchar(255) — NOT NULL
- STATUS — int — NOT NULL
- ST_YMD — char(8) — NOT NULL
- ED_YMD — char(8) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_DATASET
- SEQ — bigint — Primary key — NOT NULL
- DATASET — ntext
- QUE_ID — bigint
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_DENYACCESS
- COMP_CD — varchar(150) — Primary key — NOT NULL
- EMP_NO — varchar(150) — Primary key — NOT NULL
- LOCAL_TRIGER — int — NOT NULL
- LOCAL_SCHEDULE — int — NOT NULL
- SCRIPT_EDIT — int — NOT NULL
- SCRIPT_DEPLOY — int — NOT NULL
- SHAREDBOX_DOWNLOAD — int — NOT NULL
- SHAREDBOX_UPLOAD — int — NOT NULL
- MOBILE_MIRRORING — int — NOT NULL
- DASHBOARD_MINIVIEW — int — NOT NULL
- DASHBOARD_DETAIL — int — NOT NULL
- SERVERTABLE_EDIT — int — NOT NULL
- SHAREDRESOURCE_EDIT — int — NOT NULL
- SCHEDULEGRID_HOLIDAY_EDIT — int — NOT NULL
- QUEUE_GROUP_EDIT — int — NOT NULL
- QUEUE_MOBILE_EDIT — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_DEPARTMENT
- COMP_CD — varchar(150) — Primary key — NOT NULL
- DPT_CD — varchar(150) — Primary key — NOT NULL
- DPT_NM — nvarchar(255) — NOT NULL
- UP_DPT_CD — varchar(150)
- DPT_ORD — int — NOT NULL
- STATUS — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_HOLIDAY
- COMP_CD — varchar(150) — Primary key — NOT NULL
- HOL_YMD — char(8) — Primary key — NOT NULL
- HOL_TYPE — int — NOT NULL
- HOL_NM — nvarchar(255)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_JIKJONG
- COMP_CD — varchar(150) — Primary key — NOT NULL
- JIK_CD — varchar(150) — Primary key — NOT NULL
- JIK_NM — nvarchar(255) — NOT NULL
- JIK_ORD — int — NOT NULL
- ST_YMD — char(8)
- ED_YMD — char(8)
- STATUS — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_LABELS_SCRIPT
- COMP_CD — varchar(150) — Primary key — NOT NULL
- LBL_ID — varchar(150) — Primary key — NOT NULL
- LBL_NM — nvarchar(150) — NOT NULL
- LBL_COLOR — char(9)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_LABELS_WORK
- COMP_CD — varchar(150) — Primary key — NOT NULL
- LBL_ID — varchar(150) — Primary key — NOT NULL
- LBL_NM — nvarchar(150) — NOT NULL
- LBL_COLOR — char(9)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_LICENSE
- COMP_CD — varchar(150) — Primary key — NOT NULL
- LICENSE — varchar(500) — Primary key — NOT NULL
- CLIENT_INFO — text
- MEMO — ntext
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_LOGINLOG
- SEQ — bigint — Primary key — NOT NULL
- EMP_NO — varchar(150)
- IP — varchar(15)
- LOGIN_DT — char(10)
- LOGIN_TM — char(10)
- LOGOUT_DT — char(10)
- LOGOUT_TM — char(10)
- LOGIN_TYPE — int
- STATUS — int
- COMP_CD — varchar(150)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_MEMBER
- COMP_CD — varchar(150) — Primary key — NOT NULL
- EMP_NO — varchar(150) — Primary key — NOT NULL
- EMP_NM — nvarchar(255) — NOT NULL
- TIT_CD — varchar(150)
- JIK_CD — varchar(150)
- DPT_CD — varchar(150)
- STATUS — int — NOT NULL
- EMP_EMAIL — varchar(255)
- EMP_PASS — varchar(128)
- PASS_FAIL — int
- PASS_DT — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_SERVERLICENSE
- COMP_CD — varchar(150) — Primary key — NOT NULL
- SERVER_LICENSE — varchar(150)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_SERVERMOBILE
- COMP_CD — varchar(150) — Primary key — NOT NULL
- DEVICEID — varchar(255) — Primary key — NOT NULL
- CLIENT_IP — char(15) — NOT NULL
- REG_DT — datetime — NOT NULL
- UPDATE_DT — datetime
- BOT_ID — bigint — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_SETTING
- COMP_CD — varchar(150) — Primary key — NOT NULL
- LOGIN_TYPE — int
- PASS_LEN10 — int
- PASS_UCASE — int
- PASS_LCASE — int
- PASS_NUMBER — int
- PASS_SPECIALCHAR — int
- PASS_LDAP — varchar(255)
- USE_ALARM — int
- SMTP_SERVER — varchar(50)
- SMTP_PORT — int
- SMTP_SSL — int
- SMTP_MAILID — varchar(150)
- SMTP_MAILPASS — varchar(255)
- USE_ALM_START — int
- USE_ALM_END — int
- USE_ALM_RUNNING — int
- USE_ALM_HOLDING — int
- USE_ALM_BOTCON — int
- USE_ALM_SYSTEM — int
- USE_ALM_END_FAIL — int
- PASS_EXPIRE — int — NOT NULL
- ID_LEN_ST — int — NOT NULL
- ID_LEN_ED — int — NOT NULL
- SMTP_FROM — varchar(150)
- SMTP_FROMDISPLAY — varchar(255)
- SMTP_SSLPROTOCOLS — int
- SCHEDULE_TYPE — int — NOT NULL
- USE_ALM_NOT_EXECUTE — int — NOT NULL
- USE_ALM_ERROR_HANDLER — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_SETTING_EX
- COMP_CD — varchar(150) — Primary key — NOT NULL
- SET_KEY — varchar(255) — Primary key — NOT NULL
- SET_VAL — varchar(500)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_SINGLEZONE
- COMP_CD — varchar(150) — Primary key — NOT NULL
- SINGLEZONE_NAME — nvarchar(150) — Primary key — NOT NULL
- UID — varchar(150) — Primary key — NOT NULL
- CHK_ALIVE — int
- CHK_RETRY — int
- REG_NUMB — int
- CHK_ALIVE64 — bigint
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CM_TITLE
- COMP_CD — varchar(150) — Primary key — NOT NULL
- TIT_CD — varchar(150) — Primary key — NOT NULL
- TIT_NM — nvarchar(255) — NOT NULL
- TIT_ORD — int — NOT NULL
- ST_YMD — char(8)
- ED_YMD — char(8)
- STATUS — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
INTRA_LICENSE
- SEQ — bigint — Primary key — NOT NULL
- COMP_CD — varchar(150) — NOT NULL
- INTRA_ID — varchar(150) — NOT NULL
- REQ_TERM — int — NOT NULL
- REG_DT — datetime — NOT NULL
- STATUS — int — NOT NULL
- LICENSE — text
- CLIENT_INFO — text
- INST_DT — datetime
- LICENSE_MODE — int — NOT NULL
- INTRA_SEQ — bigint
- INTRA_TYPE — int
- MEMO — ntext
- REQ_KEY — text
- MOBILE_ALLOW — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
SHARED_RESOURCE_ITEM
- COMP_CD — varchar(150) — Primary key — NOT NULL
- FILE_PATH — nvarchar(450) — Primary key — NOT NULL
- FILE_HASH — char(32) — NOT NULL
- REG_EMP_NO — varchar(150) — NOT NULL
- REG_DT — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TBL_INFO
- TBL_ID — bigint — Primary key — NOT NULL
- TBL_NM — varchar(255) — NOT NULL
- COMP_CD — varchar(150) — NOT NULL
- TBL_COMMENT — ntext — text NUL
- REG_EMP_NO — varchar(150)
- DATA_EMP_NO — varchar(150)
- REG_DT — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TBL_SCHEDULE_DATA
- UID — nvarchar(100)
- Label — nvarchar(100)
- Owner — nvarchar(100)
- End — datetime
- FlowTaskPath — nvarchar(max)
- UntilSuccessful — int
- Start — datetime
- UpdateDateTime — nvarchar(100)
- TimeoutTerminate — int
- RunCount — int
- Type — int
- UntilSuccessfulSpace — int
- TimeZoneId — nvarchar(100)
- Version — int
- Status — nvarchar(100)
- WaitPrevScriptEnd — int
- ResourceId — nvarchar(100)
- RunCountSpace — int
- Subject — nvarchar(100)
- TargetBox — nvarchar(max)
- BoxID — nvarchar(100)
- BoxVer — nvarchar(100)
TBL_SCHEDULE_XML
- XML_ID — int — Primary key — NOT NULL
- XmlContent — xml
- DEL_YN — char(1)
- CRT_DTTM — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TBL_SCHEDULE_XML_DATA
- XML_DATA_ID — int — Primary key — NOT NULL
- XML_ID — int — Foreign key → TBL_SCHEDULE_XML.XML_ID
- UID — nvarchar(100)
- Subject — nvarchar(100)
- TargetBox — nvarchar(max)
- BoxID — nvarchar(100)
- BoxVer — nvarchar(100)
- Start — datetime
- End — datetime
- UpdateDateTime — nvarchar(100)
- FlowTaskPath — nvarchar(max)
- WaitPrevScriptEnd — int
- TimeoutTerminate — int
- UntilSuccessful — int
- UntilSuccessfulSpace — int
- RunCountSpace — int
- RunCount — int
- Version — int
- Status — nvarchar(100)
- Type — int
- Label — nvarchar(100)
- Owner — nvarchar(100)
- TimeZoneId — nvarchar(100)
- ResourceId — nvarchar(100)
- DEL_YN — char(1)
- CRT_DTTM — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TBL_SHARE
- SEQ — bigint — Primary key — NOT NULL
- TBL_ID — bigint — NOT NULL
- SHARE_TYPE — int — NOT NULL
- SHARE_DATA — varchar(150) — NOT NULL
- PERMISSION — int — NOT NULL
- REG_DT — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
USER_USAGE_LOG
- SEQ — bigint — Primary key — NOT NULL
- COMP_CD — varchar(150) — NOT NULL
- EMP_NO — varchar(150)
- STDT — char(8) — NOT NULL
- STTM — char(9) — NOT NULL
- EDDT — char(8) — NOT NULL
- EDTM — char(9) — NOT NULL
- DURATION — int — NOT NULL
- TERMINATEMODE — int — NOT NULL
- KILLCMDRECV — int — NOT NULL
- USE_MOBILE — int — NOT NULL
- MULTISPACE — int — NOT NULL
- SCRIPTFILE — nvarchar(255)
- TASK_TYPE — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =