ERD
Tables (24)
IMG_BOOKMARK_T
- MARK_IRN — varchar(30) — Primary key — NOT NULL
- DEVICE — varchar(10)
- SDOC_NO — varchar(30) — NOT NULL
- SLIP_IRN — varchar(30) — NOT NULL
- MARK_TYPE — char(1) — NOT NULL
- MARK_STYLE — varchar(10) — NOT NULL
- MARK_RECT — varchar(30) — NOT NULL
- MARK_LineWidth — varchar(2) — NOT NULL
- MARK_LineColor — varchar(11) — NOT NULL
- MARK_BackColor — varchar(11) — NOT NULL
- MARK_Alpha — varchar(4)
- MARK_Comment — nvarchar(200) — varchar(200) NUL
- MARK_TextColor — varchar(11)
- MARK_FontName — nvarchar(10)
- MARK_FontSize — varchar(3)
- MARK_BackGround — char(1)
- MARK_Italic — char(1)
- MARK_Bold — char(1)
- ENABLE — char(1) — NOT NULL
- CORP_NO — varchar(20)
- REG_USER — varchar(20)
- REG_TIME — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- SDOC_NO (SDOC_NO2) — varchar(50) — Foreign key → IMG_SLIPDOC_T.SDOC_NO — NOT NULL
IMG_COMMENT_T
- COMT_IRN — varchar(30) — Primary key — NOT NULL
- JDOC_NO — varchar(80) — NOT NULL
- CORP_NO — varchar(20) — NOT NULL
- PART_NO — varchar(20) — NOT NULL
- REG_USER — varchar(15) — NOT NULL
- COMT_TITLE — nvarchar(80) — NOT NULL
- COMT_DATA — nvarchar(4000)
- COMT_STEP — char(1) — NOT NULL
- REG_TIME — datetime — NOT NULL
- UPDATE_TIME — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- SDOC_NO — varchar(50) — Foreign key → IMG_SLIPDOC_T.SDOC_NO — NOT NULL
IMG_COMPANY_T
- CORP_NO — varchar(30) — Primary key — NOT NULL
- CORP_NM_KO — nvarchar(50)
- CORP_NM_EN — nvarchar(50)
- CORP_NM_JP — nvarchar(50)
- DATE_START — varchar(8)
- DATE_END — varchar(8)
- REG_TIME — varchar(14)
- ENABLE — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
IMG_ENV_T
- ENV_NM — varchar(30) — NOT NULL
- ENV_VALUE — varchar(30) — NOT NULL
IMG_HISTORYCODE_T
- IDX — int — Primary key — NOT NULL
- HISTORY_CODE — varchar(10) — Primary key — NOT NULL
- HISTORY_CONTENT_KO — varchar(100)
- HISTORY_TYPE — varchar(50)
- HISTORY_CONTENT_EN — varchar(100)
- ICON — char(1) — 1: 등록 2: 수정 9: 삭제
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- HISTORY_IRN — bigint — Foreign key → IMG_HISTORY_T.HISTORY_IRN — NOT NULL
IMG_HISTORY_T
- HISTORY_IRN — bigint — Primary key — NOT NULL
- SDOC_NO — varchar(30) — NOT NULL
- JDOC_NO — varchar(30)
- SLIP_IRN — varchar(30)
- HISTORY_CD — char(3) — NOT NULL
- CORP_NO — varchar(20) — NOT NULL
- REG_USER — varchar(20) — NOT NULL
- REG_TIME — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- SDOC_NO (SDOC_NO2) — varchar(50) — Foreign key → IMG_SLIPDOC_T.SDOC_NO — NOT NULL
IMG_JDOC_T
- CORP_NO — varchar(30)
- PART_NO — varchar(20)
- REG_USER — varchar(50)
- JDOC_NAME — nvarchar(200)
- REG_TIME — datetime
- JDOC_NO — varchar(80)
- CABINET — datetime
- JDOC_STEP — char(1)
- UPD_TIME — datetime
- SDOC_NO — varchar(50) — Foreign key → IMG_SLIPDOC_T.SDOC_NO — NOT NULL
IMG_ORGFILE_T
- ORG_IRN — varchar(24) — Primary key — NOT NULL
- SDOC_NO — varchar(50) — Primary key — NOT NULL
- CABINET — datetime
- FOLDER — varchar(16)
- DOC_IRN — varchar(24)
- ORG_FILE — nvarchar(512)
- ORG_URL — char(1)
- FILE_SIZE — varchar(10)
- REG_TIME — datetime
- ORG_FLAG — char(2) — 10 : 이미지의 원본, 00: 변환서버로 변환 전
- FILE_HASH — varchar(150)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- SDOC_NO (SDOC_NO2) — varchar(50) — Foreign key → IMG_SLIPDOC_T.SDOC_NO — NOT NULL
IMG_PART_T
- PART_NO — varchar(20) — Primary key — NOT NULL
- IN_PART_NO — varchar(20)
- TOP_PART_NO — varchar(20)
- CORP_NO — varchar(30)
- PART_NM_KO — nvarchar(50)
- PART_NM_EN — nvarchar(50)
- PART_NM_JP — nvarchar(50)
- DATE_START — char(8)
- DATE_END — char(8)
- REG_TIME — char(14)
- ENABLE — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
IMG_PTISVR_RESULT_T
- IDX — varchar(30) — Primary key — NOT NULL
- PTI_KEY — varchar(70) — Primary key — NOT NULL
- PTI_TYPE — char(2) — 01 : 세금계산서, 02 : 법인카드
- PTI_STATUS — char(2)
- REG_TIME — datetime
- PTI_MSG — nvarchar(max)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
IMG_SEARCH_R
- IDX — varchar(30) — Primary key — NOT NULL
- SDOC_NO — varchar(30) — Primary key — NOT NULL
- CONTENTS — nvarchar(max)
- REG_TIME — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
IMG_SEARCH_T
- SDOC_NO — varchar(30) — Primary key — NOT NULL
- SE_FLAG — varchar(2)
- FILE_FLAG — varchar(10)
- REG_TIME — datetime
- UPDATE_TIME — datetime
- MSG — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- SDOC_NO (SDOC_NO2) — varchar(50) — Foreign key → IMG_SLIPDOC_T.SDOC_NO — NOT NULL
IMG_SLIPDOC_T
- SDOC_NO — varchar(50) — Primary key — NOT NULL
- CABINET — datetime
- FOLDER — varchar(16)
- CORP_NO — varchar(30)
- PART_NO — varchar(20)
- REG_USER — varchar(50)
- SDOC_MONTH — varchar(6)
- SDOC_KIND — varchar(6)
- SDOC_STEP — varchar(1)
- SDOC_FLAG — varchar(2)
- SDOC_URL — char(1)
- SDOC_AFTER — char(1)
- SDOC_FOLLOW — char(1)
- SDOC_PTI — char(2) — 서버 PTI의 진행 사항 표시
- SDOC_COPY — char(1)
- SDOC_COPYNM — nvarchar(10)
- SDOC_SECU — char(1)
- SDOC_SYSTEM — char(1)
- SDOC_NAME — nvarchar(100)
- SDOC_DEVICE — varchar(10)
- INFO_ETC — nvarchar(50)
- SLIP_CNT — int
- REG_TIME — datetime
- UPDATE_TIME — datetime
- JDOC_TOP — nvarchar(max)
- JDOC_NO — varchar(80)
- JDOC_GROUP — varchar(30)
- JDOC_INDEX — varchar(3)
- WORK_GROUP — varchar(10)
- ORG_USER — varchar(20) — 증빙 전달시 전달한 원본 사용자 사번
- APPR_CARD — varchar(8)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- SLIP_IRN — varchar(30) — Foreign key → IMG_SLIP_T.SLIP_IRN — NOT NULL
IMG_SLIPKIND_T
- KIND_NO — varchar(6) — Primary key — NOT NULL
- KIND_NM_KO — nvarchar(50)
- KIND_NM_EN — nvarchar(50)
- KIND_NM_JP — nvarchar(50)
- KIND_FLAG — char(1) — 필수 증빙 여부
- KIND_HIDDEN — char(1)
- CORP_NO — varchar(10)
- REG_TIME — datetime
- KIND_TOP — varchar(6)
- KIND_LEVEL — char(1)
- KIND_COLOR — varchar(11)
- ENABLE — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- SDOC_NO — varchar(50) — Foreign key → IMG_SLIPDOC_T.SDOC_NO — NOT NULL
IMG_SLIP_T
- SLIP_IRN — varchar(30) — Primary key — NOT NULL
- CABINET — datetime
- FOLDER — varchar(16)
- DOC_IRN — varchar(30)
- SDOC_NO — varchar(50)
- SLIP_NO — varchar(50)
- REG_TIME — datetime
- FILE_SIZE — varchar(10)
- SLIP_TITLE — nvarchar(50)
- SLIP_STEP — char(1)
- SLIP_FLAG — char(1)
- SLIP_RECT — varchar(40)
- SLIP_ROTATE — varchar(3)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
IMG_USERAUTH_T
- USER_ID — varchar(20) — NOT NULL
- CORP_NO — varchar(10)
- IsAcct — char(1)
- AUTH — char(1)
- USER_OPTION — varchar(200)
- USER_ID (USER_ID2) — varchar(50) — Foreign key → IMG_USER_T.USER_ID — NOT NULL
IMG_USER_T
- USER_ID — varchar(50) — Primary key — NOT NULL
- USER_PW — varchar(200)
- USER_NM_KO — nvarchar(50)
- USER_NM_EN — nvarchar(50)
- USER_NM_JP — nvarchar(50)
- CORP_NO — varchar(30) — Foreign key → IMG_COMPANY_T.CORP_NO
- PART_NO — varchar(20) — Foreign key → IMG_PART_T.PART_NO
- POS_CD — varchar(20)
- POS_NM — nvarchar(50)
- ENABLE — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
wdmArchives
- IDX — int — Primary key — NOT NULL
- ARCHIVE_NAME — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
wdmConfig
- CLASS — varchar(20) — Primary key — NOT NULL
- NAME — varchar(20) — Primary key — NOT NULL
- VALUE — varchar(256)
- TYPE — varchar(20)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
wdmDOCS
- IDX — int — Primary key — NOT NULL
- DOC_NAME — varchar(50) — Primary key — NOT NULL
- ARCHIVE_IDX — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
wdmFolders
- VOLUME_IDX — int — Primary key — NOT NULL
- FOLDER_NO — int — Primary key — NOT NULL
- FILES_CO — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
wdmSizes
- VOLUME_IDX — int — Primary key — NOT NULL
- SIZES — bigint
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
wdmTasks
- IDX — int — Primary key — NOT NULL
- TASK_NAME — varchar(50)
- JOB_TYPE — varchar(50)
- STATUS — char(1)
- JOB_MIN — int
- JOB_HOUR — int
- JOB_DAY — int
- JOB_WEEK — int
- JOB_MONTH — int
- LAST_JOB_TIME — bigint
- LAST_JOB_STATUS — varchar(50) — NOT NULL
- NEXT_JOB_TIME — bigint — NOT NULL
- MEMO — varchar(255)
- TARGET_EDM — varchar(50)
- TARGET_TABLE — varchar(50)
- TARGET_FIELD — varchar(50)
- TARGET_FIELD_TYPE — varchar(50)
- TARGET_SQL — varchar(2000)
- TARGET_CMD — varchar(256)
- TARGET_CMD_ARCH — varchar(50)
- TARGET_PROC_LIMIT_CNT — int
- ETC — varchar(256)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
wdmVolumes
- IDX — int — Primary key — NOT NULL
- VOLUME_NAME — varchar(50) — Primary key — NOT NULL
- LOCATION — varchar(256)
- MAX_SPACES — bigint
- MAX_FOLDERS — int
- MAX_FILES — int
- STATUS — varchar(20)
- ARCHIVE_IDX — int
- EX_STORAGE_YN — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =