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 — =