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