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)