hr

Tables (5)

Attend

  • Attend_No — VARCHAR(20) — Primary key — NOT NULL
  • status — VARCHAR(20)

CheckAttend

  • Check_Atd — VARCHAR(20) — Primary key — NOT NULL
  • Attend_No — VARCHAR(20) — Foreign key → Attend.Attend_No — NOT NULL
  • User_ID — VARCHAR(20) — Foreign key → User.User_ID — NOT NULL
  • 출근 (start) — VARCHAR(20)
  • Field (end) — VARCHAR(20)

CheckDept

  • Dept_User_ID — VARCHAR(20) — Primary key — NOT NULL
  • User_ID2 — VARCHAR(20) — Foreign key → User.User_ID — NOT NULL
  • Dept_ID — VARCHAR(20) — Foreign key → Dept.Dept_ID — NOT NULL

Dept

  • Dept_ID — VARCHAR(20) — Primary key — NOT NULL
  • dept — VARCHAR(20)

User

  • User_ID — VARCHAR(20) — Primary key — NOT NULL
  • user — VARCHAR(20)
  • rank — VARCHAR(20)