HRS_VCATN
Tables (5)
HNF_ACNT (인력 계정)
- Key (ACNT_NO) — int (Auto Increment) — Primary key — NOT NULL
- Field (HNF_NO) — int
- Field (ACNT_ID) — varchar(50)
- Field (MHRLS_ID) — varchar(100)
- Field (MHRLS_TYPE) — varchar(50)
- Field (DELETE_YN) — char = 'N'
- Field (REGISTER) — int
- Field (REGIST_DT) — timestamp
- Field (UPDUSR) — int
- Field (UPDT_DT) — timestamp
HNF_DCLZ_MANAGE (인력 근태 관리)
- Key (DCLZ_MANAGE_NO) — int(Auto Increment) — Primary key — NOT NULL
- Field (HNF_NO) — int
- Field (ACNT_NO) — int
- Field (LAT) — double
- Field (LNG) — double
- Field (ATTEND_ADRES) — varchar(255)
- Field (ATTEND_YN) — char='N'
- Field (ATTEND_DT) — date
- Field (ATTEND_TIME) — time
- Field (CN) — varchar(4000)
- Field (DELETE_YN) — char = 'N'
- Field (REGISTER) — int
- Field (REGIST_DT) — timestamp
- Field (UPDUSR) — int
- Field (UPDT_DT) — timestamp
VCATN_DTLS (휴가 내역)
- Key (VCATN_DTLS_NO) — int — Primary key — NOT NULL
- Field (HNF_NO) — int
- Field (DEPT_NO) — int
- Field (VCATN_TY) — varchar(2)
- Field (VCATN_SE) — varchar(2)
- Field (BGN_DE) — date
- Field (END_DE) — date
- Field (BGN_TIME) — time
- Field (END_TIME) — time
- Field (VCATN_TIME) — varchar(2)
- Field (VCATN_CONFM) — char='N'
- Field (CN) — varchar(4000)
- Field (DELETE_YN) — char = 'N'
- Field (REGISTER) — int
- Field (REGIST_DT) — timestamp
- Field (UPDUSR) — int
- Field (UPDT_DT) — timestamp
VCATN_MANAGE (휴가 관리)
- Key (VCATN_MANAGE_NO) — int(Auto Increment) — Primary key — NOT NULL
- Field (PRJCT_NO) — int
- Field (VCATN_TY) — varchar(2)
- Field (VCATN_SE) — varchar(2)
- Field (DAYCNT) — int
- Field (PRESENTN_PAPERS) — varchar(100)
- Field (CN) — varchar(4000)
- Field (DELETE_YN) — char = 'N'
- Field (REGISTER) — int
- Field (REGIST_DT) — timestamp
- Field (UPDUSR) — int
- Field (UPDT_DT) — timestamp
WORK_DTLS (근무 내역)
- Key (WORK_DTLS_NO) — int — Primary key — NOT NULL
- Field (HNF_NO) — int
- Field (DEPT_NO) — int
- Field (WOKR_TY) — varchar(2)
- Field (LAT) — double
- Field (LNG) — double
- Field (BGN_DE) — date
- Field (END_DE) — date
- Field (BGN_TIME) — time
- Field (END_TIME) — time
- Field (WORK_HOUR) — int(11)
- Field (WORK_CONFM) — char='N'
- Field (CN) — varchar(4000)
- Field (DELETE_YN) — char = 'N'
- Field (REGISTER) — int
- Field (REGIST_DT) — timestamp
- Field (UPDUSR) — int
- Field (UPDT_DT) — timestamp