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)