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