HR_first_yet

Tables (10)

attendancerecord (Untitled6)

  • attendance_id (Key) — Primary key — NOT NULL
  • work_date (Field2)
  • check_in_at (Field3)
  • check_out_at (Field4)
  • attendance_status_id (Key2) — Foreign key → attendancestatuscode.attendance_status_id — NOT NULL
  • applied_work_time_policy_id (Field6)
  • employee_id (Key3) — Foreign key → employee.employee_id — NOT NULL
  • work_time_policy_id (Key4) — Foreign key → worktimepolicy.work_time_policy_id — NOT NULL

attendancestatuscode (Untitled4)

  • attendance_status_id (Key) — Primary key — NOT NULL
  • attendance_status_code (Field)
  • attendance_status_name (Field2)
  • is_active (Field3)

employee (Untitled10)

  • employee_id (Key) — Primary key — NOT NULL

overtimepolicy (Untitled3)

  • overtime_policy_id (Key) — Primary key — NOT NULL
  • overtime_start_time (Field2)
  • is_active (Field3)
  • work_time_policy_id (Key2) — Foreign key → worktimepolicy.work_time_policy_id — NOT NULL

overtimerecord (Untitled7)

  • overtime_id (Key) — Primary key — NOT NULL
  • work_date (Field2)
  • overtime_minutes (Field3)
  • status (Field4)
  • reviewed_by (Field5)
  • reviewed_at (Field6)
  • attendance_id (Field7)
  • employee_id (Key2) — Foreign key → employee.employee_id — NOT NULL

vacationbalance (Untitled9)

  • vacation_balance_id (Key) — Primary key — NOT NULL
  • employee_id (Field)
  • year (Field3)
  • granted_days (Field4)
  • used_days (Field5)
  • remaining_days (Field6)
  • vacation_type_id (Key2) — Foreign key → vacationtype.vacation_type_id — NOT NULL
  • employee_id (Key3) — Foreign key → employee.employee_id — NOT NULL

vacationrequest (Untitled8)

  • vacation_request_id (Key) — Primary key — NOT NULL
  • employee_id (Field)
  • start_date (Field3)
  • end_date (Field4)
  • days (Field5)
  • status (Field6)
  • reviewed_by (Field7)
  • reviewed_at (Field8)
  • cancelled_at (Field9)
  • vacation_type_id (Key2) — Foreign key → vacationtype.vacation_type_id — NOT NULL
  • employee_id (Key3) — Foreign key → employee.employee_id — NOT NULL

vacationtype (Untitled5)

  • vacation_type_id (Key) — Primary key — NOT NULL
  • vacation_type_code (Field)
  • vacation_type_name (Field2)
  • is_active (Field3)

worktimepolicy (Untitled2)

  • work_time_policy_id (Key) — Primary key — NOT NULL
  • start_time (Field2)
  • end_time (Field3)
  • effectice_from (Field4)
  • effective_to (Field5)
  • work_type_id (Key2) — Foreign key → worktype.work_type_id — NOT NULL

worktype (Untitled)

  • work_type_id (Key) — Primary key — NOT NULL
  • work_type_code (Field1)
  • work_type_name (Field2)
  • is_active (Field3)