gp-office
Tables (5)
Attendance (출퇴근)
- attendance_id (출퇴근 아이디) — Primary key — NOT NULL
- start_time (출근시각)
- end_time (퇴근시각)
- work_date (업무날짜)
- day_type (주중여부)
- fixed_start_time (고정출근시간)
- lateness (지각여부)
- user_id (사용자아이디) — Foreign key → User.user_id — NOT NULL
- note (비고)
Caps (캡스사용자)
- caps_id (캡스등록아이디) — Primary key — NOT NULL
- user_id (사용자아이디) — Foreign key → User.user_id — NOT NULL
Department (부서)
- department_id (Key) — Primary key — NOT NULL
- department_name (부서명)
- parent_id (상위부서)
User (사용자)
- user_id (Key) — Primary key — NOT NULL
- name (사용자명)
- email (이메일)
- password (비밀번호)
- position (직책)
User_Department (사원_부서)
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
- department_id (Key) — Foreign key → Department.department_id — NOT NULL