교육관리
테이블 (6)
KNPS_THREduCourseReq_Confirm
- CompanySeq — int — 기본 키 — NOT NULL
- CfmSeq — int — 기본 키 — NOT NULL
- CfmSerl — int — 기본 키 — NOT NULL
- CfmSubSerl — int — 기본 키 — NOT NULL
- IsAuto — nchar(1) — NOT NULL
- CfmCode — int — NOT NULL
- CfmDate — nchar(8) — NOT NULL
- CfmEmpSeq — int — NOT NULL
- UMCfmReason — int — NOT NULL
- CfmReason — nvarchar(500) — NOT NULL
- LastDateTime — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
_THREduPersReq
- ReqSeq — int — 기본 키 — NOT NULL
- PlanSeq — int — 기본 키 — NOT NULL
- PlanSerl — int — 기본 키 — NOT NULL
- CompanySeq — int — 기본 키 — NOT NULL
- ReqNo — nvarchar(20)
- AppDate — nchar(8)
- EmpSeq — int
- EduClassSeq — int
- UMEduGrpType — int
- EduTypeSeq — int
- EduCourseSeq — int
- EtcCourseName — nvarchar(200)
- SMInOutType — int
- EduBegDate — nchar(8)
- EduEndDate — nchar(8)
- EduDd — int
- EduTm — decimal(19, 5)
- EduNeeds — nvarchar(1000)
- EduEffect — nvarchar(1000)
- SMEduPlanType — int
- LastUserSeq — int
- LastDateTime — datetime
- CfmEmpSeq — int
- FileNo — int
- UMInstitute — int
- UMlocation — int
- LecturerSeq — int
- EduPoint — decimal(19, 5)
- ProgFromSeq — int
- ProgFromSerl — int
- ProgFromSubSerl — int
- ProgFromTableSeq — int
- IsBatchReq — nchar(1)
- EtcInstitute — nvarchar(100)
- Etclocation — nvarchar(100)
- EtcLecturer — nvarchar(100)
- StartTime — nchar(4)
- EndTime — nchar(4)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
_THREduPersReqItem
- EduItemSeq — int — 기본 키 — NOT NULL
- CompanySeq (CompanySeq2) — int — 외래 키 → _THREduPersReq.CompanySeq — NOT NULL
- ReqSeq (ReqSeq2) — int — 외래 키 → _THREduPersReq.ReqSeq — NOT NULL
- PlanSeq — int — 외래 키 → _THREduPersReq.PlanSeq — NOT NULL
- PlanSerl — int — 외래 키 → _THREduPersReq.PlanSerl — NOT NULL
- CodeHelpConst — int
- CodeHelpParams — int
- ReqValueText — nvarchar(500)
- ReqValueSeq — int
- ReqRem — nvarchar(200)
- LastUserSeq — int
- LastDateTime — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
_THREduPersReqObj
- EmpSeq — int — NOT NULL
- LastUserSeq — int
- LastDateTime — datetime
- ReqSeq (ReqSeq2) — int — 외래 키 → _THREduPersReq.ReqSeq — NOT NULL
- PlanSeq — int — 외래 키 → _THREduPersReq.PlanSeq — NOT NULL
- CompanySeq (CompanySeq2) — int — 외래 키 → _THREduPersReq.CompanySeq — NOT NULL
_THREduPlan
- PlanSeq — int — 기본 키 — NOT NULL
- PlanSerl — int — 기본 키 — NOT NULL
- CompanySeq — int — 기본 키 — NOT NULL
- BegDate — nchar(8)
- EndDate — nchar(8)
- TotDd — int
- TotTm — numeric(19, 5)
- SMInOutType — int
- UMInstitute — int
- UMlocation — int
- IsInsur — nchar(1)
- AppDate — nchar(8)
- Remark — nvarchar(200)
- LastUserSeq — int
- LastDateTime — datetime
- EduPoint — decimal(19, 5)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
_THREduPlanCourse
- PlanSeq (PlanSeq2) — int — 외래 키 → _THREduPlan.PlanSeq — NOT NULL
- CompanySeq (CompanySeq2) — int — 외래 키 → _THREduPlan.CompanySeq — NOT NULL
- PlanNo — nvarchar(20)
- YY — nchar(4)
- PlanDate — nchar(8)
- EduCourseSeq — int
- UMEduGrpType — int
- Remark — nvarchar(500)
- IsEduClass — nchar(1)
- SMGrpSortSeq — int
- LastUserSeq — int
- LastDateTime — datetime
- IsBatch — nchar(1)
- EduTypeSeq — int
- EtcCourseName — nvarchar(200)
- IsBatchReq — nchar(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =