auth
테이블 (7)
API 사용자 (TB_USERS_API)
- 사용자ID (USER_ID) — NVARCHAR — 외래 키 → 사용자.사용자ID — NOT NULL
- USER_NAME — nvarchar(50) — NOT NULL
- PWD — nvarchar(255) — NOT NULL
- DESC_01 — nvarchar(100)
- DESC_02 — nvarchar(100)
- DESC_03 — nvarchar(100)
- AMT_01 — bigint
- AMT_02 — bigint
- AMT_03 — bigint
- REMARK — nvarchar(1000)
- FIRST_REG_DT — datetime
- FIRST_REG_USER — nvarchar(20)
- FIRST_REG_IP — nvarchar(10)
- LAST_REG_DT — datetime
- LAST_REG_USER — nvarchar(20)
- LAST_REG_IP — nvarchar(10)
DT_API_EMP_STAGING
- SEQ_NO — INT — 기본 키 — NOT NULL
- APPLY_DT — nvarchar(10) — 기본 키 — NOT NULL
- PERSONIDEXTERNAL — nvarchar(20) — NOT NULL
- USERID — nvarchar(20) — NOT NULL
- customString21 — nvarchar(50)
- customString22 — nvarchar(50)
- enc_customString22 — nvarchar(50)
- TRANS_YN — nvarchar(1)
- TRANS_RESULT — nvarchar(1000)
- OLD_ENC_ACCOUNT — nvarchar(50)
- DESC_01 — nvarchar(100)
- DESC_02 — nvarchar(100)
- DESC_03 — nvarchar(100)
- AMT_01 — bigint
- AMT_02 — bigint
- AMT_03 — bigint
- REMARK — nvarchar(1000)
- FIRST_REG_DT — datetime
- FIRST_REG_USER — nvarchar(20)
- FIRST_REG_IP — nvarchar(10)
- LAST_REG_DT — datetime
- LAST_REG_USER — nvarchar(20)
- LAST_REG_IP — nvarchar(10)
DT_COMN_CODE
- TYPE_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
- CLASS_CODE — VARCHAR2(20) — 기본 키 — NOT NULL
- COMN_CODE — VARCHAR2(20) — 기본 키 — NOT NULL
- COMN_NAME — VARCHAR2(100) — NOT NULL
- COMN_ENG_NAME — VARCHAR2(100)
- USE_YN — VARCHAR2(1) — NOT NULL
- DESC_01 — VARCHAR2(100)
- DESC_02 — VARCHAR2(100)
- DESC_03 — VARCHAR2(100)
- DESC_04 — VARCHAR2(100)
- DESC_05 — VARCHAR2(100)
- AMT_01 — INT
- AMT_02 — INT
- AMT_03 — INT
- AMT_04 — INT
- AMT_05 — INT
- REMARK — VARCHAR2(100)
- FIRST_REG_DT — DATE — NOT NULL
- FIRST_REG_IP — VARCHAR2(20) — NOT NULL
- FIRST_REG_ID — VARCHAR2(20) — NOT NULL
- LAST_UPD_DT — DATE — NOT NULL
- LAST_UPD_IP — VARCHAR2(20) — NOT NULL
- LAST_UPD_ID — VARCHAR2(20) — NOT NULL
DT_VR_IMPORT
- YYYYMM — VARCHAR2(8) — 기본 키 — NOT NULL
- EXEC_DATA_TYPE — VARCHAR2(10) — 기본 키 — NOT NULL
- EMP_NO — VARCHAR2(10) — 기본 키 — NOT NULL
- WORK_DATE — VARCHAR2(10) — 기본 키 — NOT NULL
- PAY_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
- COST_CODE — VARCHAR2(10)
- EXEC_SEQ — INT — NOT NULL
- WORK_HOUR — INT
- DEPT_NAME — VARCHAR2(100)
- TRAN_STATUS — INT — NOT NULL
- REMARK — VARCHAR2(100)
- FIRST_REG_DT — DATE — NOT NULL
- FIRST_REG_ID — VARCHAR2(20) — NOT NULL
- FIRST_REG_IP — VARCHAR2(20) — NOT NULL
- LAST_UPD_DT — DATE — NOT NULL
- LAST_UPD_ID — VARCHAR2(20) — NOT NULL
- LAST_UPD_IP — VARCHAR2(20) — NOT NULL
- EXEC_SEQ) — /
DT_VR_IMPORT_LOG
- EXEC_SEQ — INT — 기본 키 — NOT NULL
- YYYYMM — VARCHAR2(8) — 기본 키 — NOT NULL
- EXEC_DATA_TYPE — VARCHAR2(10) — 기본 키 — NOT NULL
- EMP_NO — VARCHAR2(10) — 기본 키 — NOT NULL
- WORK_DATE — VARCHAR2(10) — 기본 키 — NOT NULL
- PAY_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
- COMN_CODE — VARCHAR2(20) — 기본 키 — NOT NULL
- EXEC_DATE — VARCHAR2(10) — NOT NULL
- EXEC_TIME — VARCHAR2(10) — NOT NULL
- EXEC_ID — VARCHAR2(10) — NOT NULL
- EXEC_CLOSE_DATE — VARCHAR2(50)
- EXEC_STATUS — INT — NOT NULL
- TRANS_PATH — VARCHAR2(100)
- TRANS_LOG — VARCHAR2(500)
- REMARK — VARCHAR2(100)
- EXEC_RUN_CMD — VARCHAR2(4000)
- EXEC_VRC — VARCHAR2(100)
- EXEC_TEMP — VARCHAR2(100)
- EXEC_START_DATE — VARCHAR2(10)
- EXEC_END_DATE — VARCHAR2(10)
- EXEC_EMP_ID — VARCHAR2(500)
- EXEC_DEPT_ID — VARCHAR2(250)
- EXEC_VR_ID — VARCHAR2(20)
- EXEC_EXPORT_ID — VARCHAR2(500)
- EXPORT_FILE_NM — VARCHAR2(50)
- FIRST_REG_DT — DATE — NOT NULL
- FIRST_REG_ID — VARCHAR2(20) — NOT NULL
- FIRST_REG_IP — VARCHAR2(20) — NOT NULL
- LAST_UPD_DT — DATE — NOT NULL
- LAST_UPD_ID — VARCHAR2(20) — NOT NULL
- LAST_UPD_IP — VARCHAR2(20) — NOT NULL
- COST_CODE — VARCHAR2(10)
- EXEC_SEQ — INT — NOT NULL
- WORK_HOUR — INT
- DEPT_NAME — VARCHAR2(100)
- TRAN_STATUS — INT — NOT NULL
- REMARK — VARCHAR2(100)
- FIRST_REG_DT — DATE — NOT NULL
- FIRST_REG_ID — VARCHAR2(20) — NOT NULL
- FIRST_REG_IP — VARCHAR2(20) — NOT NULL
- LAST_UPD_DT — DATE — NOT NULL
- LAST_UPD_ID — VARCHAR2(20) — NOT NULL
- LAST_UPD_IP — VARCHAR2(20) — NOT NULL
- EXEC_SEQ) — / — NOT NULL
- PAY_CODE_NAME — VARCHAR2(100)
- EXPORTABLE — INT
- UNPAID_YN — INT
- ALLOWANCE — INT
- UNIT_CODE — VARCHAR2(10)
- ACTUAL_HOUR — INT
- DESC_01 — VARCHAR2(100)
- DESC_02 — VARCHAR2(100)
- AMT_01 — INT
- AMT_02 — INT
- USE_YN — VARCHAR2(1)
- FIRST_REG_DT — DATE — NOT NULL
- FIRST_REG_ID — VARCHAR2(20) — NOT NULL
- FIRST_REG_IP — VARCHAR2(20) — NOT NULL
- LAST_UPD_DT — DATE — NOT NULL
- LAST_UPD_ID — VARCHAR2(20) — NOT NULL
- … +21
DT_VR_PAYCODE
- PAY_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
- PAY_CODE_NAME — VARCHAR2(100)
- EXPORTABLE — INT
- UNPAID_YN — INT
- ALLOWANCE — INT
- UNIT_CODE — VARCHAR2(10)
- ACTUAL_HOUR — INT
- DESC_01 — VARCHAR2(100)
- DESC_02 — VARCHAR2(100)
- AMT_01 — INT
- AMT_02 — INT
- USE_YN — VARCHAR2(1)
- FIRST_REG_DT — DATE — NOT NULL
- FIRST_REG_ID — VARCHAR2(20) — NOT NULL
- FIRST_REG_IP — VARCHAR2(20) — NOT NULL
- LAST_UPD_DT — DATE — NOT NULL
- LAST_UPD_ID — VARCHAR2(20) — NOT NULL
- LAST_UPD_IP — VARCHAR2(20) — NOT NULL
사용자 (TB_USERS)
- 사용자ID (USER_ID) — VARCHAR(10) — 기본 키 — NOT NULL
- 사용자명 (USER_NAME) — VARCHAR(50)
- 이메일 (EMAIL) — VARCHAR(50) — NOT NULL