test
Tables (3)
Z_MAJOR_CODE
- MAJOR_CODE — NVARCHAR(50)
- CODE_NAME — NVARCHAR(500)
- CODE_DIV — NVARCHAR(20)
- REMARK1 — NVARCHAR(200)
- REMARK2 — NVARCHAR(200)
- REMARK3 — NVARCHAR(200)
- USE_YN — NVARCHAR(1)
- INSRT_USER_ID — NVARCHAR(20)
- INSRT_DT — DATETIME
- UPDT_USER_ID — NVARCHAR(20)
- UPST_DT — DATETIME
Z_MINOR_CODE
- MAJOR_CODE — NVARCHAR(50)
- CODE — NVARCHAR(50)
- CODE_NAME — NVARCHAR(500)
- REMARK1 — NVARCHAR(2000)
- REMARK2 — NVARCHAR(2000)
- REMARK3 — NVARCHAR(2000)
- REMARK4 — NVARCHAR(2000)
- REMARK5 — NVARCHAR(2000)
- SORT — NVARCHAR(10)
- USE_YN — NVARCHAR(1)
- INSRT_USER_ID — NVARCHAR(50)
- INSRT_DT — DATETIME
- UPDT_USER_ID — NVARCHAR(50)
- UPDT_DT — DATETIME
Z_USER_MAST
- USR_ID — NVARCHAR(13)
- USR_NM — NVARCHAR(60) — NOT NULL
- USR_VALID_DT — DATETIME — NOT NULL
- PWD — NVARCHAR(64)
- PWD_VALID_DT — DATETIME
- RETRY_CNT — INT
- CO_CD — NVARCHAR(10)
- DEPT_CD — NVARCHAR(20)
- ROLL_CD — NVARCHAR(20)
- BP_CD — NVARCHAR(20)
- PO_BP_CD — NVARCHAR(20)
- USR_DIV — NVARCHAR(20)
- USE_YN — NCHAR(1) — NOT NULL
- USR_GP — NVARCHAR(20)
- EMAIL — NVARCHAR(50)
- INSRT_USER_ID — NVARCHAR(13) — NOT NULL
- INSRT_DT — DATETIME — NOT NULL
- UPDT_USER_ID — NVARCHAR(13) — NOT NULL
- UPDT_DT — DATETIME — NOT NULL
- ERP_USR_ID — NVARCHAR(13)