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