ai

Tables (14)

TB_ADMIN

  • admin_id — INT — Primary key — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • role_id — INT — Foreign key → TB_ROLE.role_id — NOT NULL

TB_ATTENDANCE

  • attendance_id — INT — Primary key — NOT NULL
  • work_date — DATE — NOT NULL
  • check_in_at — DATETIME
  • check_out_at — DATETIME
  • check_in_status — VARCHAR(20)
  • check_out_status — VARCHAR(20)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • employee_id — INT — Foreign key → TB_EMP.employee_id — NOT NULL

TB_ATTENDANCE_POLICY

  • policy_id — INT — Primary key — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME — NOT NULL
  • work_days — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • company_id — INT — Foreign key → TB_COMPANY.company_id — NOT NULL

TB_COMPANY

  • company_id — INT — Primary key — NOT NULL
  • business_number — VARCHAR(20) — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

TB_DEPARTMENT

  • department_id — INT — Primary key — NOT NULL
  • department_name — VARCHAR(30) — NOT NULL
  • department_code — VARCHAR(30) — NOT NULL
  • dept_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • company_id — INT — Foreign key → TB_COMPANY.company_id — NOT NULL

TB_EMP

  • employee_id — INT — Primary key — NOT NULL
  • employee_number — VARCHAR(30) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • hire_date — DATE — NOT NULL
  • employment_status — VARCHAR(20) — NOT NULL
  • account_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • role_id — INT — Foreign key → TB_ROLE.role_id — NOT NULL
  • company_id — INT — Foreign key → TB_COMPANY.company_id — NOT NULL
  • department_id — INT — Foreign key → TB_DEPARTMENT.department_id — NOT NULL
  • position_id — INT — Foreign key → TB_POSITION.position_id — NOT NULL

TB_LEAVE_APPROVAL_LINE

  • leave_approval_line_id — INT — Primary key — NOT NULL
  • approval_order — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • owner_employee_id — INT — Foreign key → TB_EMP.employee_id — NOT NULL
  • approver_employee_id — INT — Foreign key → TB_EMP.employee_id — NOT NULL

TB_LEAVE_BALANCE

  • leave_balance_id — INT — Primary key — NOT NULL
  • granted_days — DECIMAL(3, 1) — NOT NULL
  • used_days — DECIMAL(3, 1) — NOT NULL
  • year — INT — NOT NULL
  • employee_id — INT — Foreign key → TB_EMP.employee_id — NOT NULL

TB_LEAVE_REQUEST

  • leave_request_id — INT — Primary key — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • deduction_days — DECIMAL(3, 1) — NOT NULL
  • annual_leave_count_status — VARCHAR(20) — NOT NULL
  • reason — VARCHAR(500) — NOT NULL
  • leave_req_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • employee_id — INT — Foreign key → TB_EMP.employee_id — NOT NULL
  • leave_type_id — INT — Foreign key → TB_LEAVE_TYPE.leave_type_id — NOT NULL

TB_LEAVE_REQUEST_APPROVAL

  • leave_request_approval_id — INT — Primary key — NOT NULL
  • approver_employee_id — INT — Foreign key → TB_EMP.employee_id — NOT NULL
  • leave_request_id — INT — Foreign key → TB_LEAVE_REQUEST.leave_request_id — NOT NULL
  • approval_status — VARCHAR(20) — NOT NULL
  • approval_comment — VARCHAR(500)
  • approved_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • approval_order — INT — NOT NULL

TB_LEAVE_TYPE

  • leave_type_id — INT — Primary key — NOT NULL
  • leave_code — VARCHAR(30) — NOT NULL
  • leave_name — VARCHAR(50) — NOT NULL
  • leave_category — VARCHAR(20) — NOT NULL
  • deduction_days — DECIMAL(3, 1) — NOT NULL
  • annual_leave_policy — VARCHAR(20) — NOT NULL
  • leave_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • company_id — INT — Foreign key → TB_COMPANY.company_id — NOT NULL

TB_POSITION

  • position_id — INT — Primary key — NOT NULL
  • position_name — VARCHAR(30) — NOT NULL
  • position_code — VARCHAR(30) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • company_id — INT — Foreign key → TB_COMPANY.company_id — NOT NULL

TB_ROLE

  • role_id — INT — Primary key — NOT NULL
  • role_code — VARCHAR(30) — NOT NULL
  • role_name — VARCHAR(50) — NOT NULL

TB_SERVICE_LIST

  • service_list_id — INT — Primary key — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • business_number — VARCHAR(20) — NOT NULL
  • manager_name — VARCHAR(50) — NOT NULL
  • manager_email — VARCHAR(255) — NOT NULL
  • service_status — VARCHAR(20) — NOT NULL
  • reject_reason — VARCHAR(500)
  • processed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • company_id — INT — Foreign key → TB_COMPANY.company_id