最近使用
`reliya_erp_dev`.`approval_workflows`
`reliya_erp_dev`.`expense_item_receipts`
`reliya_cms`.`pages`
`reliya_erp`.`approval_rules`
`information_schema`.`ROUTINES`
`reliya_erp_dev`.`approval_rules`
`mysql_bad_20260618`.`time_zone`
`mysql_bad_20260618`.`user`
`information_schema`.`KEY_CACHES`
`mysql_old`.`proxies_priv`
最愛
沒有「最愛」資料表。
新增
information_schema
mysql
mysql
mysql_bad_20260618
mysql_old
performance_schema
phpmyadmin
reliya
reliya_cms
erp
reliya_erp
reliya_erp_dev
reliya_erp_v2
test
導覽面板
導覽樹
伺服器
資料庫
資料表
導覽面板
自訂導覽面版外觀。
導覽面板
以樹狀顯示資料庫導覽面版
於導覽面版,將資料庫樹狀選單改為下拉式選單
連結主面板
在主面板凸顯目前的資料庫或資料表。
顯示標誌
在導覽面板顯示標誌。
標誌連結網址
導覽面板標誌所連結的網址。
標誌連結目標
以主視窗 (
main
) 還是新視窗 (
new
) 開啟目標連結。
main
new
開啟加強標示
當滑鼠指標移至伺服器上時,將之凸顯。
導覽樹第一層項目數量上限
導覽樹每一頁可以顯示的第一層項目數量。
設定顯示篩選框的項目數量下限
設定篩選框要顯示的項目最小數量 (資料表、檢視表、預存程序和事件) 。
最近使用的資料表
最多顯示幾個最近使用的資料表;0 代表不顯示。
最愛資料表
顯示最愛資料表的數量上限;設為 0 則關閉此功能。
導覽面板寬度
設為 0 則摺疊導覽面板。
導覽樹
自訂導覽樹。
導覽樹
導覽樹分支的項目數量上限
導覽樹每一頁可以顯示的項目數量。
將導覽樹的項目分組
將導覽樹內的項目分組 (依上方「資料庫與資料表」分頁定義的分隔符號來分組)。
開啟導覽樹展開功能
於導覽面版,是否提供樹狀選單的展開功能。
在導覽樹顯示資料表
在導覽樹,是否於資料庫底下顯示資料表
在導覽樹顯示檢視表
在導覽樹,是否於資料庫底下顯示檢視表
在導覽樹顯示函式
在導覽樹,是否於資料庫底下顯示函式
在導覽樹顯示預存程序
在導覽樹,是否於資料庫底下顯示預存程序
在導覽樹顯示事件
在導覽樹,是否於資料庫底下顯示事件
展開單一資料庫
是否於導覽樹自動展開單一資料庫。
伺服器
伺服器顯示選項。
伺服器
顯示伺服器選擇
在導覽面板上方,顯示伺服器清單。
使用清單方式顯示伺服器
顯示伺服器列表時,以清單取代下拉式選單。
資料庫
資料庫顯示選項。
資料庫
設定顯示篩選框的資料庫數量下限
資料庫導覽樹的分隔符號
會依據此分隔符號,將資料庫分為不同階層的樹狀。
資料表
資料表顯示選項。
資料表
快速存取圖示要顯示的目標頁面
結構
SQL
搜尋
新增
瀏覽
第二快速存取圖示的目標頁面
結構
SQL
搜尋
新增
瀏覽
資料表導覽樹的分隔符號
會依據此分隔符號將資料表分為不同階層的樹狀。
資料表導覽樹深度限制
將檔案拖放至此處
SQL 上載 (
0
)
x
-
顯示隱藏的導覽樹項目。
新增檢視表
必須啟用 Javascript 才能繼續!
伺服器: 127.0.0.1
資料庫: reliya_erp
結構
SQL
搜尋
查詢
(current)
匯出
匯入
操作
權限
預存程序
事件
觸發器
追蹤
設計器
中央欄位
主控台
清除
歷史記錄
選項
書籤
SQL 偵錯
請按 Ctrl+Enter 執行查詢
請按 Enter 執行查詢
遞增
遞減
排序:
SQL 偵錯
次數
執行排序
使用時間
排序依:
群組查詢
解除群組查詢
摺疊
展開
顯示追蹤
隱藏追蹤
次數 :
使用時間 :
書籤
重新整理
新增
無書籤
新增書籤
標籤:
目標資料庫:
分享此書籤
確定
選項
設為預設值
必定展開查詢訊息
於一開始顯示查詢記錄
顯示目前瀏覽的查詢
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
切換為深色主題
摺疊
展開
重新查詢
編輯
語句分析
效能分析
書籤
查詢失敗
資料庫 :
查詢時間 :
載入中
ENUM/SET 編輯器
新增檢視表
多表格查詢
依範例查詢(QBE)
切換至
visual builder
已加為書籤的搜尋:
新增書籤
欄位:
`accounts_payable`.*
`accounts_payable`.`id`
`accounts_payable`.`payable_no`
`accounts_payable`.`source_type`
`accounts_payable`.`source_id`
`accounts_payable`.`source_no`
`accounts_payable`.`payee_type`
`accounts_payable`.`payee_name`
`accounts_payable`.`title`
`accounts_payable`.`amount`
`accounts_payable`.`paid_amount`
`accounts_payable`.`currency`
`accounts_payable`.`exchange_rate`
`accounts_payable`.`status`
`accounts_payable`.`due_date`
`accounts_payable`.`paid_at`
`accounts_payable`.`paid_by`
`accounts_payable`.`payment_note`
`accounts_payable`.`note`
`accounts_payable`.`created_by`
`accounts_payable`.`created_at`
`accounts_payable`.`updated_at`
`annual_leave_settlements`.*
`annual_leave_settlements`.`id`
`annual_leave_settlements`.`employee_id`
`annual_leave_settlements`.`leave_year`
`annual_leave_settlements`.`period_start`
`annual_leave_settlements`.`period_end`
`annual_leave_settlements`.`expired_hours`
`annual_leave_settlements`.`expired_days`
`annual_leave_settlements`.`hourly_wage`
`annual_leave_settlements`.`daily_salary`
`annual_leave_settlements`.`settlement_amount`
`annual_leave_settlements`.`status`
`annual_leave_settlements`.`settled_by`
`annual_leave_settlements`.`settled_at`
`annual_leave_settlements`.`note`
`annual_leave_settlements`.`created_at`
`annual_leave_settlements`.`updated_at`
`approval_instance_steps`.*
`approval_instance_steps`.`id`
`approval_instance_steps`.`instance_id`
`approval_instance_steps`.`step_order`
`approval_instance_steps`.`step_name`
`approval_instance_steps`.`approver_employee_id`
`approval_instance_steps`.`status`
`approval_instance_steps`.`action_by_employee_id`
`approval_instance_steps`.`action_by_name`
`approval_instance_steps`.`action_note`
`approval_instance_steps`.`action_at`
`approval_instance_steps`.`created_at`
`approval_instance_steps`.`updated_at`
`approval_instances`.*
`approval_instances`.`id`
`approval_instances`.`workflow_id`
`approval_instances`.`source_type`
`approval_instances`.`source_id`
`approval_instances`.`status`
`approval_instances`.`current_step_order`
`approval_instances`.`created_at`
`approval_instances`.`updated_at`
`approval_items`.*
`approval_items`.`id`
`approval_items`.`form_type`
`approval_items`.`form_id`
`approval_items`.`applicant_id`
`approval_items`.`current_approver_id`
`approval_items`.`status`
`approval_items`.`created_at`
`approval_items`.`updated_at`
`approval_items`.`step_name`
`approval_items`.`sort_order`
`approval_records`.*
`approval_records`.`id`
`approval_records`.`module_type`
`approval_records`.`record_id`
`approval_records`.`approver_id`
`approval_records`.`approval_level`
`approval_records`.`action_status`
`approval_records`.`comments`
`approval_records`.`approved_at`
`approval_roles`.*
`approval_roles`.`id`
`approval_roles`.`role_key`
`approval_roles`.`role_name`
`approval_roles`.`description`
`approval_roles`.`sort_order`
`approval_roles`.`is_active`
`approval_roles`.`created_at`
`approval_roles`.`updated_at`
`approval_rules`.*
`approval_rules`.`id`
`approval_rules`.`form_type`
`approval_rules`.`max_approver_id`
`approval_rules`.`enabled`
`approval_rules`.`created_at`
`approval_workflow_steps`.*
`approval_workflow_steps`.`id`
`approval_workflow_steps`.`workflow_id`
`approval_workflow_steps`.`step_order`
`approval_workflow_steps`.`step_name`
`approval_workflow_steps`.`approver_employee_id`
`approval_workflow_steps`.`approver_type`
`approval_workflow_steps`.`approver_value`
`approval_workflow_steps`.`is_required`
`approval_workflow_steps`.`is_active`
`approval_workflow_steps`.`created_at`
`approval_workflow_steps`.`updated_at`
`approval_workflows`.*
`approval_workflows`.`id`
`approval_workflows`.`workflow_code`
`approval_workflows`.`workflow_name`
`approval_workflows`.`description`
`approval_workflows`.`is_active`
`approval_workflows`.`created_at`
`approval_workflows`.`updated_at`
`attendance_makeup_requests`.*
`attendance_makeup_requests`.`id`
`attendance_makeup_requests`.`request_no`
`attendance_makeup_requests`.`employee_id`
`attendance_makeup_requests`.`attendance_date`
`attendance_makeup_requests`.`makeup_type`
`attendance_makeup_requests`.`requested_clock_in`
`attendance_makeup_requests`.`requested_clock_out`
`attendance_makeup_requests`.`reason`
`attendance_makeup_requests`.`status`
`attendance_makeup_requests`.`manager_approver_id`
`attendance_makeup_requests`.`approved_by`
`attendance_makeup_requests`.`approved_at`
`attendance_makeup_requests`.`rejected_by`
`attendance_makeup_requests`.`rejected_at`
`attendance_makeup_requests`.`approval_note`
`attendance_makeup_requests`.`attendance_record_id`
`attendance_makeup_requests`.`created_at`
`attendance_makeup_requests`.`updated_at`
`attendance_records`.*
`attendance_records`.`id`
`attendance_records`.`employee_id`
`attendance_records`.`attendance_date`
`attendance_records`.`clock_in`
`attendance_records`.`clock_out`
`attendance_records`.`work_hours`
`attendance_records`.`status`
`attendance_records`.`ip_address`
`attendance_records`.`device_info`
`attendance_records`.`created_at`
`attendance_records`.`updated_at`
`attendance_settings`.*
`attendance_settings`.`id`
`attendance_settings`.`work_start_time`
`attendance_settings`.`work_end_time`
`attendance_settings`.`late_grace_minutes`
`attendance_settings`.`early_leave_grace_minutes`
`attendance_settings`.`updated_by`
`attendance_settings`.`created_at`
`attendance_settings`.`updated_at`
`attendance_settings`.`setting_key`
`attendance_settings`.`setting_value`
`attendance_settings`.`setting_label`
`audit_logs`.*
`audit_logs`.`id`
`audit_logs`.`user_id`
`audit_logs`.`username`
`audit_logs`.`table_name`
`audit_logs`.`record_id`
`audit_logs`.`action`
`audit_logs`.`old_data`
`audit_logs`.`new_data`
`audit_logs`.`created_at`
`calibrations`.*
`calibrations`.`id`
`calibrations`.`calibration_no`
`calibrations`.`customer_id`
`calibrations`.`product_id`
`calibrations`.`serial_number`
`calibrations`.`send_date`
`calibrations`.`return_date`
`calibrations`.`certificate_no`
`calibrations`.`expire_date`
`calibrations`.`calibration_vendor`
`calibrations`.`status`
`calibrations`.`note`
`calibrations`.`created_by`
`calibrations`.`created_at`
`calibrations`.`updated_at`
`crm_customer_followups`.*
`crm_customer_followups`.`id`
`crm_customer_followups`.`customer_id`
`crm_customer_followups`.`follow_date`
`crm_customer_followups`.`follow_type`
`crm_customer_followups`.`subject`
`crm_customer_followups`.`content`
`crm_customer_followups`.`next_followup_date`
`crm_customer_followups`.`created_by_user_id`
`crm_customer_followups`.`created_by_name`
`crm_customer_followups`.`created_at`
`customers`.*
`customers`.`id`
`customers`.`company_name`
`customers`.`customer_code`
`customers`.`category`
`customers`.`tax_id`
`customers`.`phone`
`customers`.`email`
`customers`.`country`
`customers`.`city`
`customers`.`website`
`customers`.`address`
`customers`.`remark`
`customers`.`business_card`
`customers`.`created_by_user_id`
`customers`.`created_by_name`
`customers`.`contact_name`
`customers`.`department`
`customers`.`title`
`customers`.`tel`
`customers`.`ext`
`customers`.`mobile`
`customers`.`contact_title`
`customers`.`contact_phone`
`customers`.`contact_email`
`customers`.`status`
`customers`.`customer_tags`
`customers`.`customer_level`
`customers`.`customer_source`
`customers`.`owner_user_id`
`customers`.`owner_name`
`customers`.`last_visit_date`
`customers`.`next_followup_date`
`customers`.`notes`
`customers`.`created_at`
`customers`.`updated_at`
`dashboard_card_preferences`.*
`dashboard_card_preferences`.`id`
`dashboard_card_preferences`.`user_key`
`dashboard_card_preferences`.`card_key`
`dashboard_card_preferences`.`is_visible`
`dashboard_card_preferences`.`sort_order`
`dashboard_card_preferences`.`updated_at`
`department_feature_permissions`.*
`department_feature_permissions`.`id`
`department_feature_permissions`.`department_id`
`department_feature_permissions`.`feature_code`
`department_feature_permissions`.`allowed`
`department_feature_permissions`.`can_view`
`department_feature_permissions`.`can_add`
`department_feature_permissions`.`can_edit`
`department_feature_permissions`.`can_delete`
`department_feature_permissions`.`can_approve`
`department_feature_permissions`.`created_by`
`department_feature_permissions`.`created_at`
`department_feature_permissions`.`updated_at`
`departments`.*
`departments`.`id`
`departments`.`name`
`departments`.`sort_order`
`departments`.`created_at`
`departments`.`code`
`departments`.`status`
`departments`.`updated_at`
`employee_approval_roles`.*
`employee_approval_roles`.`id`
`employee_approval_roles`.`employee_id`
`employee_approval_roles`.`role_key`
`employee_approval_roles`.`is_active`
`employee_approval_roles`.`created_at`
`employee_approval_roles`.`updated_at`
`employee_approval_roles`.`role_id`
`employee_comp_leave_balances`.*
`employee_comp_leave_balances`.`id`
`employee_comp_leave_balances`.`employee_id`
`employee_comp_leave_balances`.`transaction_type`
`employee_comp_leave_balances`.`hours`
`employee_comp_leave_balances`.`source_type`
`employee_comp_leave_balances`.`source_id`
`employee_comp_leave_balances`.`note`
`employee_comp_leave_balances`.`created_at`
`employee_feature_permissions`.*
`employee_feature_permissions`.`id`
`employee_feature_permissions`.`employee_id`
`employee_feature_permissions`.`feature_code`
`employee_feature_permissions`.`allowed`
`employee_feature_permissions`.`created_by`
`employee_feature_permissions`.`created_at`
`employee_feature_permissions`.`updated_at`
`employee_insurance_history`.*
`employee_insurance_history`.`id`
`employee_insurance_history`.`employee_id`
`employee_insurance_history`.`labor_insurance_mode`
`employee_insurance_history`.`labor_fixed_deduction`
`employee_insurance_history`.`health_insurance_mode`
`employee_insurance_history`.`health_fixed_deduction`
`employee_insurance_history`.`health_dependents`
`employee_insurance_history`.`change_reason`
`employee_insurance_history`.`note`
`employee_insurance_history`.`created_by`
`employee_insurance_history`.`created_at`
`employee_leave_balances`.*
`employee_leave_balances`.`id`
`employee_leave_balances`.`employee_id`
`employee_leave_balances`.`year`
`employee_leave_balances`.`annual_leave_days`
`employee_leave_balances`.`used_leave_days`
`employee_leave_balances`.`remaining_leave_days`
`employee_leave_balances`.`updated_at`
`employee_leave_balances`.`imported_used_hours`
`employee_leave_balances`.`imported_used_days`
`employee_leave_balances`.`imported_note`
`employee_leave_balances`.`imported_updated_at`
`employee_leave_balances`.`imported_updated_by`
`employee_salary_history`.*
`employee_salary_history`.`id`
`employee_salary_history`.`employee_id`
`employee_salary_history`.`effective_date`
`employee_salary_history`.`base_salary`
`employee_salary_history`.`meal_allowance`
`employee_salary_history`.`change_reason`
`employee_salary_history`.`note`
`employee_salary_history`.`created_by`
`employee_salary_history`.`created_at`
`employee_salary_settings`.*
`employee_salary_settings`.`id`
`employee_salary_settings`.`employee_id`
`employee_salary_settings`.`base_salary`
`employee_salary_settings`.`meal_allowance`
`employee_salary_settings`.`default_work_days`
`employee_salary_settings`.`is_active`
`employee_salary_settings`.`note`
`employee_salary_settings`.`created_at`
`employee_salary_settings`.`updated_at`
`employees`.*
`employees`.`id`
`employees`.`employee_no`
`employees`.`name`
`employees`.`english_name`
`employees`.`quote_owner_code`
`employees`.`department_id`
`employees`.`position`
`employees`.`email`
`employees`.`tel`
`employees`.`ext`
`employees`.`mobile`
`employees`.`hire_date`
`employees`.`resign_date`
`employees`.`status`
`employees`.`emergency_contact`
`employees`.`emergency_phone`
`employees`.`address`
`employees`.`photo_path`
`employees`.`note`
`employees`.`user_id`
`employees`.`created_by`
`employees`.`created_at`
`employees`.`updated_at`
`employees`.`sort_order`
`employees`.`manager_id`
`employees`.`position_id`
`employees`.`gender`
`employees`.`birthday`
`employees`.`id_no`
`employees`.`line_id`
`employees`.`nationality`
`employees`.`blood_type`
`employees`.`bank_name`
`employees`.`bank_account`
`employees`.`insurance_no`
`employees`.`labor_insurance_mode`
`employees`.`labor_fixed_deduction`
`employees`.`health_insurance_mode`
`employees`.`health_fixed_deduction`
`employees`.`health_dependents`
`employees`.`annual_leave_policy`
`employees`.`annual_leave_extra_days`
`employees`.`annual_leave_extra_note`
`employees`.`company_email`
`erp_feature_categories`.*
`erp_feature_categories`.`id`
`erp_feature_categories`.`category_key`
`erp_feature_categories`.`category_name`
`erp_feature_categories`.`icon_class`
`erp_feature_categories`.`sort_order`
`erp_feature_categories`.`is_active`
`erp_feature_categories`.`created_at`
`erp_feature_categories`.`updated_at`
`erp_feature_menu_settings`.*
`erp_feature_menu_settings`.`feature_code`
`erp_feature_menu_settings`.`category_id`
`erp_feature_menu_settings`.`sort_order`
`erp_feature_menu_settings`.`icon_class`
`erp_feature_menu_settings`.`show_sidebar`
`erp_feature_menu_settings`.`show_mobile`
`erp_feature_menu_settings`.`dashboard_visible`
`erp_feature_menu_settings`.`updated_at`
`erp_features`.*
`erp_features`.`id`
`erp_features`.`feature_code`
`erp_features`.`feature_name`
`erp_features`.`feature_group`
`erp_features`.`sort_order`
`erp_features`.`is_active`
`erp_features`.`created_at`
`erp_features`.`updated_at`
`erp_features`.`feature_color`
`erp_features`.`mobile_visible`
`erp_features`.`dashboard_visible`
`exchange_rates`.*
`exchange_rates`.`currency`
`exchange_rates`.`rate`
`exchange_rates`.`note`
`exchange_rates`.`updated_by`
`exchange_rates`.`updated_at`
`expense_applications`.*
`expense_applications`.`id`
`expense_applications`.`application_no`
`expense_applications`.`applicant_user_id`
`expense_applications`.`applicant_employee_id`
`expense_applications`.`applicant_name`
`expense_applications`.`department_id`
`expense_applications`.`department_name`
`expense_applications`.`period_start`
`expense_applications`.`period_end`
`expense_applications`.`apply_date`
`expense_applications`.`status`
`expense_applications`.`total_amount`
`expense_applications`.`note`
`expense_applications`.`submitted_at`
`expense_applications`.`admin_review_by`
`expense_applications`.`admin_review_at`
`expense_applications`.`admin_review_note`
`expense_applications`.`gm_approve_by`
`expense_applications`.`gm_approve_at`
`expense_applications`.`gm_approve_note`
`expense_applications`.`paid_at`
`expense_applications`.`paid_by`
`expense_applications`.`created_by`
`expense_applications`.`created_at`
`expense_applications`.`updated_at`
`expense_approval_logs`.*
`expense_approval_logs`.`id`
`expense_approval_logs`.`application_id`
`expense_approval_logs`.`action`
`expense_approval_logs`.`action_by`
`expense_approval_logs`.`action_at`
`expense_approval_logs`.`note`
`expense_item_receipts`.*
`expense_item_receipts`.`id`
`expense_item_receipts`.`item_id`
`expense_item_receipts`.`application_id`
`expense_item_receipts`.`file_path`
`expense_item_receipts`.`file_name`
`expense_item_receipts`.`uploaded_by`
`expense_item_receipts`.`uploaded_at`
`expense_items`.*
`expense_items`.`id`
`expense_items`.`application_id`
`expense_items`.`expense_date`
`expense_items`.`description`
`expense_items`.`local_currency`
`expense_items`.`exchange_rate`
`expense_items`.`category`
`expense_items`.`local_amount`
`expense_items`.`amount_twd`
`expense_items`.`remark_no`
`expense_items`.`note`
`expense_items`.`sort_order`
`expense_items`.`created_at`
`feature_categories`.*
`feature_categories`.`id`
`feature_categories`.`category_name`
`feature_categories`.`sort_order`
`feature_categories`.`icon`
`feature_categories`.`category_status`
`feature_categories`.`category_color`
`feature_categories`.`homepage_visible`
`feature_categories`.`mobile_visible`
`inventory`.*
`inventory`.`id`
`inventory`.`item_name`
`inventory`.`qty`
`inventory`.`created_at`
`inventory_demand_order_items`.*
`inventory_demand_order_items`.`id`
`inventory_demand_order_items`.`demand_order_id`
`inventory_demand_order_items`.`finished_product_id`
`inventory_demand_order_items`.`qty`
`inventory_demand_order_items`.`created_at`
`inventory_demand_orders`.*
`inventory_demand_orders`.`id`
`inventory_demand_orders`.`order_no`
`inventory_demand_orders`.`customer_name`
`inventory_demand_orders`.`demand_type`
`inventory_demand_orders`.`probability`
`inventory_demand_orders`.`expected_delivery_date`
`inventory_demand_orders`.`status`
`inventory_demand_orders`.`remark`
`inventory_demand_orders`.`created_by`
`inventory_demand_orders`.`created_at`
`inventory_demand_orders`.`updated_at`
`inventory_receipts`.*
`inventory_receipts`.`id`
`inventory_receipts`.`receipt_no`
`inventory_receipts`.`project_no`
`inventory_receipts`.`purchase_order_no`
`inventory_receipts`.`item_name`
`inventory_receipts`.`qty`
`inventory_receipts`.`location`
`inventory_receipts`.`status`
`inventory_receipts`.`created_at`
`inventory_receipts`.`updated_at`
`inventory_sku_categories`.*
`inventory_sku_categories`.`id`
`inventory_sku_categories`.`code`
`inventory_sku_categories`.`name`
`inventory_sku_categories`.`sort_order`
`inventory_sku_categories`.`is_active`
`inventory_sku_categories`.`created_at`
`inventory_sku_categories`.`updated_at`
`inventory_sku_lines`.*
`inventory_sku_lines`.`id`
`inventory_sku_lines`.`code`
`inventory_sku_lines`.`name`
`inventory_sku_lines`.`sort_order`
`inventory_sku_lines`.`is_active`
`inventory_sku_lines`.`created_at`
`inventory_sku_lines`.`updated_at`
`inventory_sku_origins`.*
`inventory_sku_origins`.`id`
`inventory_sku_origins`.`code`
`inventory_sku_origins`.`name`
`inventory_sku_origins`.`sort_order`
`inventory_sku_origins`.`is_active`
`inventory_sku_origins`.`created_at`
`inventory_sku_origins`.`updated_at`
`inventory_transactions`.*
`inventory_transactions`.`id`
`inventory_transactions`.`product_id`
`inventory_transactions`.`type`
`inventory_transactions`.`qty`
`inventory_transactions`.`before_stock`
`inventory_transactions`.`after_stock`
`inventory_transactions`.`customer_name`
`inventory_transactions`.`serial_number`
`inventory_transactions`.`location`
`inventory_transactions`.`note`
`inventory_transactions`.`created_by`
`inventory_transactions`.`created_at`
`inventory_transactions`.`project_id`
`inventory_transactions`.`transaction_type`
`invoice_applications`.*
`invoice_applications`.`id`
`invoice_applications`.`invoice_request_no`
`invoice_applications`.`applicant_id`
`invoice_applications`.`project_no`
`invoice_applications`.`customer_name`
`invoice_applications`.`invoice_type`
`invoice_applications`.`billing_percent`
`invoice_applications`.`amount`
`invoice_applications`.`description`
`invoice_applications`.`status`
`invoice_applications`.`manager_approver_id`
`invoice_applications`.`admin_issuer_id`
`invoice_applications`.`invoice_no`
`invoice_applications`.`invoice_file`
`invoice_applications`.`issued_at`
`invoice_applications`.`project_billing_completed`
`invoice_applications`.`created_at`
`invoice_applications`.`updated_at`
`leave_applications`.*
`leave_applications`.`id`
`leave_applications`.`employee_id`
`leave_applications`.`leave_type`
`leave_applications`.`start_date`
`leave_applications`.`start_time`
`leave_applications`.`end_date`
`leave_applications`.`end_time`
`leave_applications`.`days`
`leave_applications`.`reason`
`leave_applications`.`status`
`leave_applications`.`approved_by`
`leave_applications`.`approved_at`
`leave_applications`.`rejected_reason`
`leave_applications`.`created_at`
`leave_applications`.`leave_type_id`
`leave_applications`.`hours`
`leave_applications_backup_before_clean`.*
`leave_applications_backup_before_clean`.`id`
`leave_applications_backup_before_clean`.`employee_id`
`leave_applications_backup_before_clean`.`leave_type`
`leave_applications_backup_before_clean`.`start_date`
`leave_applications_backup_before_clean`.`start_time`
`leave_applications_backup_before_clean`.`end_date`
`leave_applications_backup_before_clean`.`end_time`
`leave_applications_backup_before_clean`.`days`
`leave_applications_backup_before_clean`.`reason`
`leave_applications_backup_before_clean`.`status`
`leave_applications_backup_before_clean`.`approved_by`
`leave_applications_backup_before_clean`.`approved_at`
`leave_applications_backup_before_clean`.`rejected_reason`
`leave_applications_backup_before_clean`.`created_at`
`leave_applications_backup_before_clean`.`leave_type_id`
`leave_applications_backup_before_clean`.`hours`
`leave_types`.*
`leave_types`.`id`
`leave_types`.`name`
`leave_types`.`is_annual_leave`
`leave_types`.`deduct_annual_leave`
`leave_types`.`is_active`
`leave_types`.`sort_order`
`overtime_applications`.*
`overtime_applications`.`id`
`overtime_applications`.`employee_id`
`overtime_applications`.`overtime_date`
`overtime_applications`.`end_date`
`overtime_applications`.`start_time`
`overtime_applications`.`end_time`
`overtime_applications`.`hours`
`overtime_applications`.`day_type`
`overtime_applications`.`ot_134_hours`
`overtime_applications`.`ot_167_hours`
`overtime_applications`.`ot_200_hours`
`overtime_applications`.`ot_267_hours`
`overtime_applications`.`reason`
`overtime_applications`.`status`
`overtime_applications`.`approved_by`
`overtime_applications`.`approved_at`
`overtime_applications`.`rejected_reason`
`overtime_applications`.`created_at`
`payroll_brackets`.*
`payroll_brackets`.`id`
`payroll_brackets`.`bracket_type`
`payroll_brackets`.`salary_min`
`payroll_brackets`.`insured_amount`
`payroll_brackets`.`effective_year`
`payroll_brackets`.`created_at`
`payroll_holidays`.*
`payroll_holidays`.`id`
`payroll_holidays`.`holiday_date`
`payroll_holidays`.`holiday_name`
`payroll_holidays`.`holiday_type`
`payroll_holidays`.`created_at`
`payroll_records`.*
`payroll_records`.`id`
`payroll_records`.`payroll_month`
`payroll_records`.`employee_id`
`payroll_records`.`base_salary`
`payroll_records`.`meal_allowance`
`payroll_records`.`total_salary`
`payroll_records`.`work_days`
`payroll_records`.`is_full_month`
`payroll_records`.`calc_start_date`
`payroll_records`.`calc_end_date`
`payroll_records`.`payable_salary`
`payroll_records`.`labor_insured_amount`
`payroll_records`.`health_insured_amount`
`payroll_records`.`overtime_133_hours`
`payroll_records`.`overtime_166_hours`
`payroll_records`.`overtime_200_hours`
`payroll_records`.`overtime_267_hours`
`payroll_records`.`overtime_pay`
`payroll_records`.`annual_leave_cashout`
`payroll_records`.`paid_leave_hours`
`payroll_records`.`personal_leave_hours`
`payroll_records`.`sick_leave_half_hours`
`payroll_records`.`personal_leave_deduction`
`payroll_records`.`sick_leave_deduction`
`payroll_records`.`labor_insurance_mode`
`payroll_records`.`health_insurance_mode`
`payroll_records`.`labor_deduction`
`payroll_records`.`health_dependents`
`payroll_records`.`health_deduction`
`payroll_records`.`net_salary`
`payroll_records`.`note`
`payroll_records`.`status`
`payroll_records`.`created_by`
`payroll_records`.`created_at`
`payroll_records`.`updated_at`
`position_feature_permissions`.*
`position_feature_permissions`.`id`
`position_feature_permissions`.`position_id`
`position_feature_permissions`.`feature_code`
`position_feature_permissions`.`allowed`
`position_feature_permissions`.`created_by`
`position_feature_permissions`.`created_at`
`position_feature_permissions`.`updated_at`
`positions`.*
`positions`.`id`
`positions`.`department_id`
`positions`.`name`
`positions`.`level_no`
`positions`.`created_at`
`product_bom_items`.*
`product_bom_items`.`id`
`product_bom_items`.`bom_id`
`product_bom_items`.`component_product_id`
`product_bom_items`.`qty_per`
`product_bom_items`.`loss_rate`
`product_bom_items`.`note`
`product_bom_items`.`sort_order`
`product_bom_items`.`created_at`
`product_boms`.*
`product_boms`.`id`
`product_boms`.`finished_product_id`
`product_boms`.`bom_name`
`product_boms`.`version`
`product_boms`.`status`
`product_boms`.`remark`
`product_boms`.`created_by`
`product_boms`.`created_at`
`product_boms`.`updated_at`
`product_categories`.*
`product_categories`.`id`
`product_categories`.`name`
`product_categories`.`sort_order`
`product_categories`.`created_at`
`product_inventory`.*
`product_inventory`.`product_id`
`product_inventory`.`qty`
`product_inventory`.`updated_at`
`product_inventory_transactions`.*
`product_inventory_transactions`.`id`
`product_inventory_transactions`.`product_id`
`product_inventory_transactions`.`transaction_type`
`product_inventory_transactions`.`qty`
`product_inventory_transactions`.`related_bom_id`
`product_inventory_transactions`.`note`
`product_inventory_transactions`.`created_by`
`product_inventory_transactions`.`created_at`
`product_serials`.*
`product_serials`.`id`
`product_serials`.`product_id`
`product_serials`.`serial_type`
`product_serials`.`serial_number`
`product_serials`.`sensor_serial_id`
`product_serials`.`sensor_serial_number`
`product_serials`.`status`
`product_serials`.`location`
`product_serials`.`customer_name`
`product_serials`.`note`
`product_serials`.`assembled_at`
`product_serials`.`created_by`
`product_serials`.`void_reason`
`product_serials`.`void_by`
`product_serials`.`void_at`
`product_serials`.`shipped_at`
`product_serials`.`shipment_no`
`product_serials`.`created_at`
`product_serials`.`updated_at`
`products`.*
`products`.`id`
`products`.`sku`
`products`.`model`
`products`.`category_id`
`products`.`brand`
`products`.`supplier`
`products`.`manufacturer_part_no`
`products`.`name_tw`
`products`.`name_en`
`products`.`name_cn`
`products`.`description_tw`
`products`.`description_en`
`products`.`description_cn`
`products`.`spec_tw`
`products`.`spec_en`
`products`.`spec_cn`
`products`.`unit`
`products`.`currency`
`products`.`sale_price`
`products`.`cost_price`
`products`.`stock_qty`
`products`.`safety_stock`
`products`.`lead_time_days`
`products`.`status`
`products`.`item_type`
`products`.`image_path`
`products`.`catalog_path`
`products`.`remark`
`products`.`created_at`
`products`.`updated_at`
`project_applications`.*
`project_applications`.`id`
`project_applications`.`request_no`
`project_applications`.`applicant_id`
`project_applications`.`customer_name`
`project_applications`.`order_no`
`project_applications`.`quotation_no`
`project_applications`.`project_name`
`project_applications`.`amount`
`project_applications`.`payment_terms`
`project_applications`.`description`
`project_applications`.`status`
`project_applications`.`admin_reviewer_id`
`project_applications`.`reviewed_by`
`project_applications`.`reviewed_at`
`project_applications`.`project_no`
`project_applications`.`reject_reason`
`project_applications`.`created_at`
`project_applications`.`updated_at`
`project_applications`.`apply_date`
`project_applications`.`category_code`
`project_applications`.`customer_id`
`project_applications`.`quotation_id`
`project_applications`.`order_amount`
`project_applications`.`currency`
`project_applications`.`owner`
`project_applications`.`note`
`project_applications`.`order_file`
`project_applications`.`quote_file`
`project_applications`.`cost_file`
`project_applications`.`project_case_id`
`project_approvals`.*
`project_approvals`.`id`
`project_approvals`.`project_id`
`project_approvals`.`step_name`
`project_approvals`.`approver`
`project_approvals`.`status`
`project_approvals`.`comment`
`project_approvals`.`approved_at`
`project_approvals`.`created_at`
`project_cases`.*
`project_cases`.`id`
`project_cases`.`project_no`
`project_cases`.`apply_date`
`project_cases`.`category_code`
`project_cases`.`project_name`
`project_cases`.`customer_id`
`project_cases`.`quotation_id`
`project_cases`.`order_no`
`project_cases`.`order_amount`
`project_cases`.`currency`
`project_cases`.`exchange_rate`
`project_cases`.`owner`
`project_cases`.`status`
`project_cases`.`total_cost`
`project_cases`.`invoice_percent_done`
`project_cases`.`order_file`
`project_cases`.`quote_file`
`project_cases`.`cost_file`
`project_cases`.`note`
`project_cases`.`created_by`
`project_cases`.`closed_at`
`project_cases`.`created_at`
`project_cases`.`updated_at`
`project_cases_backup_20260615`.*
`project_cases_backup_20260615`.`id`
`project_cases_backup_20260615`.`project_no`
`project_cases_backup_20260615`.`apply_date`
`project_cases_backup_20260615`.`category_code`
`project_cases_backup_20260615`.`project_name`
`project_cases_backup_20260615`.`customer_id`
`project_cases_backup_20260615`.`quotation_id`
`project_cases_backup_20260615`.`order_no`
`project_cases_backup_20260615`.`order_amount`
`project_cases_backup_20260615`.`currency`
`project_cases_backup_20260615`.`exchange_rate`
`project_cases_backup_20260615`.`owner`
`project_cases_backup_20260615`.`status`
`project_cases_backup_20260615`.`total_cost`
`project_cases_backup_20260615`.`invoice_percent_done`
`project_cases_backup_20260615`.`order_file`
`project_cases_backup_20260615`.`quote_file`
`project_cases_backup_20260615`.`cost_file`
`project_cases_backup_20260615`.`note`
`project_cases_backup_20260615`.`created_by`
`project_cases_backup_20260615`.`closed_at`
`project_cases_backup_20260615`.`created_at`
`project_cases_backup_20260615`.`updated_at`
`project_categories`.*
`project_categories`.`category_code`
`project_categories`.`category_name`
`project_categories`.`sort_order`
`project_categories`.`is_active`
`project_category_allocations`.*
`project_category_allocations`.`id`
`project_category_allocations`.`project_id`
`project_category_allocations`.`category_code`
`project_category_allocations`.`amount`
`project_category_allocations`.`percent`
`project_category_allocations`.`currency`
`project_category_allocations`.`note`
`project_category_allocations`.`created_by`
`project_category_allocations`.`created_at`
`project_category_allocations`.`updated_at`
`project_costs`.*
`project_costs`.`id`
`project_costs`.`project_id`
`project_costs`.`cost_date`
`project_costs`.`department`
`project_costs`.`item_name`
`project_costs`.`amount`
`project_costs`.`note`
`project_costs`.`created_by`
`project_costs`.`created_at`
`project_invoices`.*
`project_invoices`.`id`
`project_invoices`.`project_id`
`project_invoices`.`receivable_schedule_id`
`project_invoices`.`invoice_date`
`project_invoices`.`invoice_percent`
`project_invoices`.`amount`
`project_invoices`.`invoice_no`
`project_invoices`.`application_no`
`project_invoices`.`status`
`project_invoices`.`note`
`project_invoices`.`created_by`
`project_invoices`.`created_at`
`project_invoices`.`application_status`
`project_invoices`.`applicant`
`project_invoices`.`applicant_employee_id`
`project_invoices`.`submitted_at`
`project_invoices`.`admin_checked_by`
`project_invoices`.`admin_checked_at`
`project_invoices`.`admin_checked_note`
`project_invoices`.`gm_approved_by`
`project_invoices`.`gm_approved_at`
`project_invoices`.`gm_approved_note`
`project_invoices`.`issued_by`
`project_invoices`.`issued_at`
`project_invoices`.`issued_note`
`project_invoices`.`rejected_by`
`project_invoices`.`rejected_at`
`project_invoices`.`rejected_note`
`project_invoices`.`due_date`
`project_invoices`.`currency`
`project_invoices`.`exchange_rate`
`project_invoices`.`invoice_amount`
`project_invoices`.`tax_amount`
`project_invoices`.`total_amount`
`project_invoices`.`paid_amount`
`project_invoices`.`updated_at`
`project_no_applications`.*
`project_no_applications`.`id`
`project_no_applications`.`request_no`
`project_no_applications`.`applicant_id`
`project_no_applications`.`customer_name`
`project_no_applications`.`order_no`
`project_no_applications`.`project_name`
`project_no_applications`.`amount`
`project_no_applications`.`description`
`project_no_applications`.`status`
`project_no_applications`.`admin_reviewer_id`
`project_no_applications`.`project_no`
`project_no_applications`.`created_at`
`project_no_applications`.`updated_at`
`project_no_applications_backup_20260615`.*
`project_no_applications_backup_20260615`.`id`
`project_no_applications_backup_20260615`.`request_no`
`project_no_applications_backup_20260615`.`applicant_id`
`project_no_applications_backup_20260615`.`customer_name`
`project_no_applications_backup_20260615`.`order_no`
`project_no_applications_backup_20260615`.`project_name`
`project_no_applications_backup_20260615`.`amount`
`project_no_applications_backup_20260615`.`description`
`project_no_applications_backup_20260615`.`status`
`project_no_applications_backup_20260615`.`admin_reviewer_id`
`project_no_applications_backup_20260615`.`project_no`
`project_no_applications_backup_20260615`.`created_at`
`project_no_applications_backup_20260615`.`updated_at`
`project_order_items`.*
`project_order_items`.`id`
`project_order_items`.`project_id`
`project_order_items`.`quotation_item_id`
`project_order_items`.`product_id`
`project_order_items`.`item_name`
`project_order_items`.`model`
`project_order_items`.`description`
`project_order_items`.`qty`
`project_order_items`.`unit`
`project_order_items`.`unit_price`
`project_order_items`.`discount_rate`
`project_order_items`.`amount`
`project_order_items`.`currency`
`project_order_items`.`category_code`
`project_order_items`.`sort_order`
`project_order_items`.`created_at`
`project_order_items`.`updated_at`
`project_payments`.*
`project_payments`.`id`
`project_payments`.`invoice_id`
`project_payments`.`project_id`
`project_payments`.`payment_date`
`project_payments`.`currency`
`project_payments`.`payment_amount`
`project_payments`.`payment_method`
`project_payments`.`reference_no`
`project_payments`.`note`
`project_payments`.`created_by`
`project_payments`.`created_at`
`project_receivable_schedules`.*
`project_receivable_schedules`.`id`
`project_receivable_schedules`.`project_id`
`project_receivable_schedules`.`order_id`
`project_receivable_schedules`.`schedule_name`
`project_receivable_schedules`.`billing_type`
`project_receivable_schedules`.`percent`
`project_receivable_schedules`.`amount`
`project_receivable_schedules`.`currency`
`project_receivable_schedules`.`exchange_rate`
`project_receivable_schedules`.`base_date_type`
`project_receivable_schedules`.`offset_days`
`project_receivable_schedules`.`expected_due_date`
`project_receivable_schedules`.`invoice_id`
`project_receivable_schedules`.`status`
`project_receivable_schedules`.`note`
`project_receivable_schedules`.`created_by`
`project_receivable_schedules`.`created_at`
`project_receivable_schedules`.`updated_at`
`projects`.*
`projects`.`id`
`projects`.`project_name`
`projects`.`project_manager`
`projects`.`start_date`
`projects`.`end_date`
`projects`.`status`
`projects`.`created_at`
`projects`.`customer_id`
`projects`.`quotation_id`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`purchase_order_no`
`purchase_orders`.`purchase_request_id`
`purchase_orders`.`project_no`
`purchase_orders`.`supplier_name`
`purchase_orders`.`amount`
`purchase_orders`.`delivery_date`
`purchase_orders`.`payment_terms`
`purchase_orders`.`status`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`purchase_orders`.`currency`
`purchase_orders`.`exchange_rate`
`purchase_requests`.*
`purchase_requests`.`id`
`purchase_requests`.`request_no`
`purchase_requests`.`project_id`
`purchase_requests`.`applicant_id`
`purchase_requests`.`project_no`
`purchase_requests`.`project_name`
`purchase_requests`.`supplier_name`
`purchase_requests`.`item_summary`
`purchase_requests`.`amount`
`purchase_requests`.`currency`
`purchase_requests`.`exchange_rate`
`purchase_requests`.`negotiated_amount`
`purchase_requests`.`delivery_date`
`purchase_requests`.`payment_terms`
`purchase_requests`.`remark`
`purchase_requests`.`quote_file`
`purchase_requests`.`required_date`
`purchase_requests`.`negotiation_notes`
`purchase_requests`.`status`
`purchase_requests`.`manager_approver_id`
`purchase_requests`.`gm_approver_id`
`purchase_requests`.`gm_approved_at`
`purchase_requests`.`gm_comment`
`purchase_requests`.`admin_handler_id`
`purchase_requests`.`admin_negotiator_id`
`purchase_requests`.`purchase_order_no`
`purchase_requests`.`ordered_at`
`purchase_requests`.`created_at`
`purchase_requests`.`updated_at`
`quotation_items`.*
`quotation_items`.`id`
`quotation_items`.`quotation_id`
`quotation_items`.`product_id`
`quotation_items`.`product_name`
`quotation_items`.`model`
`quotation_items`.`description`
`quotation_items`.`qty`
`quotation_items`.`unit`
`quotation_items`.`unit_price`
`quotation_items`.`discount_rate`
`quotation_items`.`category_code`
`quotation_items`.`line_total`
`quotation_items`.`sort_order`
`quotations`.*
`quotations`.`id`
`quotations`.`quote_no`
`quotations`.`customer_id`
`quotations`.`quote_date`
`quotations`.`valid_until`
`quotations`.`currency`
`quotations`.`tax_rate`
`quotations`.`discount_amount`
`quotations`.`subtotal`
`quotations`.`tax_amount`
`quotations`.`total_amount`
`quotations`.`special_price_enabled`
`quotations`.`special_price_label`
`quotations`.`special_price_amount`
`quotations`.`special_price_tax_included`
`quotations`.`status`
`quotations`.`note`
`quotations`.`terms`
`quotations`.`created_by`
`quotations`.`created_at`
`quotations`.`updated_at`
`quotations`.`project_id`
`quotations`.`parent_quotation_id`
`quotations`.`version_no`
`quotations`.`is_latest`
`quotations`.`revision_reason`
`quotations`.`replaced_by_id`
`quotations`.`source_quote_id`
`rbac_permissions`.*
`rbac_permissions`.`id`
`rbac_permissions`.`permission_key`
`rbac_permissions`.`permission_name`
`rbac_permissions`.`module_name`
`rbac_permissions`.`description`
`rbac_permissions`.`sort_order`
`rbac_permissions`.`created_at`
`rbac_role_permissions`.*
`rbac_role_permissions`.`id`
`rbac_role_permissions`.`role_id`
`rbac_role_permissions`.`permission_id`
`rbac_role_permissions`.`created_at`
`rbac_roles`.*
`rbac_roles`.`id`
`rbac_roles`.`role_key`
`rbac_roles`.`role_name`
`rbac_roles`.`description`
`rbac_roles`.`is_system`
`rbac_roles`.`sort_order`
`rbac_roles`.`created_at`
`rbac_user_roles`.*
`rbac_user_roles`.`id`
`rbac_user_roles`.`user_id`
`rbac_user_roles`.`role_id`
`rbac_user_roles`.`created_at`
`sales_forecast_followups`.*
`sales_forecast_followups`.`id`
`sales_forecast_followups`.`forecast_id`
`sales_forecast_followups`.`followup_date`
`sales_forecast_followups`.`followup_type`
`sales_forecast_followups`.`content`
`sales_forecast_followups`.`next_followup_date`
`sales_forecast_followups`.`created_by`
`sales_forecast_followups`.`created_at`
`sales_forecasts`.*
`sales_forecasts`.`id`
`sales_forecasts`.`forecast_no`
`sales_forecasts`.`owner_name`
`sales_forecasts`.`owner_employee_id`
`sales_forecasts`.`customer_id`
`sales_forecasts`.`company_name`
`sales_forecasts`.`contact_name`
`sales_forecasts`.`contact_phone`
`sales_forecasts`.`contact_email`
`sales_forecasts`.`project_name`
`sales_forecasts`.`product_name`
`sales_forecasts`.`source`
`sales_forecasts`.`stage`
`sales_forecasts`.`status`
`sales_forecasts`.`probability`
`sales_forecasts`.`currency`
`sales_forecasts`.`cost_amount`
`sales_forecasts`.`sales_amount`
`sales_forecasts`.`gross_profit`
`sales_forecasts`.`gross_margin`
`sales_forecasts`.`weighted_amount`
`sales_forecasts`.`expected_order_date`
`sales_forecasts`.`expected_start_date`
`sales_forecasts`.`expected_finish_date`
`sales_forecasts`.`next_followup_date`
`sales_forecasts`.`quotation_id`
`sales_forecasts`.`order_id`
`sales_forecasts`.`project_id`
`sales_forecasts`.`description`
`sales_forecasts`.`last_followup_note`
`sales_forecasts`.`created_by`
`sales_forecasts`.`updated_by`
`sales_forecasts`.`created_at`
`sales_forecasts`.`updated_at`
`service_cases`.*
`service_cases`.`id`
`service_cases`.`case_no`
`service_cases`.`case_date`
`service_cases`.`customer_id`
`service_cases`.`product_id`
`service_cases`.`serial_number`
`service_cases`.`subject`
`service_cases`.`problem_description`
`service_cases`.`solution`
`service_cases`.`status`
`service_cases`.`priority`
`service_cases`.`assigned_to`
`service_cases`.`note`
`service_cases`.`created_by`
`service_cases`.`created_at`
`service_cases`.`updated_at`
`shipment_items`.*
`shipment_items`.`id`
`shipment_items`.`shipment_id`
`shipment_items`.`finished_serial_id`
`shipment_items`.`product_id`
`shipment_items`.`serial_number`
`shipment_items`.`cell_serial_number`
`shipment_items`.`created_at`
`shipments`.*
`shipments`.`id`
`shipments`.`shipment_no`
`shipments`.`customer_id`
`shipments`.`customer_name`
`shipments`.`project_id`
`shipments`.`contact`
`shipments`.`shipping_address`
`shipments`.`order_no`
`shipments`.`project_no`
`shipments`.`shipment_date`
`shipments`.`items`
`shipments`.`status`
`shipments`.`remark`
`shipments`.`created_by`
`shipments`.`created_at`
`shipments`.`updated_at`
`user_quick_features`.*
`user_quick_features`.`id`
`user_quick_features`.`user_id`
`user_quick_features`.`feature_key`
`user_quick_features`.`sort_order`
`user_quick_features`.`created_at`
`user_system_settings`.*
`user_system_settings`.`user_id`
`user_system_settings`.`receive_all_approval_notifications`
`user_system_settings`.`created_at`
`user_system_settings`.`updated_at`
`users`.*
`users`.`id`
`users`.`username`
`users`.`password`
`users`.`password_hash`
`users`.`name`
`users`.`role`
`users`.`status`
`users`.`created_at`
`vw_customer_quote_project`.*
`vw_customer_quote_project`.`customer_id`
`vw_customer_quote_project`.`company_name`
`vw_customer_quote_project`.`quotation_id`
`vw_customer_quote_project`.`quote_no`
`vw_customer_quote_project`.`quotation_status`
`vw_customer_quote_project`.`quotation_amount`
`vw_customer_quote_project`.`project_id`
`vw_customer_quote_project`.`project_no`
`vw_customer_quote_project`.`project_name`
`vw_customer_quote_project`.`project_status`
`vw_customer_quote_project`.`order_amount`
`vw_customer_sales_flow`.*
`vw_customer_sales_flow`.`customer_id`
`vw_customer_sales_flow`.`company_name`
`vw_customer_sales_flow`.`quotation_id`
`vw_customer_sales_flow`.`quotation_status`
`vw_customer_sales_flow`.`project_id`
`vw_customer_sales_flow`.`project_status`
`vw_project_inventory_flow`.*
`vw_project_inventory_flow`.`project_id`
`vw_project_inventory_flow`.`project_status`
`vw_project_inventory_flow`.`transaction_id`
`vw_project_inventory_flow`.`transaction_type`
`vw_project_inventory_flow`.`qty`
`vw_project_inventory_flow`.`note`
`vw_project_inventory_transactions`.*
`vw_project_inventory_transactions`.`project_id`
`vw_project_inventory_transactions`.`project_no`
`vw_project_inventory_transactions`.`project_name`
`vw_project_inventory_transactions`.`transaction_id`
`vw_project_inventory_transactions`.`product_id`
`vw_project_inventory_transactions`.`sku`
`vw_project_inventory_transactions`.`name_tw`
`vw_project_inventory_transactions`.`type`
`vw_project_inventory_transactions`.`qty`
`vw_project_inventory_transactions`.`before_stock`
`vw_project_inventory_transactions`.`after_stock`
`vw_project_inventory_transactions`.`serial_number`
`vw_project_inventory_transactions`.`location`
`vw_project_inventory_transactions`.`created_at`
`workflow_settings`.*
`workflow_settings`.`id`
`workflow_settings`.`setting_key`
`workflow_settings`.`setting_value`
`workflow_settings`.`setting_label`
`workflow_settings`.`created_at`
`workflow_settings`.`updated_at`
`accounts_payable`.*
`accounts_payable`.`id`
`accounts_payable`.`payable_no`
`accounts_payable`.`source_type`
`accounts_payable`.`source_id`
`accounts_payable`.`source_no`
`accounts_payable`.`payee_type`
`accounts_payable`.`payee_name`
`accounts_payable`.`title`
`accounts_payable`.`amount`
`accounts_payable`.`paid_amount`
`accounts_payable`.`currency`
`accounts_payable`.`exchange_rate`
`accounts_payable`.`status`
`accounts_payable`.`due_date`
`accounts_payable`.`paid_at`
`accounts_payable`.`paid_by`
`accounts_payable`.`payment_note`
`accounts_payable`.`note`
`accounts_payable`.`created_by`
`accounts_payable`.`created_at`
`accounts_payable`.`updated_at`
`annual_leave_settlements`.*
`annual_leave_settlements`.`id`
`annual_leave_settlements`.`employee_id`
`annual_leave_settlements`.`leave_year`
`annual_leave_settlements`.`period_start`
`annual_leave_settlements`.`period_end`
`annual_leave_settlements`.`expired_hours`
`annual_leave_settlements`.`expired_days`
`annual_leave_settlements`.`hourly_wage`
`annual_leave_settlements`.`daily_salary`
`annual_leave_settlements`.`settlement_amount`
`annual_leave_settlements`.`status`
`annual_leave_settlements`.`settled_by`
`annual_leave_settlements`.`settled_at`
`annual_leave_settlements`.`note`
`annual_leave_settlements`.`created_at`
`annual_leave_settlements`.`updated_at`
`approval_instance_steps`.*
`approval_instance_steps`.`id`
`approval_instance_steps`.`instance_id`
`approval_instance_steps`.`step_order`
`approval_instance_steps`.`step_name`
`approval_instance_steps`.`approver_employee_id`
`approval_instance_steps`.`status`
`approval_instance_steps`.`action_by_employee_id`
`approval_instance_steps`.`action_by_name`
`approval_instance_steps`.`action_note`
`approval_instance_steps`.`action_at`
`approval_instance_steps`.`created_at`
`approval_instance_steps`.`updated_at`
`approval_instances`.*
`approval_instances`.`id`
`approval_instances`.`workflow_id`
`approval_instances`.`source_type`
`approval_instances`.`source_id`
`approval_instances`.`status`
`approval_instances`.`current_step_order`
`approval_instances`.`created_at`
`approval_instances`.`updated_at`
`approval_items`.*
`approval_items`.`id`
`approval_items`.`form_type`
`approval_items`.`form_id`
`approval_items`.`applicant_id`
`approval_items`.`current_approver_id`
`approval_items`.`status`
`approval_items`.`created_at`
`approval_items`.`updated_at`
`approval_items`.`step_name`
`approval_items`.`sort_order`
`approval_records`.*
`approval_records`.`id`
`approval_records`.`module_type`
`approval_records`.`record_id`
`approval_records`.`approver_id`
`approval_records`.`approval_level`
`approval_records`.`action_status`
`approval_records`.`comments`
`approval_records`.`approved_at`
`approval_roles`.*
`approval_roles`.`id`
`approval_roles`.`role_key`
`approval_roles`.`role_name`
`approval_roles`.`description`
`approval_roles`.`sort_order`
`approval_roles`.`is_active`
`approval_roles`.`created_at`
`approval_roles`.`updated_at`
`approval_rules`.*
`approval_rules`.`id`
`approval_rules`.`form_type`
`approval_rules`.`max_approver_id`
`approval_rules`.`enabled`
`approval_rules`.`created_at`
`approval_workflow_steps`.*
`approval_workflow_steps`.`id`
`approval_workflow_steps`.`workflow_id`
`approval_workflow_steps`.`step_order`
`approval_workflow_steps`.`step_name`
`approval_workflow_steps`.`approver_employee_id`
`approval_workflow_steps`.`approver_type`
`approval_workflow_steps`.`approver_value`
`approval_workflow_steps`.`is_required`
`approval_workflow_steps`.`is_active`
`approval_workflow_steps`.`created_at`
`approval_workflow_steps`.`updated_at`
`approval_workflows`.*
`approval_workflows`.`id`
`approval_workflows`.`workflow_code`
`approval_workflows`.`workflow_name`
`approval_workflows`.`description`
`approval_workflows`.`is_active`
`approval_workflows`.`created_at`
`approval_workflows`.`updated_at`
`attendance_makeup_requests`.*
`attendance_makeup_requests`.`id`
`attendance_makeup_requests`.`request_no`
`attendance_makeup_requests`.`employee_id`
`attendance_makeup_requests`.`attendance_date`
`attendance_makeup_requests`.`makeup_type`
`attendance_makeup_requests`.`requested_clock_in`
`attendance_makeup_requests`.`requested_clock_out`
`attendance_makeup_requests`.`reason`
`attendance_makeup_requests`.`status`
`attendance_makeup_requests`.`manager_approver_id`
`attendance_makeup_requests`.`approved_by`
`attendance_makeup_requests`.`approved_at`
`attendance_makeup_requests`.`rejected_by`
`attendance_makeup_requests`.`rejected_at`
`attendance_makeup_requests`.`approval_note`
`attendance_makeup_requests`.`attendance_record_id`
`attendance_makeup_requests`.`created_at`
`attendance_makeup_requests`.`updated_at`
`attendance_records`.*
`attendance_records`.`id`
`attendance_records`.`employee_id`
`attendance_records`.`attendance_date`
`attendance_records`.`clock_in`
`attendance_records`.`clock_out`
`attendance_records`.`work_hours`
`attendance_records`.`status`
`attendance_records`.`ip_address`
`attendance_records`.`device_info`
`attendance_records`.`created_at`
`attendance_records`.`updated_at`
`attendance_settings`.*
`attendance_settings`.`id`
`attendance_settings`.`work_start_time`
`attendance_settings`.`work_end_time`
`attendance_settings`.`late_grace_minutes`
`attendance_settings`.`early_leave_grace_minutes`
`attendance_settings`.`updated_by`
`attendance_settings`.`created_at`
`attendance_settings`.`updated_at`
`attendance_settings`.`setting_key`
`attendance_settings`.`setting_value`
`attendance_settings`.`setting_label`
`audit_logs`.*
`audit_logs`.`id`
`audit_logs`.`user_id`
`audit_logs`.`username`
`audit_logs`.`table_name`
`audit_logs`.`record_id`
`audit_logs`.`action`
`audit_logs`.`old_data`
`audit_logs`.`new_data`
`audit_logs`.`created_at`
`calibrations`.*
`calibrations`.`id`
`calibrations`.`calibration_no`
`calibrations`.`customer_id`
`calibrations`.`product_id`
`calibrations`.`serial_number`
`calibrations`.`send_date`
`calibrations`.`return_date`
`calibrations`.`certificate_no`
`calibrations`.`expire_date`
`calibrations`.`calibration_vendor`
`calibrations`.`status`
`calibrations`.`note`
`calibrations`.`created_by`
`calibrations`.`created_at`
`calibrations`.`updated_at`
`crm_customer_followups`.*
`crm_customer_followups`.`id`
`crm_customer_followups`.`customer_id`
`crm_customer_followups`.`follow_date`
`crm_customer_followups`.`follow_type`
`crm_customer_followups`.`subject`
`crm_customer_followups`.`content`
`crm_customer_followups`.`next_followup_date`
`crm_customer_followups`.`created_by_user_id`
`crm_customer_followups`.`created_by_name`
`crm_customer_followups`.`created_at`
`customers`.*
`customers`.`id`
`customers`.`company_name`
`customers`.`customer_code`
`customers`.`category`
`customers`.`tax_id`
`customers`.`phone`
`customers`.`email`
`customers`.`country`
`customers`.`city`
`customers`.`website`
`customers`.`address`
`customers`.`remark`
`customers`.`business_card`
`customers`.`created_by_user_id`
`customers`.`created_by_name`
`customers`.`contact_name`
`customers`.`department`
`customers`.`title`
`customers`.`tel`
`customers`.`ext`
`customers`.`mobile`
`customers`.`contact_title`
`customers`.`contact_phone`
`customers`.`contact_email`
`customers`.`status`
`customers`.`customer_tags`
`customers`.`customer_level`
`customers`.`customer_source`
`customers`.`owner_user_id`
`customers`.`owner_name`
`customers`.`last_visit_date`
`customers`.`next_followup_date`
`customers`.`notes`
`customers`.`created_at`
`customers`.`updated_at`
`dashboard_card_preferences`.*
`dashboard_card_preferences`.`id`
`dashboard_card_preferences`.`user_key`
`dashboard_card_preferences`.`card_key`
`dashboard_card_preferences`.`is_visible`
`dashboard_card_preferences`.`sort_order`
`dashboard_card_preferences`.`updated_at`
`department_feature_permissions`.*
`department_feature_permissions`.`id`
`department_feature_permissions`.`department_id`
`department_feature_permissions`.`feature_code`
`department_feature_permissions`.`allowed`
`department_feature_permissions`.`can_view`
`department_feature_permissions`.`can_add`
`department_feature_permissions`.`can_edit`
`department_feature_permissions`.`can_delete`
`department_feature_permissions`.`can_approve`
`department_feature_permissions`.`created_by`
`department_feature_permissions`.`created_at`
`department_feature_permissions`.`updated_at`
`departments`.*
`departments`.`id`
`departments`.`name`
`departments`.`sort_order`
`departments`.`created_at`
`departments`.`code`
`departments`.`status`
`departments`.`updated_at`
`employee_approval_roles`.*
`employee_approval_roles`.`id`
`employee_approval_roles`.`employee_id`
`employee_approval_roles`.`role_key`
`employee_approval_roles`.`is_active`
`employee_approval_roles`.`created_at`
`employee_approval_roles`.`updated_at`
`employee_approval_roles`.`role_id`
`employee_comp_leave_balances`.*
`employee_comp_leave_balances`.`id`
`employee_comp_leave_balances`.`employee_id`
`employee_comp_leave_balances`.`transaction_type`
`employee_comp_leave_balances`.`hours`
`employee_comp_leave_balances`.`source_type`
`employee_comp_leave_balances`.`source_id`
`employee_comp_leave_balances`.`note`
`employee_comp_leave_balances`.`created_at`
`employee_feature_permissions`.*
`employee_feature_permissions`.`id`
`employee_feature_permissions`.`employee_id`
`employee_feature_permissions`.`feature_code`
`employee_feature_permissions`.`allowed`
`employee_feature_permissions`.`created_by`
`employee_feature_permissions`.`created_at`
`employee_feature_permissions`.`updated_at`
`employee_insurance_history`.*
`employee_insurance_history`.`id`
`employee_insurance_history`.`employee_id`
`employee_insurance_history`.`labor_insurance_mode`
`employee_insurance_history`.`labor_fixed_deduction`
`employee_insurance_history`.`health_insurance_mode`
`employee_insurance_history`.`health_fixed_deduction`
`employee_insurance_history`.`health_dependents`
`employee_insurance_history`.`change_reason`
`employee_insurance_history`.`note`
`employee_insurance_history`.`created_by`
`employee_insurance_history`.`created_at`
`employee_leave_balances`.*
`employee_leave_balances`.`id`
`employee_leave_balances`.`employee_id`
`employee_leave_balances`.`year`
`employee_leave_balances`.`annual_leave_days`
`employee_leave_balances`.`used_leave_days`
`employee_leave_balances`.`remaining_leave_days`
`employee_leave_balances`.`updated_at`
`employee_leave_balances`.`imported_used_hours`
`employee_leave_balances`.`imported_used_days`
`employee_leave_balances`.`imported_note`
`employee_leave_balances`.`imported_updated_at`
`employee_leave_balances`.`imported_updated_by`
`employee_salary_history`.*
`employee_salary_history`.`id`
`employee_salary_history`.`employee_id`
`employee_salary_history`.`effective_date`
`employee_salary_history`.`base_salary`
`employee_salary_history`.`meal_allowance`
`employee_salary_history`.`change_reason`
`employee_salary_history`.`note`
`employee_salary_history`.`created_by`
`employee_salary_history`.`created_at`
`employee_salary_settings`.*
`employee_salary_settings`.`id`
`employee_salary_settings`.`employee_id`
`employee_salary_settings`.`base_salary`
`employee_salary_settings`.`meal_allowance`
`employee_salary_settings`.`default_work_days`
`employee_salary_settings`.`is_active`
`employee_salary_settings`.`note`
`employee_salary_settings`.`created_at`
`employee_salary_settings`.`updated_at`
`employees`.*
`employees`.`id`
`employees`.`employee_no`
`employees`.`name`
`employees`.`english_name`
`employees`.`quote_owner_code`
`employees`.`department_id`
`employees`.`position`
`employees`.`email`
`employees`.`tel`
`employees`.`ext`
`employees`.`mobile`
`employees`.`hire_date`
`employees`.`resign_date`
`employees`.`status`
`employees`.`emergency_contact`
`employees`.`emergency_phone`
`employees`.`address`
`employees`.`photo_path`
`employees`.`note`
`employees`.`user_id`
`employees`.`created_by`
`employees`.`created_at`
`employees`.`updated_at`
`employees`.`sort_order`
`employees`.`manager_id`
`employees`.`position_id`
`employees`.`gender`
`employees`.`birthday`
`employees`.`id_no`
`employees`.`line_id`
`employees`.`nationality`
`employees`.`blood_type`
`employees`.`bank_name`
`employees`.`bank_account`
`employees`.`insurance_no`
`employees`.`labor_insurance_mode`
`employees`.`labor_fixed_deduction`
`employees`.`health_insurance_mode`
`employees`.`health_fixed_deduction`
`employees`.`health_dependents`
`employees`.`annual_leave_policy`
`employees`.`annual_leave_extra_days`
`employees`.`annual_leave_extra_note`
`employees`.`company_email`
`erp_feature_categories`.*
`erp_feature_categories`.`id`
`erp_feature_categories`.`category_key`
`erp_feature_categories`.`category_name`
`erp_feature_categories`.`icon_class`
`erp_feature_categories`.`sort_order`
`erp_feature_categories`.`is_active`
`erp_feature_categories`.`created_at`
`erp_feature_categories`.`updated_at`
`erp_feature_menu_settings`.*
`erp_feature_menu_settings`.`feature_code`
`erp_feature_menu_settings`.`category_id`
`erp_feature_menu_settings`.`sort_order`
`erp_feature_menu_settings`.`icon_class`
`erp_feature_menu_settings`.`show_sidebar`
`erp_feature_menu_settings`.`show_mobile`
`erp_feature_menu_settings`.`dashboard_visible`
`erp_feature_menu_settings`.`updated_at`
`erp_features`.*
`erp_features`.`id`
`erp_features`.`feature_code`
`erp_features`.`feature_name`
`erp_features`.`feature_group`
`erp_features`.`sort_order`
`erp_features`.`is_active`
`erp_features`.`created_at`
`erp_features`.`updated_at`
`erp_features`.`feature_color`
`erp_features`.`mobile_visible`
`erp_features`.`dashboard_visible`
`exchange_rates`.*
`exchange_rates`.`currency`
`exchange_rates`.`rate`
`exchange_rates`.`note`
`exchange_rates`.`updated_by`
`exchange_rates`.`updated_at`
`expense_applications`.*
`expense_applications`.`id`
`expense_applications`.`application_no`
`expense_applications`.`applicant_user_id`
`expense_applications`.`applicant_employee_id`
`expense_applications`.`applicant_name`
`expense_applications`.`department_id`
`expense_applications`.`department_name`
`expense_applications`.`period_start`
`expense_applications`.`period_end`
`expense_applications`.`apply_date`
`expense_applications`.`status`
`expense_applications`.`total_amount`
`expense_applications`.`note`
`expense_applications`.`submitted_at`
`expense_applications`.`admin_review_by`
`expense_applications`.`admin_review_at`
`expense_applications`.`admin_review_note`
`expense_applications`.`gm_approve_by`
`expense_applications`.`gm_approve_at`
`expense_applications`.`gm_approve_note`
`expense_applications`.`paid_at`
`expense_applications`.`paid_by`
`expense_applications`.`created_by`
`expense_applications`.`created_at`
`expense_applications`.`updated_at`
`expense_approval_logs`.*
`expense_approval_logs`.`id`
`expense_approval_logs`.`application_id`
`expense_approval_logs`.`action`
`expense_approval_logs`.`action_by`
`expense_approval_logs`.`action_at`
`expense_approval_logs`.`note`
`expense_item_receipts`.*
`expense_item_receipts`.`id`
`expense_item_receipts`.`item_id`
`expense_item_receipts`.`application_id`
`expense_item_receipts`.`file_path`
`expense_item_receipts`.`file_name`
`expense_item_receipts`.`uploaded_by`
`expense_item_receipts`.`uploaded_at`
`expense_items`.*
`expense_items`.`id`
`expense_items`.`application_id`
`expense_items`.`expense_date`
`expense_items`.`description`
`expense_items`.`local_currency`
`expense_items`.`exchange_rate`
`expense_items`.`category`
`expense_items`.`local_amount`
`expense_items`.`amount_twd`
`expense_items`.`remark_no`
`expense_items`.`note`
`expense_items`.`sort_order`
`expense_items`.`created_at`
`feature_categories`.*
`feature_categories`.`id`
`feature_categories`.`category_name`
`feature_categories`.`sort_order`
`feature_categories`.`icon`
`feature_categories`.`category_status`
`feature_categories`.`category_color`
`feature_categories`.`homepage_visible`
`feature_categories`.`mobile_visible`
`inventory`.*
`inventory`.`id`
`inventory`.`item_name`
`inventory`.`qty`
`inventory`.`created_at`
`inventory_demand_order_items`.*
`inventory_demand_order_items`.`id`
`inventory_demand_order_items`.`demand_order_id`
`inventory_demand_order_items`.`finished_product_id`
`inventory_demand_order_items`.`qty`
`inventory_demand_order_items`.`created_at`
`inventory_demand_orders`.*
`inventory_demand_orders`.`id`
`inventory_demand_orders`.`order_no`
`inventory_demand_orders`.`customer_name`
`inventory_demand_orders`.`demand_type`
`inventory_demand_orders`.`probability`
`inventory_demand_orders`.`expected_delivery_date`
`inventory_demand_orders`.`status`
`inventory_demand_orders`.`remark`
`inventory_demand_orders`.`created_by`
`inventory_demand_orders`.`created_at`
`inventory_demand_orders`.`updated_at`
`inventory_receipts`.*
`inventory_receipts`.`id`
`inventory_receipts`.`receipt_no`
`inventory_receipts`.`project_no`
`inventory_receipts`.`purchase_order_no`
`inventory_receipts`.`item_name`
`inventory_receipts`.`qty`
`inventory_receipts`.`location`
`inventory_receipts`.`status`
`inventory_receipts`.`created_at`
`inventory_receipts`.`updated_at`
`inventory_sku_categories`.*
`inventory_sku_categories`.`id`
`inventory_sku_categories`.`code`
`inventory_sku_categories`.`name`
`inventory_sku_categories`.`sort_order`
`inventory_sku_categories`.`is_active`
`inventory_sku_categories`.`created_at`
`inventory_sku_categories`.`updated_at`
`inventory_sku_lines`.*
`inventory_sku_lines`.`id`
`inventory_sku_lines`.`code`
`inventory_sku_lines`.`name`
`inventory_sku_lines`.`sort_order`
`inventory_sku_lines`.`is_active`
`inventory_sku_lines`.`created_at`
`inventory_sku_lines`.`updated_at`
`inventory_sku_origins`.*
`inventory_sku_origins`.`id`
`inventory_sku_origins`.`code`
`inventory_sku_origins`.`name`
`inventory_sku_origins`.`sort_order`
`inventory_sku_origins`.`is_active`
`inventory_sku_origins`.`created_at`
`inventory_sku_origins`.`updated_at`
`inventory_transactions`.*
`inventory_transactions`.`id`
`inventory_transactions`.`product_id`
`inventory_transactions`.`type`
`inventory_transactions`.`qty`
`inventory_transactions`.`before_stock`
`inventory_transactions`.`after_stock`
`inventory_transactions`.`customer_name`
`inventory_transactions`.`serial_number`
`inventory_transactions`.`location`
`inventory_transactions`.`note`
`inventory_transactions`.`created_by`
`inventory_transactions`.`created_at`
`inventory_transactions`.`project_id`
`inventory_transactions`.`transaction_type`
`invoice_applications`.*
`invoice_applications`.`id`
`invoice_applications`.`invoice_request_no`
`invoice_applications`.`applicant_id`
`invoice_applications`.`project_no`
`invoice_applications`.`customer_name`
`invoice_applications`.`invoice_type`
`invoice_applications`.`billing_percent`
`invoice_applications`.`amount`
`invoice_applications`.`description`
`invoice_applications`.`status`
`invoice_applications`.`manager_approver_id`
`invoice_applications`.`admin_issuer_id`
`invoice_applications`.`invoice_no`
`invoice_applications`.`invoice_file`
`invoice_applications`.`issued_at`
`invoice_applications`.`project_billing_completed`
`invoice_applications`.`created_at`
`invoice_applications`.`updated_at`
`leave_applications`.*
`leave_applications`.`id`
`leave_applications`.`employee_id`
`leave_applications`.`leave_type`
`leave_applications`.`start_date`
`leave_applications`.`start_time`
`leave_applications`.`end_date`
`leave_applications`.`end_time`
`leave_applications`.`days`
`leave_applications`.`reason`
`leave_applications`.`status`
`leave_applications`.`approved_by`
`leave_applications`.`approved_at`
`leave_applications`.`rejected_reason`
`leave_applications`.`created_at`
`leave_applications`.`leave_type_id`
`leave_applications`.`hours`
`leave_applications_backup_before_clean`.*
`leave_applications_backup_before_clean`.`id`
`leave_applications_backup_before_clean`.`employee_id`
`leave_applications_backup_before_clean`.`leave_type`
`leave_applications_backup_before_clean`.`start_date`
`leave_applications_backup_before_clean`.`start_time`
`leave_applications_backup_before_clean`.`end_date`
`leave_applications_backup_before_clean`.`end_time`
`leave_applications_backup_before_clean`.`days`
`leave_applications_backup_before_clean`.`reason`
`leave_applications_backup_before_clean`.`status`
`leave_applications_backup_before_clean`.`approved_by`
`leave_applications_backup_before_clean`.`approved_at`
`leave_applications_backup_before_clean`.`rejected_reason`
`leave_applications_backup_before_clean`.`created_at`
`leave_applications_backup_before_clean`.`leave_type_id`
`leave_applications_backup_before_clean`.`hours`
`leave_types`.*
`leave_types`.`id`
`leave_types`.`name`
`leave_types`.`is_annual_leave`
`leave_types`.`deduct_annual_leave`
`leave_types`.`is_active`
`leave_types`.`sort_order`
`overtime_applications`.*
`overtime_applications`.`id`
`overtime_applications`.`employee_id`
`overtime_applications`.`overtime_date`
`overtime_applications`.`end_date`
`overtime_applications`.`start_time`
`overtime_applications`.`end_time`
`overtime_applications`.`hours`
`overtime_applications`.`day_type`
`overtime_applications`.`ot_134_hours`
`overtime_applications`.`ot_167_hours`
`overtime_applications`.`ot_200_hours`
`overtime_applications`.`ot_267_hours`
`overtime_applications`.`reason`
`overtime_applications`.`status`
`overtime_applications`.`approved_by`
`overtime_applications`.`approved_at`
`overtime_applications`.`rejected_reason`
`overtime_applications`.`created_at`
`payroll_brackets`.*
`payroll_brackets`.`id`
`payroll_brackets`.`bracket_type`
`payroll_brackets`.`salary_min`
`payroll_brackets`.`insured_amount`
`payroll_brackets`.`effective_year`
`payroll_brackets`.`created_at`
`payroll_holidays`.*
`payroll_holidays`.`id`
`payroll_holidays`.`holiday_date`
`payroll_holidays`.`holiday_name`
`payroll_holidays`.`holiday_type`
`payroll_holidays`.`created_at`
`payroll_records`.*
`payroll_records`.`id`
`payroll_records`.`payroll_month`
`payroll_records`.`employee_id`
`payroll_records`.`base_salary`
`payroll_records`.`meal_allowance`
`payroll_records`.`total_salary`
`payroll_records`.`work_days`
`payroll_records`.`is_full_month`
`payroll_records`.`calc_start_date`
`payroll_records`.`calc_end_date`
`payroll_records`.`payable_salary`
`payroll_records`.`labor_insured_amount`
`payroll_records`.`health_insured_amount`
`payroll_records`.`overtime_133_hours`
`payroll_records`.`overtime_166_hours`
`payroll_records`.`overtime_200_hours`
`payroll_records`.`overtime_267_hours`
`payroll_records`.`overtime_pay`
`payroll_records`.`annual_leave_cashout`
`payroll_records`.`paid_leave_hours`
`payroll_records`.`personal_leave_hours`
`payroll_records`.`sick_leave_half_hours`
`payroll_records`.`personal_leave_deduction`
`payroll_records`.`sick_leave_deduction`
`payroll_records`.`labor_insurance_mode`
`payroll_records`.`health_insurance_mode`
`payroll_records`.`labor_deduction`
`payroll_records`.`health_dependents`
`payroll_records`.`health_deduction`
`payroll_records`.`net_salary`
`payroll_records`.`note`
`payroll_records`.`status`
`payroll_records`.`created_by`
`payroll_records`.`created_at`
`payroll_records`.`updated_at`
`position_feature_permissions`.*
`position_feature_permissions`.`id`
`position_feature_permissions`.`position_id`
`position_feature_permissions`.`feature_code`
`position_feature_permissions`.`allowed`
`position_feature_permissions`.`created_by`
`position_feature_permissions`.`created_at`
`position_feature_permissions`.`updated_at`
`positions`.*
`positions`.`id`
`positions`.`department_id`
`positions`.`name`
`positions`.`level_no`
`positions`.`created_at`
`product_bom_items`.*
`product_bom_items`.`id`
`product_bom_items`.`bom_id`
`product_bom_items`.`component_product_id`
`product_bom_items`.`qty_per`
`product_bom_items`.`loss_rate`
`product_bom_items`.`note`
`product_bom_items`.`sort_order`
`product_bom_items`.`created_at`
`product_boms`.*
`product_boms`.`id`
`product_boms`.`finished_product_id`
`product_boms`.`bom_name`
`product_boms`.`version`
`product_boms`.`status`
`product_boms`.`remark`
`product_boms`.`created_by`
`product_boms`.`created_at`
`product_boms`.`updated_at`
`product_categories`.*
`product_categories`.`id`
`product_categories`.`name`
`product_categories`.`sort_order`
`product_categories`.`created_at`
`product_inventory`.*
`product_inventory`.`product_id`
`product_inventory`.`qty`
`product_inventory`.`updated_at`
`product_inventory_transactions`.*
`product_inventory_transactions`.`id`
`product_inventory_transactions`.`product_id`
`product_inventory_transactions`.`transaction_type`
`product_inventory_transactions`.`qty`
`product_inventory_transactions`.`related_bom_id`
`product_inventory_transactions`.`note`
`product_inventory_transactions`.`created_by`
`product_inventory_transactions`.`created_at`
`product_serials`.*
`product_serials`.`id`
`product_serials`.`product_id`
`product_serials`.`serial_type`
`product_serials`.`serial_number`
`product_serials`.`sensor_serial_id`
`product_serials`.`sensor_serial_number`
`product_serials`.`status`
`product_serials`.`location`
`product_serials`.`customer_name`
`product_serials`.`note`
`product_serials`.`assembled_at`
`product_serials`.`created_by`
`product_serials`.`void_reason`
`product_serials`.`void_by`
`product_serials`.`void_at`
`product_serials`.`shipped_at`
`product_serials`.`shipment_no`
`product_serials`.`created_at`
`product_serials`.`updated_at`
`products`.*
`products`.`id`
`products`.`sku`
`products`.`model`
`products`.`category_id`
`products`.`brand`
`products`.`supplier`
`products`.`manufacturer_part_no`
`products`.`name_tw`
`products`.`name_en`
`products`.`name_cn`
`products`.`description_tw`
`products`.`description_en`
`products`.`description_cn`
`products`.`spec_tw`
`products`.`spec_en`
`products`.`spec_cn`
`products`.`unit`
`products`.`currency`
`products`.`sale_price`
`products`.`cost_price`
`products`.`stock_qty`
`products`.`safety_stock`
`products`.`lead_time_days`
`products`.`status`
`products`.`item_type`
`products`.`image_path`
`products`.`catalog_path`
`products`.`remark`
`products`.`created_at`
`products`.`updated_at`
`project_applications`.*
`project_applications`.`id`
`project_applications`.`request_no`
`project_applications`.`applicant_id`
`project_applications`.`customer_name`
`project_applications`.`order_no`
`project_applications`.`quotation_no`
`project_applications`.`project_name`
`project_applications`.`amount`
`project_applications`.`payment_terms`
`project_applications`.`description`
`project_applications`.`status`
`project_applications`.`admin_reviewer_id`
`project_applications`.`reviewed_by`
`project_applications`.`reviewed_at`
`project_applications`.`project_no`
`project_applications`.`reject_reason`
`project_applications`.`created_at`
`project_applications`.`updated_at`
`project_applications`.`apply_date`
`project_applications`.`category_code`
`project_applications`.`customer_id`
`project_applications`.`quotation_id`
`project_applications`.`order_amount`
`project_applications`.`currency`
`project_applications`.`owner`
`project_applications`.`note`
`project_applications`.`order_file`
`project_applications`.`quote_file`
`project_applications`.`cost_file`
`project_applications`.`project_case_id`
`project_approvals`.*
`project_approvals`.`id`
`project_approvals`.`project_id`
`project_approvals`.`step_name`
`project_approvals`.`approver`
`project_approvals`.`status`
`project_approvals`.`comment`
`project_approvals`.`approved_at`
`project_approvals`.`created_at`
`project_cases`.*
`project_cases`.`id`
`project_cases`.`project_no`
`project_cases`.`apply_date`
`project_cases`.`category_code`
`project_cases`.`project_name`
`project_cases`.`customer_id`
`project_cases`.`quotation_id`
`project_cases`.`order_no`
`project_cases`.`order_amount`
`project_cases`.`currency`
`project_cases`.`exchange_rate`
`project_cases`.`owner`
`project_cases`.`status`
`project_cases`.`total_cost`
`project_cases`.`invoice_percent_done`
`project_cases`.`order_file`
`project_cases`.`quote_file`
`project_cases`.`cost_file`
`project_cases`.`note`
`project_cases`.`created_by`
`project_cases`.`closed_at`
`project_cases`.`created_at`
`project_cases`.`updated_at`
`project_cases_backup_20260615`.*
`project_cases_backup_20260615`.`id`
`project_cases_backup_20260615`.`project_no`
`project_cases_backup_20260615`.`apply_date`
`project_cases_backup_20260615`.`category_code`
`project_cases_backup_20260615`.`project_name`
`project_cases_backup_20260615`.`customer_id`
`project_cases_backup_20260615`.`quotation_id`
`project_cases_backup_20260615`.`order_no`
`project_cases_backup_20260615`.`order_amount`
`project_cases_backup_20260615`.`currency`
`project_cases_backup_20260615`.`exchange_rate`
`project_cases_backup_20260615`.`owner`
`project_cases_backup_20260615`.`status`
`project_cases_backup_20260615`.`total_cost`
`project_cases_backup_20260615`.`invoice_percent_done`
`project_cases_backup_20260615`.`order_file`
`project_cases_backup_20260615`.`quote_file`
`project_cases_backup_20260615`.`cost_file`
`project_cases_backup_20260615`.`note`
`project_cases_backup_20260615`.`created_by`
`project_cases_backup_20260615`.`closed_at`
`project_cases_backup_20260615`.`created_at`
`project_cases_backup_20260615`.`updated_at`
`project_categories`.*
`project_categories`.`category_code`
`project_categories`.`category_name`
`project_categories`.`sort_order`
`project_categories`.`is_active`
`project_category_allocations`.*
`project_category_allocations`.`id`
`project_category_allocations`.`project_id`
`project_category_allocations`.`category_code`
`project_category_allocations`.`amount`
`project_category_allocations`.`percent`
`project_category_allocations`.`currency`
`project_category_allocations`.`note`
`project_category_allocations`.`created_by`
`project_category_allocations`.`created_at`
`project_category_allocations`.`updated_at`
`project_costs`.*
`project_costs`.`id`
`project_costs`.`project_id`
`project_costs`.`cost_date`
`project_costs`.`department`
`project_costs`.`item_name`
`project_costs`.`amount`
`project_costs`.`note`
`project_costs`.`created_by`
`project_costs`.`created_at`
`project_invoices`.*
`project_invoices`.`id`
`project_invoices`.`project_id`
`project_invoices`.`receivable_schedule_id`
`project_invoices`.`invoice_date`
`project_invoices`.`invoice_percent`
`project_invoices`.`amount`
`project_invoices`.`invoice_no`
`project_invoices`.`application_no`
`project_invoices`.`status`
`project_invoices`.`note`
`project_invoices`.`created_by`
`project_invoices`.`created_at`
`project_invoices`.`application_status`
`project_invoices`.`applicant`
`project_invoices`.`applicant_employee_id`
`project_invoices`.`submitted_at`
`project_invoices`.`admin_checked_by`
`project_invoices`.`admin_checked_at`
`project_invoices`.`admin_checked_note`
`project_invoices`.`gm_approved_by`
`project_invoices`.`gm_approved_at`
`project_invoices`.`gm_approved_note`
`project_invoices`.`issued_by`
`project_invoices`.`issued_at`
`project_invoices`.`issued_note`
`project_invoices`.`rejected_by`
`project_invoices`.`rejected_at`
`project_invoices`.`rejected_note`
`project_invoices`.`due_date`
`project_invoices`.`currency`
`project_invoices`.`exchange_rate`
`project_invoices`.`invoice_amount`
`project_invoices`.`tax_amount`
`project_invoices`.`total_amount`
`project_invoices`.`paid_amount`
`project_invoices`.`updated_at`
`project_no_applications`.*
`project_no_applications`.`id`
`project_no_applications`.`request_no`
`project_no_applications`.`applicant_id`
`project_no_applications`.`customer_name`
`project_no_applications`.`order_no`
`project_no_applications`.`project_name`
`project_no_applications`.`amount`
`project_no_applications`.`description`
`project_no_applications`.`status`
`project_no_applications`.`admin_reviewer_id`
`project_no_applications`.`project_no`
`project_no_applications`.`created_at`
`project_no_applications`.`updated_at`
`project_no_applications_backup_20260615`.*
`project_no_applications_backup_20260615`.`id`
`project_no_applications_backup_20260615`.`request_no`
`project_no_applications_backup_20260615`.`applicant_id`
`project_no_applications_backup_20260615`.`customer_name`
`project_no_applications_backup_20260615`.`order_no`
`project_no_applications_backup_20260615`.`project_name`
`project_no_applications_backup_20260615`.`amount`
`project_no_applications_backup_20260615`.`description`
`project_no_applications_backup_20260615`.`status`
`project_no_applications_backup_20260615`.`admin_reviewer_id`
`project_no_applications_backup_20260615`.`project_no`
`project_no_applications_backup_20260615`.`created_at`
`project_no_applications_backup_20260615`.`updated_at`
`project_order_items`.*
`project_order_items`.`id`
`project_order_items`.`project_id`
`project_order_items`.`quotation_item_id`
`project_order_items`.`product_id`
`project_order_items`.`item_name`
`project_order_items`.`model`
`project_order_items`.`description`
`project_order_items`.`qty`
`project_order_items`.`unit`
`project_order_items`.`unit_price`
`project_order_items`.`discount_rate`
`project_order_items`.`amount`
`project_order_items`.`currency`
`project_order_items`.`category_code`
`project_order_items`.`sort_order`
`project_order_items`.`created_at`
`project_order_items`.`updated_at`
`project_payments`.*
`project_payments`.`id`
`project_payments`.`invoice_id`
`project_payments`.`project_id`
`project_payments`.`payment_date`
`project_payments`.`currency`
`project_payments`.`payment_amount`
`project_payments`.`payment_method`
`project_payments`.`reference_no`
`project_payments`.`note`
`project_payments`.`created_by`
`project_payments`.`created_at`
`project_receivable_schedules`.*
`project_receivable_schedules`.`id`
`project_receivable_schedules`.`project_id`
`project_receivable_schedules`.`order_id`
`project_receivable_schedules`.`schedule_name`
`project_receivable_schedules`.`billing_type`
`project_receivable_schedules`.`percent`
`project_receivable_schedules`.`amount`
`project_receivable_schedules`.`currency`
`project_receivable_schedules`.`exchange_rate`
`project_receivable_schedules`.`base_date_type`
`project_receivable_schedules`.`offset_days`
`project_receivable_schedules`.`expected_due_date`
`project_receivable_schedules`.`invoice_id`
`project_receivable_schedules`.`status`
`project_receivable_schedules`.`note`
`project_receivable_schedules`.`created_by`
`project_receivable_schedules`.`created_at`
`project_receivable_schedules`.`updated_at`
`projects`.*
`projects`.`id`
`projects`.`project_name`
`projects`.`project_manager`
`projects`.`start_date`
`projects`.`end_date`
`projects`.`status`
`projects`.`created_at`
`projects`.`customer_id`
`projects`.`quotation_id`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`purchase_order_no`
`purchase_orders`.`purchase_request_id`
`purchase_orders`.`project_no`
`purchase_orders`.`supplier_name`
`purchase_orders`.`amount`
`purchase_orders`.`delivery_date`
`purchase_orders`.`payment_terms`
`purchase_orders`.`status`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`purchase_orders`.`currency`
`purchase_orders`.`exchange_rate`
`purchase_requests`.*
`purchase_requests`.`id`
`purchase_requests`.`request_no`
`purchase_requests`.`project_id`
`purchase_requests`.`applicant_id`
`purchase_requests`.`project_no`
`purchase_requests`.`project_name`
`purchase_requests`.`supplier_name`
`purchase_requests`.`item_summary`
`purchase_requests`.`amount`
`purchase_requests`.`currency`
`purchase_requests`.`exchange_rate`
`purchase_requests`.`negotiated_amount`
`purchase_requests`.`delivery_date`
`purchase_requests`.`payment_terms`
`purchase_requests`.`remark`
`purchase_requests`.`quote_file`
`purchase_requests`.`required_date`
`purchase_requests`.`negotiation_notes`
`purchase_requests`.`status`
`purchase_requests`.`manager_approver_id`
`purchase_requests`.`gm_approver_id`
`purchase_requests`.`gm_approved_at`
`purchase_requests`.`gm_comment`
`purchase_requests`.`admin_handler_id`
`purchase_requests`.`admin_negotiator_id`
`purchase_requests`.`purchase_order_no`
`purchase_requests`.`ordered_at`
`purchase_requests`.`created_at`
`purchase_requests`.`updated_at`
`quotation_items`.*
`quotation_items`.`id`
`quotation_items`.`quotation_id`
`quotation_items`.`product_id`
`quotation_items`.`product_name`
`quotation_items`.`model`
`quotation_items`.`description`
`quotation_items`.`qty`
`quotation_items`.`unit`
`quotation_items`.`unit_price`
`quotation_items`.`discount_rate`
`quotation_items`.`category_code`
`quotation_items`.`line_total`
`quotation_items`.`sort_order`
`quotations`.*
`quotations`.`id`
`quotations`.`quote_no`
`quotations`.`customer_id`
`quotations`.`quote_date`
`quotations`.`valid_until`
`quotations`.`currency`
`quotations`.`tax_rate`
`quotations`.`discount_amount`
`quotations`.`subtotal`
`quotations`.`tax_amount`
`quotations`.`total_amount`
`quotations`.`special_price_enabled`
`quotations`.`special_price_label`
`quotations`.`special_price_amount`
`quotations`.`special_price_tax_included`
`quotations`.`status`
`quotations`.`note`
`quotations`.`terms`
`quotations`.`created_by`
`quotations`.`created_at`
`quotations`.`updated_at`
`quotations`.`project_id`
`quotations`.`parent_quotation_id`
`quotations`.`version_no`
`quotations`.`is_latest`
`quotations`.`revision_reason`
`quotations`.`replaced_by_id`
`quotations`.`source_quote_id`
`rbac_permissions`.*
`rbac_permissions`.`id`
`rbac_permissions`.`permission_key`
`rbac_permissions`.`permission_name`
`rbac_permissions`.`module_name`
`rbac_permissions`.`description`
`rbac_permissions`.`sort_order`
`rbac_permissions`.`created_at`
`rbac_role_permissions`.*
`rbac_role_permissions`.`id`
`rbac_role_permissions`.`role_id`
`rbac_role_permissions`.`permission_id`
`rbac_role_permissions`.`created_at`
`rbac_roles`.*
`rbac_roles`.`id`
`rbac_roles`.`role_key`
`rbac_roles`.`role_name`
`rbac_roles`.`description`
`rbac_roles`.`is_system`
`rbac_roles`.`sort_order`
`rbac_roles`.`created_at`
`rbac_user_roles`.*
`rbac_user_roles`.`id`
`rbac_user_roles`.`user_id`
`rbac_user_roles`.`role_id`
`rbac_user_roles`.`created_at`
`sales_forecast_followups`.*
`sales_forecast_followups`.`id`
`sales_forecast_followups`.`forecast_id`
`sales_forecast_followups`.`followup_date`
`sales_forecast_followups`.`followup_type`
`sales_forecast_followups`.`content`
`sales_forecast_followups`.`next_followup_date`
`sales_forecast_followups`.`created_by`
`sales_forecast_followups`.`created_at`
`sales_forecasts`.*
`sales_forecasts`.`id`
`sales_forecasts`.`forecast_no`
`sales_forecasts`.`owner_name`
`sales_forecasts`.`owner_employee_id`
`sales_forecasts`.`customer_id`
`sales_forecasts`.`company_name`
`sales_forecasts`.`contact_name`
`sales_forecasts`.`contact_phone`
`sales_forecasts`.`contact_email`
`sales_forecasts`.`project_name`
`sales_forecasts`.`product_name`
`sales_forecasts`.`source`
`sales_forecasts`.`stage`
`sales_forecasts`.`status`
`sales_forecasts`.`probability`
`sales_forecasts`.`currency`
`sales_forecasts`.`cost_amount`
`sales_forecasts`.`sales_amount`
`sales_forecasts`.`gross_profit`
`sales_forecasts`.`gross_margin`
`sales_forecasts`.`weighted_amount`
`sales_forecasts`.`expected_order_date`
`sales_forecasts`.`expected_start_date`
`sales_forecasts`.`expected_finish_date`
`sales_forecasts`.`next_followup_date`
`sales_forecasts`.`quotation_id`
`sales_forecasts`.`order_id`
`sales_forecasts`.`project_id`
`sales_forecasts`.`description`
`sales_forecasts`.`last_followup_note`
`sales_forecasts`.`created_by`
`sales_forecasts`.`updated_by`
`sales_forecasts`.`created_at`
`sales_forecasts`.`updated_at`
`service_cases`.*
`service_cases`.`id`
`service_cases`.`case_no`
`service_cases`.`case_date`
`service_cases`.`customer_id`
`service_cases`.`product_id`
`service_cases`.`serial_number`
`service_cases`.`subject`
`service_cases`.`problem_description`
`service_cases`.`solution`
`service_cases`.`status`
`service_cases`.`priority`
`service_cases`.`assigned_to`
`service_cases`.`note`
`service_cases`.`created_by`
`service_cases`.`created_at`
`service_cases`.`updated_at`
`shipment_items`.*
`shipment_items`.`id`
`shipment_items`.`shipment_id`
`shipment_items`.`finished_serial_id`
`shipment_items`.`product_id`
`shipment_items`.`serial_number`
`shipment_items`.`cell_serial_number`
`shipment_items`.`created_at`
`shipments`.*
`shipments`.`id`
`shipments`.`shipment_no`
`shipments`.`customer_id`
`shipments`.`customer_name`
`shipments`.`project_id`
`shipments`.`contact`
`shipments`.`shipping_address`
`shipments`.`order_no`
`shipments`.`project_no`
`shipments`.`shipment_date`
`shipments`.`items`
`shipments`.`status`
`shipments`.`remark`
`shipments`.`created_by`
`shipments`.`created_at`
`shipments`.`updated_at`
`user_quick_features`.*
`user_quick_features`.`id`
`user_quick_features`.`user_id`
`user_quick_features`.`feature_key`
`user_quick_features`.`sort_order`
`user_quick_features`.`created_at`
`user_system_settings`.*
`user_system_settings`.`user_id`
`user_system_settings`.`receive_all_approval_notifications`
`user_system_settings`.`created_at`
`user_system_settings`.`updated_at`
`users`.*
`users`.`id`
`users`.`username`
`users`.`password`
`users`.`password_hash`
`users`.`name`
`users`.`role`
`users`.`status`
`users`.`created_at`
`vw_customer_quote_project`.*
`vw_customer_quote_project`.`customer_id`
`vw_customer_quote_project`.`company_name`
`vw_customer_quote_project`.`quotation_id`
`vw_customer_quote_project`.`quote_no`
`vw_customer_quote_project`.`quotation_status`
`vw_customer_quote_project`.`quotation_amount`
`vw_customer_quote_project`.`project_id`
`vw_customer_quote_project`.`project_no`
`vw_customer_quote_project`.`project_name`
`vw_customer_quote_project`.`project_status`
`vw_customer_quote_project`.`order_amount`
`vw_customer_sales_flow`.*
`vw_customer_sales_flow`.`customer_id`
`vw_customer_sales_flow`.`company_name`
`vw_customer_sales_flow`.`quotation_id`
`vw_customer_sales_flow`.`quotation_status`
`vw_customer_sales_flow`.`project_id`
`vw_customer_sales_flow`.`project_status`
`vw_project_inventory_flow`.*
`vw_project_inventory_flow`.`project_id`
`vw_project_inventory_flow`.`project_status`
`vw_project_inventory_flow`.`transaction_id`
`vw_project_inventory_flow`.`transaction_type`
`vw_project_inventory_flow`.`qty`
`vw_project_inventory_flow`.`note`
`vw_project_inventory_transactions`.*
`vw_project_inventory_transactions`.`project_id`
`vw_project_inventory_transactions`.`project_no`
`vw_project_inventory_transactions`.`project_name`
`vw_project_inventory_transactions`.`transaction_id`
`vw_project_inventory_transactions`.`product_id`
`vw_project_inventory_transactions`.`sku`
`vw_project_inventory_transactions`.`name_tw`
`vw_project_inventory_transactions`.`type`
`vw_project_inventory_transactions`.`qty`
`vw_project_inventory_transactions`.`before_stock`
`vw_project_inventory_transactions`.`after_stock`
`vw_project_inventory_transactions`.`serial_number`
`vw_project_inventory_transactions`.`location`
`vw_project_inventory_transactions`.`created_at`
`workflow_settings`.*
`workflow_settings`.`id`
`workflow_settings`.`setting_key`
`workflow_settings`.`setting_value`
`workflow_settings`.`setting_label`
`workflow_settings`.`created_at`
`workflow_settings`.`updated_at`
`accounts_payable`.*
`accounts_payable`.`id`
`accounts_payable`.`payable_no`
`accounts_payable`.`source_type`
`accounts_payable`.`source_id`
`accounts_payable`.`source_no`
`accounts_payable`.`payee_type`
`accounts_payable`.`payee_name`
`accounts_payable`.`title`
`accounts_payable`.`amount`
`accounts_payable`.`paid_amount`
`accounts_payable`.`currency`
`accounts_payable`.`exchange_rate`
`accounts_payable`.`status`
`accounts_payable`.`due_date`
`accounts_payable`.`paid_at`
`accounts_payable`.`paid_by`
`accounts_payable`.`payment_note`
`accounts_payable`.`note`
`accounts_payable`.`created_by`
`accounts_payable`.`created_at`
`accounts_payable`.`updated_at`
`annual_leave_settlements`.*
`annual_leave_settlements`.`id`
`annual_leave_settlements`.`employee_id`
`annual_leave_settlements`.`leave_year`
`annual_leave_settlements`.`period_start`
`annual_leave_settlements`.`period_end`
`annual_leave_settlements`.`expired_hours`
`annual_leave_settlements`.`expired_days`
`annual_leave_settlements`.`hourly_wage`
`annual_leave_settlements`.`daily_salary`
`annual_leave_settlements`.`settlement_amount`
`annual_leave_settlements`.`status`
`annual_leave_settlements`.`settled_by`
`annual_leave_settlements`.`settled_at`
`annual_leave_settlements`.`note`
`annual_leave_settlements`.`created_at`
`annual_leave_settlements`.`updated_at`
`approval_instance_steps`.*
`approval_instance_steps`.`id`
`approval_instance_steps`.`instance_id`
`approval_instance_steps`.`step_order`
`approval_instance_steps`.`step_name`
`approval_instance_steps`.`approver_employee_id`
`approval_instance_steps`.`status`
`approval_instance_steps`.`action_by_employee_id`
`approval_instance_steps`.`action_by_name`
`approval_instance_steps`.`action_note`
`approval_instance_steps`.`action_at`
`approval_instance_steps`.`created_at`
`approval_instance_steps`.`updated_at`
`approval_instances`.*
`approval_instances`.`id`
`approval_instances`.`workflow_id`
`approval_instances`.`source_type`
`approval_instances`.`source_id`
`approval_instances`.`status`
`approval_instances`.`current_step_order`
`approval_instances`.`created_at`
`approval_instances`.`updated_at`
`approval_items`.*
`approval_items`.`id`
`approval_items`.`form_type`
`approval_items`.`form_id`
`approval_items`.`applicant_id`
`approval_items`.`current_approver_id`
`approval_items`.`status`
`approval_items`.`created_at`
`approval_items`.`updated_at`
`approval_items`.`step_name`
`approval_items`.`sort_order`
`approval_records`.*
`approval_records`.`id`
`approval_records`.`module_type`
`approval_records`.`record_id`
`approval_records`.`approver_id`
`approval_records`.`approval_level`
`approval_records`.`action_status`
`approval_records`.`comments`
`approval_records`.`approved_at`
`approval_roles`.*
`approval_roles`.`id`
`approval_roles`.`role_key`
`approval_roles`.`role_name`
`approval_roles`.`description`
`approval_roles`.`sort_order`
`approval_roles`.`is_active`
`approval_roles`.`created_at`
`approval_roles`.`updated_at`
`approval_rules`.*
`approval_rules`.`id`
`approval_rules`.`form_type`
`approval_rules`.`max_approver_id`
`approval_rules`.`enabled`
`approval_rules`.`created_at`
`approval_workflow_steps`.*
`approval_workflow_steps`.`id`
`approval_workflow_steps`.`workflow_id`
`approval_workflow_steps`.`step_order`
`approval_workflow_steps`.`step_name`
`approval_workflow_steps`.`approver_employee_id`
`approval_workflow_steps`.`approver_type`
`approval_workflow_steps`.`approver_value`
`approval_workflow_steps`.`is_required`
`approval_workflow_steps`.`is_active`
`approval_workflow_steps`.`created_at`
`approval_workflow_steps`.`updated_at`
`approval_workflows`.*
`approval_workflows`.`id`
`approval_workflows`.`workflow_code`
`approval_workflows`.`workflow_name`
`approval_workflows`.`description`
`approval_workflows`.`is_active`
`approval_workflows`.`created_at`
`approval_workflows`.`updated_at`
`attendance_makeup_requests`.*
`attendance_makeup_requests`.`id`
`attendance_makeup_requests`.`request_no`
`attendance_makeup_requests`.`employee_id`
`attendance_makeup_requests`.`attendance_date`
`attendance_makeup_requests`.`makeup_type`
`attendance_makeup_requests`.`requested_clock_in`
`attendance_makeup_requests`.`requested_clock_out`
`attendance_makeup_requests`.`reason`
`attendance_makeup_requests`.`status`
`attendance_makeup_requests`.`manager_approver_id`
`attendance_makeup_requests`.`approved_by`
`attendance_makeup_requests`.`approved_at`
`attendance_makeup_requests`.`rejected_by`
`attendance_makeup_requests`.`rejected_at`
`attendance_makeup_requests`.`approval_note`
`attendance_makeup_requests`.`attendance_record_id`
`attendance_makeup_requests`.`created_at`
`attendance_makeup_requests`.`updated_at`
`attendance_records`.*
`attendance_records`.`id`
`attendance_records`.`employee_id`
`attendance_records`.`attendance_date`
`attendance_records`.`clock_in`
`attendance_records`.`clock_out`
`attendance_records`.`work_hours`
`attendance_records`.`status`
`attendance_records`.`ip_address`
`attendance_records`.`device_info`
`attendance_records`.`created_at`
`attendance_records`.`updated_at`
`attendance_settings`.*
`attendance_settings`.`id`
`attendance_settings`.`work_start_time`
`attendance_settings`.`work_end_time`
`attendance_settings`.`late_grace_minutes`
`attendance_settings`.`early_leave_grace_minutes`
`attendance_settings`.`updated_by`
`attendance_settings`.`created_at`
`attendance_settings`.`updated_at`
`attendance_settings`.`setting_key`
`attendance_settings`.`setting_value`
`attendance_settings`.`setting_label`
`audit_logs`.*
`audit_logs`.`id`
`audit_logs`.`user_id`
`audit_logs`.`username`
`audit_logs`.`table_name`
`audit_logs`.`record_id`
`audit_logs`.`action`
`audit_logs`.`old_data`
`audit_logs`.`new_data`
`audit_logs`.`created_at`
`calibrations`.*
`calibrations`.`id`
`calibrations`.`calibration_no`
`calibrations`.`customer_id`
`calibrations`.`product_id`
`calibrations`.`serial_number`
`calibrations`.`send_date`
`calibrations`.`return_date`
`calibrations`.`certificate_no`
`calibrations`.`expire_date`
`calibrations`.`calibration_vendor`
`calibrations`.`status`
`calibrations`.`note`
`calibrations`.`created_by`
`calibrations`.`created_at`
`calibrations`.`updated_at`
`crm_customer_followups`.*
`crm_customer_followups`.`id`
`crm_customer_followups`.`customer_id`
`crm_customer_followups`.`follow_date`
`crm_customer_followups`.`follow_type`
`crm_customer_followups`.`subject`
`crm_customer_followups`.`content`
`crm_customer_followups`.`next_followup_date`
`crm_customer_followups`.`created_by_user_id`
`crm_customer_followups`.`created_by_name`
`crm_customer_followups`.`created_at`
`customers`.*
`customers`.`id`
`customers`.`company_name`
`customers`.`customer_code`
`customers`.`category`
`customers`.`tax_id`
`customers`.`phone`
`customers`.`email`
`customers`.`country`
`customers`.`city`
`customers`.`website`
`customers`.`address`
`customers`.`remark`
`customers`.`business_card`
`customers`.`created_by_user_id`
`customers`.`created_by_name`
`customers`.`contact_name`
`customers`.`department`
`customers`.`title`
`customers`.`tel`
`customers`.`ext`
`customers`.`mobile`
`customers`.`contact_title`
`customers`.`contact_phone`
`customers`.`contact_email`
`customers`.`status`
`customers`.`customer_tags`
`customers`.`customer_level`
`customers`.`customer_source`
`customers`.`owner_user_id`
`customers`.`owner_name`
`customers`.`last_visit_date`
`customers`.`next_followup_date`
`customers`.`notes`
`customers`.`created_at`
`customers`.`updated_at`
`dashboard_card_preferences`.*
`dashboard_card_preferences`.`id`
`dashboard_card_preferences`.`user_key`
`dashboard_card_preferences`.`card_key`
`dashboard_card_preferences`.`is_visible`
`dashboard_card_preferences`.`sort_order`
`dashboard_card_preferences`.`updated_at`
`department_feature_permissions`.*
`department_feature_permissions`.`id`
`department_feature_permissions`.`department_id`
`department_feature_permissions`.`feature_code`
`department_feature_permissions`.`allowed`
`department_feature_permissions`.`can_view`
`department_feature_permissions`.`can_add`
`department_feature_permissions`.`can_edit`
`department_feature_permissions`.`can_delete`
`department_feature_permissions`.`can_approve`
`department_feature_permissions`.`created_by`
`department_feature_permissions`.`created_at`
`department_feature_permissions`.`updated_at`
`departments`.*
`departments`.`id`
`departments`.`name`
`departments`.`sort_order`
`departments`.`created_at`
`departments`.`code`
`departments`.`status`
`departments`.`updated_at`
`employee_approval_roles`.*
`employee_approval_roles`.`id`
`employee_approval_roles`.`employee_id`
`employee_approval_roles`.`role_key`
`employee_approval_roles`.`is_active`
`employee_approval_roles`.`created_at`
`employee_approval_roles`.`updated_at`
`employee_approval_roles`.`role_id`
`employee_comp_leave_balances`.*
`employee_comp_leave_balances`.`id`
`employee_comp_leave_balances`.`employee_id`
`employee_comp_leave_balances`.`transaction_type`
`employee_comp_leave_balances`.`hours`
`employee_comp_leave_balances`.`source_type`
`employee_comp_leave_balances`.`source_id`
`employee_comp_leave_balances`.`note`
`employee_comp_leave_balances`.`created_at`
`employee_feature_permissions`.*
`employee_feature_permissions`.`id`
`employee_feature_permissions`.`employee_id`
`employee_feature_permissions`.`feature_code`
`employee_feature_permissions`.`allowed`
`employee_feature_permissions`.`created_by`
`employee_feature_permissions`.`created_at`
`employee_feature_permissions`.`updated_at`
`employee_insurance_history`.*
`employee_insurance_history`.`id`
`employee_insurance_history`.`employee_id`
`employee_insurance_history`.`labor_insurance_mode`
`employee_insurance_history`.`labor_fixed_deduction`
`employee_insurance_history`.`health_insurance_mode`
`employee_insurance_history`.`health_fixed_deduction`
`employee_insurance_history`.`health_dependents`
`employee_insurance_history`.`change_reason`
`employee_insurance_history`.`note`
`employee_insurance_history`.`created_by`
`employee_insurance_history`.`created_at`
`employee_leave_balances`.*
`employee_leave_balances`.`id`
`employee_leave_balances`.`employee_id`
`employee_leave_balances`.`year`
`employee_leave_balances`.`annual_leave_days`
`employee_leave_balances`.`used_leave_days`
`employee_leave_balances`.`remaining_leave_days`
`employee_leave_balances`.`updated_at`
`employee_leave_balances`.`imported_used_hours`
`employee_leave_balances`.`imported_used_days`
`employee_leave_balances`.`imported_note`
`employee_leave_balances`.`imported_updated_at`
`employee_leave_balances`.`imported_updated_by`
`employee_salary_history`.*
`employee_salary_history`.`id`
`employee_salary_history`.`employee_id`
`employee_salary_history`.`effective_date`
`employee_salary_history`.`base_salary`
`employee_salary_history`.`meal_allowance`
`employee_salary_history`.`change_reason`
`employee_salary_history`.`note`
`employee_salary_history`.`created_by`
`employee_salary_history`.`created_at`
`employee_salary_settings`.*
`employee_salary_settings`.`id`
`employee_salary_settings`.`employee_id`
`employee_salary_settings`.`base_salary`
`employee_salary_settings`.`meal_allowance`
`employee_salary_settings`.`default_work_days`
`employee_salary_settings`.`is_active`
`employee_salary_settings`.`note`
`employee_salary_settings`.`created_at`
`employee_salary_settings`.`updated_at`
`employees`.*
`employees`.`id`
`employees`.`employee_no`
`employees`.`name`
`employees`.`english_name`
`employees`.`quote_owner_code`
`employees`.`department_id`
`employees`.`position`
`employees`.`email`
`employees`.`tel`
`employees`.`ext`
`employees`.`mobile`
`employees`.`hire_date`
`employees`.`resign_date`
`employees`.`status`
`employees`.`emergency_contact`
`employees`.`emergency_phone`
`employees`.`address`
`employees`.`photo_path`
`employees`.`note`
`employees`.`user_id`
`employees`.`created_by`
`employees`.`created_at`
`employees`.`updated_at`
`employees`.`sort_order`
`employees`.`manager_id`
`employees`.`position_id`
`employees`.`gender`
`employees`.`birthday`
`employees`.`id_no`
`employees`.`line_id`
`employees`.`nationality`
`employees`.`blood_type`
`employees`.`bank_name`
`employees`.`bank_account`
`employees`.`insurance_no`
`employees`.`labor_insurance_mode`
`employees`.`labor_fixed_deduction`
`employees`.`health_insurance_mode`
`employees`.`health_fixed_deduction`
`employees`.`health_dependents`
`employees`.`annual_leave_policy`
`employees`.`annual_leave_extra_days`
`employees`.`annual_leave_extra_note`
`employees`.`company_email`
`erp_feature_categories`.*
`erp_feature_categories`.`id`
`erp_feature_categories`.`category_key`
`erp_feature_categories`.`category_name`
`erp_feature_categories`.`icon_class`
`erp_feature_categories`.`sort_order`
`erp_feature_categories`.`is_active`
`erp_feature_categories`.`created_at`
`erp_feature_categories`.`updated_at`
`erp_feature_menu_settings`.*
`erp_feature_menu_settings`.`feature_code`
`erp_feature_menu_settings`.`category_id`
`erp_feature_menu_settings`.`sort_order`
`erp_feature_menu_settings`.`icon_class`
`erp_feature_menu_settings`.`show_sidebar`
`erp_feature_menu_settings`.`show_mobile`
`erp_feature_menu_settings`.`dashboard_visible`
`erp_feature_menu_settings`.`updated_at`
`erp_features`.*
`erp_features`.`id`
`erp_features`.`feature_code`
`erp_features`.`feature_name`
`erp_features`.`feature_group`
`erp_features`.`sort_order`
`erp_features`.`is_active`
`erp_features`.`created_at`
`erp_features`.`updated_at`
`erp_features`.`feature_color`
`erp_features`.`mobile_visible`
`erp_features`.`dashboard_visible`
`exchange_rates`.*
`exchange_rates`.`currency`
`exchange_rates`.`rate`
`exchange_rates`.`note`
`exchange_rates`.`updated_by`
`exchange_rates`.`updated_at`
`expense_applications`.*
`expense_applications`.`id`
`expense_applications`.`application_no`
`expense_applications`.`applicant_user_id`
`expense_applications`.`applicant_employee_id`
`expense_applications`.`applicant_name`
`expense_applications`.`department_id`
`expense_applications`.`department_name`
`expense_applications`.`period_start`
`expense_applications`.`period_end`
`expense_applications`.`apply_date`
`expense_applications`.`status`
`expense_applications`.`total_amount`
`expense_applications`.`note`
`expense_applications`.`submitted_at`
`expense_applications`.`admin_review_by`
`expense_applications`.`admin_review_at`
`expense_applications`.`admin_review_note`
`expense_applications`.`gm_approve_by`
`expense_applications`.`gm_approve_at`
`expense_applications`.`gm_approve_note`
`expense_applications`.`paid_at`
`expense_applications`.`paid_by`
`expense_applications`.`created_by`
`expense_applications`.`created_at`
`expense_applications`.`updated_at`
`expense_approval_logs`.*
`expense_approval_logs`.`id`
`expense_approval_logs`.`application_id`
`expense_approval_logs`.`action`
`expense_approval_logs`.`action_by`
`expense_approval_logs`.`action_at`
`expense_approval_logs`.`note`
`expense_item_receipts`.*
`expense_item_receipts`.`id`
`expense_item_receipts`.`item_id`
`expense_item_receipts`.`application_id`
`expense_item_receipts`.`file_path`
`expense_item_receipts`.`file_name`
`expense_item_receipts`.`uploaded_by`
`expense_item_receipts`.`uploaded_at`
`expense_items`.*
`expense_items`.`id`
`expense_items`.`application_id`
`expense_items`.`expense_date`
`expense_items`.`description`
`expense_items`.`local_currency`
`expense_items`.`exchange_rate`
`expense_items`.`category`
`expense_items`.`local_amount`
`expense_items`.`amount_twd`
`expense_items`.`remark_no`
`expense_items`.`note`
`expense_items`.`sort_order`
`expense_items`.`created_at`
`feature_categories`.*
`feature_categories`.`id`
`feature_categories`.`category_name`
`feature_categories`.`sort_order`
`feature_categories`.`icon`
`feature_categories`.`category_status`
`feature_categories`.`category_color`
`feature_categories`.`homepage_visible`
`feature_categories`.`mobile_visible`
`inventory`.*
`inventory`.`id`
`inventory`.`item_name`
`inventory`.`qty`
`inventory`.`created_at`
`inventory_demand_order_items`.*
`inventory_demand_order_items`.`id`
`inventory_demand_order_items`.`demand_order_id`
`inventory_demand_order_items`.`finished_product_id`
`inventory_demand_order_items`.`qty`
`inventory_demand_order_items`.`created_at`
`inventory_demand_orders`.*
`inventory_demand_orders`.`id`
`inventory_demand_orders`.`order_no`
`inventory_demand_orders`.`customer_name`
`inventory_demand_orders`.`demand_type`
`inventory_demand_orders`.`probability`
`inventory_demand_orders`.`expected_delivery_date`
`inventory_demand_orders`.`status`
`inventory_demand_orders`.`remark`
`inventory_demand_orders`.`created_by`
`inventory_demand_orders`.`created_at`
`inventory_demand_orders`.`updated_at`
`inventory_receipts`.*
`inventory_receipts`.`id`
`inventory_receipts`.`receipt_no`
`inventory_receipts`.`project_no`
`inventory_receipts`.`purchase_order_no`
`inventory_receipts`.`item_name`
`inventory_receipts`.`qty`
`inventory_receipts`.`location`
`inventory_receipts`.`status`
`inventory_receipts`.`created_at`
`inventory_receipts`.`updated_at`
`inventory_sku_categories`.*
`inventory_sku_categories`.`id`
`inventory_sku_categories`.`code`
`inventory_sku_categories`.`name`
`inventory_sku_categories`.`sort_order`
`inventory_sku_categories`.`is_active`
`inventory_sku_categories`.`created_at`
`inventory_sku_categories`.`updated_at`
`inventory_sku_lines`.*
`inventory_sku_lines`.`id`
`inventory_sku_lines`.`code`
`inventory_sku_lines`.`name`
`inventory_sku_lines`.`sort_order`
`inventory_sku_lines`.`is_active`
`inventory_sku_lines`.`created_at`
`inventory_sku_lines`.`updated_at`
`inventory_sku_origins`.*
`inventory_sku_origins`.`id`
`inventory_sku_origins`.`code`
`inventory_sku_origins`.`name`
`inventory_sku_origins`.`sort_order`
`inventory_sku_origins`.`is_active`
`inventory_sku_origins`.`created_at`
`inventory_sku_origins`.`updated_at`
`inventory_transactions`.*
`inventory_transactions`.`id`
`inventory_transactions`.`product_id`
`inventory_transactions`.`type`
`inventory_transactions`.`qty`
`inventory_transactions`.`before_stock`
`inventory_transactions`.`after_stock`
`inventory_transactions`.`customer_name`
`inventory_transactions`.`serial_number`
`inventory_transactions`.`location`
`inventory_transactions`.`note`
`inventory_transactions`.`created_by`
`inventory_transactions`.`created_at`
`inventory_transactions`.`project_id`
`inventory_transactions`.`transaction_type`
`invoice_applications`.*
`invoice_applications`.`id`
`invoice_applications`.`invoice_request_no`
`invoice_applications`.`applicant_id`
`invoice_applications`.`project_no`
`invoice_applications`.`customer_name`
`invoice_applications`.`invoice_type`
`invoice_applications`.`billing_percent`
`invoice_applications`.`amount`
`invoice_applications`.`description`
`invoice_applications`.`status`
`invoice_applications`.`manager_approver_id`
`invoice_applications`.`admin_issuer_id`
`invoice_applications`.`invoice_no`
`invoice_applications`.`invoice_file`
`invoice_applications`.`issued_at`
`invoice_applications`.`project_billing_completed`
`invoice_applications`.`created_at`
`invoice_applications`.`updated_at`
`leave_applications`.*
`leave_applications`.`id`
`leave_applications`.`employee_id`
`leave_applications`.`leave_type`
`leave_applications`.`start_date`
`leave_applications`.`start_time`
`leave_applications`.`end_date`
`leave_applications`.`end_time`
`leave_applications`.`days`
`leave_applications`.`reason`
`leave_applications`.`status`
`leave_applications`.`approved_by`
`leave_applications`.`approved_at`
`leave_applications`.`rejected_reason`
`leave_applications`.`created_at`
`leave_applications`.`leave_type_id`
`leave_applications`.`hours`
`leave_applications_backup_before_clean`.*
`leave_applications_backup_before_clean`.`id`
`leave_applications_backup_before_clean`.`employee_id`
`leave_applications_backup_before_clean`.`leave_type`
`leave_applications_backup_before_clean`.`start_date`
`leave_applications_backup_before_clean`.`start_time`
`leave_applications_backup_before_clean`.`end_date`
`leave_applications_backup_before_clean`.`end_time`
`leave_applications_backup_before_clean`.`days`
`leave_applications_backup_before_clean`.`reason`
`leave_applications_backup_before_clean`.`status`
`leave_applications_backup_before_clean`.`approved_by`
`leave_applications_backup_before_clean`.`approved_at`
`leave_applications_backup_before_clean`.`rejected_reason`
`leave_applications_backup_before_clean`.`created_at`
`leave_applications_backup_before_clean`.`leave_type_id`
`leave_applications_backup_before_clean`.`hours`
`leave_types`.*
`leave_types`.`id`
`leave_types`.`name`
`leave_types`.`is_annual_leave`
`leave_types`.`deduct_annual_leave`
`leave_types`.`is_active`
`leave_types`.`sort_order`
`overtime_applications`.*
`overtime_applications`.`id`
`overtime_applications`.`employee_id`
`overtime_applications`.`overtime_date`
`overtime_applications`.`end_date`
`overtime_applications`.`start_time`
`overtime_applications`.`end_time`
`overtime_applications`.`hours`
`overtime_applications`.`day_type`
`overtime_applications`.`ot_134_hours`
`overtime_applications`.`ot_167_hours`
`overtime_applications`.`ot_200_hours`
`overtime_applications`.`ot_267_hours`
`overtime_applications`.`reason`
`overtime_applications`.`status`
`overtime_applications`.`approved_by`
`overtime_applications`.`approved_at`
`overtime_applications`.`rejected_reason`
`overtime_applications`.`created_at`
`payroll_brackets`.*
`payroll_brackets`.`id`
`payroll_brackets`.`bracket_type`
`payroll_brackets`.`salary_min`
`payroll_brackets`.`insured_amount`
`payroll_brackets`.`effective_year`
`payroll_brackets`.`created_at`
`payroll_holidays`.*
`payroll_holidays`.`id`
`payroll_holidays`.`holiday_date`
`payroll_holidays`.`holiday_name`
`payroll_holidays`.`holiday_type`
`payroll_holidays`.`created_at`
`payroll_records`.*
`payroll_records`.`id`
`payroll_records`.`payroll_month`
`payroll_records`.`employee_id`
`payroll_records`.`base_salary`
`payroll_records`.`meal_allowance`
`payroll_records`.`total_salary`
`payroll_records`.`work_days`
`payroll_records`.`is_full_month`
`payroll_records`.`calc_start_date`
`payroll_records`.`calc_end_date`
`payroll_records`.`payable_salary`
`payroll_records`.`labor_insured_amount`
`payroll_records`.`health_insured_amount`
`payroll_records`.`overtime_133_hours`
`payroll_records`.`overtime_166_hours`
`payroll_records`.`overtime_200_hours`
`payroll_records`.`overtime_267_hours`
`payroll_records`.`overtime_pay`
`payroll_records`.`annual_leave_cashout`
`payroll_records`.`paid_leave_hours`
`payroll_records`.`personal_leave_hours`
`payroll_records`.`sick_leave_half_hours`
`payroll_records`.`personal_leave_deduction`
`payroll_records`.`sick_leave_deduction`
`payroll_records`.`labor_insurance_mode`
`payroll_records`.`health_insurance_mode`
`payroll_records`.`labor_deduction`
`payroll_records`.`health_dependents`
`payroll_records`.`health_deduction`
`payroll_records`.`net_salary`
`payroll_records`.`note`
`payroll_records`.`status`
`payroll_records`.`created_by`
`payroll_records`.`created_at`
`payroll_records`.`updated_at`
`position_feature_permissions`.*
`position_feature_permissions`.`id`
`position_feature_permissions`.`position_id`
`position_feature_permissions`.`feature_code`
`position_feature_permissions`.`allowed`
`position_feature_permissions`.`created_by`
`position_feature_permissions`.`created_at`
`position_feature_permissions`.`updated_at`
`positions`.*
`positions`.`id`
`positions`.`department_id`
`positions`.`name`
`positions`.`level_no`
`positions`.`created_at`
`product_bom_items`.*
`product_bom_items`.`id`
`product_bom_items`.`bom_id`
`product_bom_items`.`component_product_id`
`product_bom_items`.`qty_per`
`product_bom_items`.`loss_rate`
`product_bom_items`.`note`
`product_bom_items`.`sort_order`
`product_bom_items`.`created_at`
`product_boms`.*
`product_boms`.`id`
`product_boms`.`finished_product_id`
`product_boms`.`bom_name`
`product_boms`.`version`
`product_boms`.`status`
`product_boms`.`remark`
`product_boms`.`created_by`
`product_boms`.`created_at`
`product_boms`.`updated_at`
`product_categories`.*
`product_categories`.`id`
`product_categories`.`name`
`product_categories`.`sort_order`
`product_categories`.`created_at`
`product_inventory`.*
`product_inventory`.`product_id`
`product_inventory`.`qty`
`product_inventory`.`updated_at`
`product_inventory_transactions`.*
`product_inventory_transactions`.`id`
`product_inventory_transactions`.`product_id`
`product_inventory_transactions`.`transaction_type`
`product_inventory_transactions`.`qty`
`product_inventory_transactions`.`related_bom_id`
`product_inventory_transactions`.`note`
`product_inventory_transactions`.`created_by`
`product_inventory_transactions`.`created_at`
`product_serials`.*
`product_serials`.`id`
`product_serials`.`product_id`
`product_serials`.`serial_type`
`product_serials`.`serial_number`
`product_serials`.`sensor_serial_id`
`product_serials`.`sensor_serial_number`
`product_serials`.`status`
`product_serials`.`location`
`product_serials`.`customer_name`
`product_serials`.`note`
`product_serials`.`assembled_at`
`product_serials`.`created_by`
`product_serials`.`void_reason`
`product_serials`.`void_by`
`product_serials`.`void_at`
`product_serials`.`shipped_at`
`product_serials`.`shipment_no`
`product_serials`.`created_at`
`product_serials`.`updated_at`
`products`.*
`products`.`id`
`products`.`sku`
`products`.`model`
`products`.`category_id`
`products`.`brand`
`products`.`supplier`
`products`.`manufacturer_part_no`
`products`.`name_tw`
`products`.`name_en`
`products`.`name_cn`
`products`.`description_tw`
`products`.`description_en`
`products`.`description_cn`
`products`.`spec_tw`
`products`.`spec_en`
`products`.`spec_cn`
`products`.`unit`
`products`.`currency`
`products`.`sale_price`
`products`.`cost_price`
`products`.`stock_qty`
`products`.`safety_stock`
`products`.`lead_time_days`
`products`.`status`
`products`.`item_type`
`products`.`image_path`
`products`.`catalog_path`
`products`.`remark`
`products`.`created_at`
`products`.`updated_at`
`project_applications`.*
`project_applications`.`id`
`project_applications`.`request_no`
`project_applications`.`applicant_id`
`project_applications`.`customer_name`
`project_applications`.`order_no`
`project_applications`.`quotation_no`
`project_applications`.`project_name`
`project_applications`.`amount`
`project_applications`.`payment_terms`
`project_applications`.`description`
`project_applications`.`status`
`project_applications`.`admin_reviewer_id`
`project_applications`.`reviewed_by`
`project_applications`.`reviewed_at`
`project_applications`.`project_no`
`project_applications`.`reject_reason`
`project_applications`.`created_at`
`project_applications`.`updated_at`
`project_applications`.`apply_date`
`project_applications`.`category_code`
`project_applications`.`customer_id`
`project_applications`.`quotation_id`
`project_applications`.`order_amount`
`project_applications`.`currency`
`project_applications`.`owner`
`project_applications`.`note`
`project_applications`.`order_file`
`project_applications`.`quote_file`
`project_applications`.`cost_file`
`project_applications`.`project_case_id`
`project_approvals`.*
`project_approvals`.`id`
`project_approvals`.`project_id`
`project_approvals`.`step_name`
`project_approvals`.`approver`
`project_approvals`.`status`
`project_approvals`.`comment`
`project_approvals`.`approved_at`
`project_approvals`.`created_at`
`project_cases`.*
`project_cases`.`id`
`project_cases`.`project_no`
`project_cases`.`apply_date`
`project_cases`.`category_code`
`project_cases`.`project_name`
`project_cases`.`customer_id`
`project_cases`.`quotation_id`
`project_cases`.`order_no`
`project_cases`.`order_amount`
`project_cases`.`currency`
`project_cases`.`exchange_rate`
`project_cases`.`owner`
`project_cases`.`status`
`project_cases`.`total_cost`
`project_cases`.`invoice_percent_done`
`project_cases`.`order_file`
`project_cases`.`quote_file`
`project_cases`.`cost_file`
`project_cases`.`note`
`project_cases`.`created_by`
`project_cases`.`closed_at`
`project_cases`.`created_at`
`project_cases`.`updated_at`
`project_cases_backup_20260615`.*
`project_cases_backup_20260615`.`id`
`project_cases_backup_20260615`.`project_no`
`project_cases_backup_20260615`.`apply_date`
`project_cases_backup_20260615`.`category_code`
`project_cases_backup_20260615`.`project_name`
`project_cases_backup_20260615`.`customer_id`
`project_cases_backup_20260615`.`quotation_id`
`project_cases_backup_20260615`.`order_no`
`project_cases_backup_20260615`.`order_amount`
`project_cases_backup_20260615`.`currency`
`project_cases_backup_20260615`.`exchange_rate`
`project_cases_backup_20260615`.`owner`
`project_cases_backup_20260615`.`status`
`project_cases_backup_20260615`.`total_cost`
`project_cases_backup_20260615`.`invoice_percent_done`
`project_cases_backup_20260615`.`order_file`
`project_cases_backup_20260615`.`quote_file`
`project_cases_backup_20260615`.`cost_file`
`project_cases_backup_20260615`.`note`
`project_cases_backup_20260615`.`created_by`
`project_cases_backup_20260615`.`closed_at`
`project_cases_backup_20260615`.`created_at`
`project_cases_backup_20260615`.`updated_at`
`project_categories`.*
`project_categories`.`category_code`
`project_categories`.`category_name`
`project_categories`.`sort_order`
`project_categories`.`is_active`
`project_category_allocations`.*
`project_category_allocations`.`id`
`project_category_allocations`.`project_id`
`project_category_allocations`.`category_code`
`project_category_allocations`.`amount`
`project_category_allocations`.`percent`
`project_category_allocations`.`currency`
`project_category_allocations`.`note`
`project_category_allocations`.`created_by`
`project_category_allocations`.`created_at`
`project_category_allocations`.`updated_at`
`project_costs`.*
`project_costs`.`id`
`project_costs`.`project_id`
`project_costs`.`cost_date`
`project_costs`.`department`
`project_costs`.`item_name`
`project_costs`.`amount`
`project_costs`.`note`
`project_costs`.`created_by`
`project_costs`.`created_at`
`project_invoices`.*
`project_invoices`.`id`
`project_invoices`.`project_id`
`project_invoices`.`receivable_schedule_id`
`project_invoices`.`invoice_date`
`project_invoices`.`invoice_percent`
`project_invoices`.`amount`
`project_invoices`.`invoice_no`
`project_invoices`.`application_no`
`project_invoices`.`status`
`project_invoices`.`note`
`project_invoices`.`created_by`
`project_invoices`.`created_at`
`project_invoices`.`application_status`
`project_invoices`.`applicant`
`project_invoices`.`applicant_employee_id`
`project_invoices`.`submitted_at`
`project_invoices`.`admin_checked_by`
`project_invoices`.`admin_checked_at`
`project_invoices`.`admin_checked_note`
`project_invoices`.`gm_approved_by`
`project_invoices`.`gm_approved_at`
`project_invoices`.`gm_approved_note`
`project_invoices`.`issued_by`
`project_invoices`.`issued_at`
`project_invoices`.`issued_note`
`project_invoices`.`rejected_by`
`project_invoices`.`rejected_at`
`project_invoices`.`rejected_note`
`project_invoices`.`due_date`
`project_invoices`.`currency`
`project_invoices`.`exchange_rate`
`project_invoices`.`invoice_amount`
`project_invoices`.`tax_amount`
`project_invoices`.`total_amount`
`project_invoices`.`paid_amount`
`project_invoices`.`updated_at`
`project_no_applications`.*
`project_no_applications`.`id`
`project_no_applications`.`request_no`
`project_no_applications`.`applicant_id`
`project_no_applications`.`customer_name`
`project_no_applications`.`order_no`
`project_no_applications`.`project_name`
`project_no_applications`.`amount`
`project_no_applications`.`description`
`project_no_applications`.`status`
`project_no_applications`.`admin_reviewer_id`
`project_no_applications`.`project_no`
`project_no_applications`.`created_at`
`project_no_applications`.`updated_at`
`project_no_applications_backup_20260615`.*
`project_no_applications_backup_20260615`.`id`
`project_no_applications_backup_20260615`.`request_no`
`project_no_applications_backup_20260615`.`applicant_id`
`project_no_applications_backup_20260615`.`customer_name`
`project_no_applications_backup_20260615`.`order_no`
`project_no_applications_backup_20260615`.`project_name`
`project_no_applications_backup_20260615`.`amount`
`project_no_applications_backup_20260615`.`description`
`project_no_applications_backup_20260615`.`status`
`project_no_applications_backup_20260615`.`admin_reviewer_id`
`project_no_applications_backup_20260615`.`project_no`
`project_no_applications_backup_20260615`.`created_at`
`project_no_applications_backup_20260615`.`updated_at`
`project_order_items`.*
`project_order_items`.`id`
`project_order_items`.`project_id`
`project_order_items`.`quotation_item_id`
`project_order_items`.`product_id`
`project_order_items`.`item_name`
`project_order_items`.`model`
`project_order_items`.`description`
`project_order_items`.`qty`
`project_order_items`.`unit`
`project_order_items`.`unit_price`
`project_order_items`.`discount_rate`
`project_order_items`.`amount`
`project_order_items`.`currency`
`project_order_items`.`category_code`
`project_order_items`.`sort_order`
`project_order_items`.`created_at`
`project_order_items`.`updated_at`
`project_payments`.*
`project_payments`.`id`
`project_payments`.`invoice_id`
`project_payments`.`project_id`
`project_payments`.`payment_date`
`project_payments`.`currency`
`project_payments`.`payment_amount`
`project_payments`.`payment_method`
`project_payments`.`reference_no`
`project_payments`.`note`
`project_payments`.`created_by`
`project_payments`.`created_at`
`project_receivable_schedules`.*
`project_receivable_schedules`.`id`
`project_receivable_schedules`.`project_id`
`project_receivable_schedules`.`order_id`
`project_receivable_schedules`.`schedule_name`
`project_receivable_schedules`.`billing_type`
`project_receivable_schedules`.`percent`
`project_receivable_schedules`.`amount`
`project_receivable_schedules`.`currency`
`project_receivable_schedules`.`exchange_rate`
`project_receivable_schedules`.`base_date_type`
`project_receivable_schedules`.`offset_days`
`project_receivable_schedules`.`expected_due_date`
`project_receivable_schedules`.`invoice_id`
`project_receivable_schedules`.`status`
`project_receivable_schedules`.`note`
`project_receivable_schedules`.`created_by`
`project_receivable_schedules`.`created_at`
`project_receivable_schedules`.`updated_at`
`projects`.*
`projects`.`id`
`projects`.`project_name`
`projects`.`project_manager`
`projects`.`start_date`
`projects`.`end_date`
`projects`.`status`
`projects`.`created_at`
`projects`.`customer_id`
`projects`.`quotation_id`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`purchase_order_no`
`purchase_orders`.`purchase_request_id`
`purchase_orders`.`project_no`
`purchase_orders`.`supplier_name`
`purchase_orders`.`amount`
`purchase_orders`.`delivery_date`
`purchase_orders`.`payment_terms`
`purchase_orders`.`status`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`purchase_orders`.`currency`
`purchase_orders`.`exchange_rate`
`purchase_requests`.*
`purchase_requests`.`id`
`purchase_requests`.`request_no`
`purchase_requests`.`project_id`
`purchase_requests`.`applicant_id`
`purchase_requests`.`project_no`
`purchase_requests`.`project_name`
`purchase_requests`.`supplier_name`
`purchase_requests`.`item_summary`
`purchase_requests`.`amount`
`purchase_requests`.`currency`
`purchase_requests`.`exchange_rate`
`purchase_requests`.`negotiated_amount`
`purchase_requests`.`delivery_date`
`purchase_requests`.`payment_terms`
`purchase_requests`.`remark`
`purchase_requests`.`quote_file`
`purchase_requests`.`required_date`
`purchase_requests`.`negotiation_notes`
`purchase_requests`.`status`
`purchase_requests`.`manager_approver_id`
`purchase_requests`.`gm_approver_id`
`purchase_requests`.`gm_approved_at`
`purchase_requests`.`gm_comment`
`purchase_requests`.`admin_handler_id`
`purchase_requests`.`admin_negotiator_id`
`purchase_requests`.`purchase_order_no`
`purchase_requests`.`ordered_at`
`purchase_requests`.`created_at`
`purchase_requests`.`updated_at`
`quotation_items`.*
`quotation_items`.`id`
`quotation_items`.`quotation_id`
`quotation_items`.`product_id`
`quotation_items`.`product_name`
`quotation_items`.`model`
`quotation_items`.`description`
`quotation_items`.`qty`
`quotation_items`.`unit`
`quotation_items`.`unit_price`
`quotation_items`.`discount_rate`
`quotation_items`.`category_code`
`quotation_items`.`line_total`
`quotation_items`.`sort_order`
`quotations`.*
`quotations`.`id`
`quotations`.`quote_no`
`quotations`.`customer_id`
`quotations`.`quote_date`
`quotations`.`valid_until`
`quotations`.`currency`
`quotations`.`tax_rate`
`quotations`.`discount_amount`
`quotations`.`subtotal`
`quotations`.`tax_amount`
`quotations`.`total_amount`
`quotations`.`special_price_enabled`
`quotations`.`special_price_label`
`quotations`.`special_price_amount`
`quotations`.`special_price_tax_included`
`quotations`.`status`
`quotations`.`note`
`quotations`.`terms`
`quotations`.`created_by`
`quotations`.`created_at`
`quotations`.`updated_at`
`quotations`.`project_id`
`quotations`.`parent_quotation_id`
`quotations`.`version_no`
`quotations`.`is_latest`
`quotations`.`revision_reason`
`quotations`.`replaced_by_id`
`quotations`.`source_quote_id`
`rbac_permissions`.*
`rbac_permissions`.`id`
`rbac_permissions`.`permission_key`
`rbac_permissions`.`permission_name`
`rbac_permissions`.`module_name`
`rbac_permissions`.`description`
`rbac_permissions`.`sort_order`
`rbac_permissions`.`created_at`
`rbac_role_permissions`.*
`rbac_role_permissions`.`id`
`rbac_role_permissions`.`role_id`
`rbac_role_permissions`.`permission_id`
`rbac_role_permissions`.`created_at`
`rbac_roles`.*
`rbac_roles`.`id`
`rbac_roles`.`role_key`
`rbac_roles`.`role_name`
`rbac_roles`.`description`
`rbac_roles`.`is_system`
`rbac_roles`.`sort_order`
`rbac_roles`.`created_at`
`rbac_user_roles`.*
`rbac_user_roles`.`id`
`rbac_user_roles`.`user_id`
`rbac_user_roles`.`role_id`
`rbac_user_roles`.`created_at`
`sales_forecast_followups`.*
`sales_forecast_followups`.`id`
`sales_forecast_followups`.`forecast_id`
`sales_forecast_followups`.`followup_date`
`sales_forecast_followups`.`followup_type`
`sales_forecast_followups`.`content`
`sales_forecast_followups`.`next_followup_date`
`sales_forecast_followups`.`created_by`
`sales_forecast_followups`.`created_at`
`sales_forecasts`.*
`sales_forecasts`.`id`
`sales_forecasts`.`forecast_no`
`sales_forecasts`.`owner_name`
`sales_forecasts`.`owner_employee_id`
`sales_forecasts`.`customer_id`
`sales_forecasts`.`company_name`
`sales_forecasts`.`contact_name`
`sales_forecasts`.`contact_phone`
`sales_forecasts`.`contact_email`
`sales_forecasts`.`project_name`
`sales_forecasts`.`product_name`
`sales_forecasts`.`source`
`sales_forecasts`.`stage`
`sales_forecasts`.`status`
`sales_forecasts`.`probability`
`sales_forecasts`.`currency`
`sales_forecasts`.`cost_amount`
`sales_forecasts`.`sales_amount`
`sales_forecasts`.`gross_profit`
`sales_forecasts`.`gross_margin`
`sales_forecasts`.`weighted_amount`
`sales_forecasts`.`expected_order_date`
`sales_forecasts`.`expected_start_date`
`sales_forecasts`.`expected_finish_date`
`sales_forecasts`.`next_followup_date`
`sales_forecasts`.`quotation_id`
`sales_forecasts`.`order_id`
`sales_forecasts`.`project_id`
`sales_forecasts`.`description`
`sales_forecasts`.`last_followup_note`
`sales_forecasts`.`created_by`
`sales_forecasts`.`updated_by`
`sales_forecasts`.`created_at`
`sales_forecasts`.`updated_at`
`service_cases`.*
`service_cases`.`id`
`service_cases`.`case_no`
`service_cases`.`case_date`
`service_cases`.`customer_id`
`service_cases`.`product_id`
`service_cases`.`serial_number`
`service_cases`.`subject`
`service_cases`.`problem_description`
`service_cases`.`solution`
`service_cases`.`status`
`service_cases`.`priority`
`service_cases`.`assigned_to`
`service_cases`.`note`
`service_cases`.`created_by`
`service_cases`.`created_at`
`service_cases`.`updated_at`
`shipment_items`.*
`shipment_items`.`id`
`shipment_items`.`shipment_id`
`shipment_items`.`finished_serial_id`
`shipment_items`.`product_id`
`shipment_items`.`serial_number`
`shipment_items`.`cell_serial_number`
`shipment_items`.`created_at`
`shipments`.*
`shipments`.`id`
`shipments`.`shipment_no`
`shipments`.`customer_id`
`shipments`.`customer_name`
`shipments`.`project_id`
`shipments`.`contact`
`shipments`.`shipping_address`
`shipments`.`order_no`
`shipments`.`project_no`
`shipments`.`shipment_date`
`shipments`.`items`
`shipments`.`status`
`shipments`.`remark`
`shipments`.`created_by`
`shipments`.`created_at`
`shipments`.`updated_at`
`user_quick_features`.*
`user_quick_features`.`id`
`user_quick_features`.`user_id`
`user_quick_features`.`feature_key`
`user_quick_features`.`sort_order`
`user_quick_features`.`created_at`
`user_system_settings`.*
`user_system_settings`.`user_id`
`user_system_settings`.`receive_all_approval_notifications`
`user_system_settings`.`created_at`
`user_system_settings`.`updated_at`
`users`.*
`users`.`id`
`users`.`username`
`users`.`password`
`users`.`password_hash`
`users`.`name`
`users`.`role`
`users`.`status`
`users`.`created_at`
`vw_customer_quote_project`.*
`vw_customer_quote_project`.`customer_id`
`vw_customer_quote_project`.`company_name`
`vw_customer_quote_project`.`quotation_id`
`vw_customer_quote_project`.`quote_no`
`vw_customer_quote_project`.`quotation_status`
`vw_customer_quote_project`.`quotation_amount`
`vw_customer_quote_project`.`project_id`
`vw_customer_quote_project`.`project_no`
`vw_customer_quote_project`.`project_name`
`vw_customer_quote_project`.`project_status`
`vw_customer_quote_project`.`order_amount`
`vw_customer_sales_flow`.*
`vw_customer_sales_flow`.`customer_id`
`vw_customer_sales_flow`.`company_name`
`vw_customer_sales_flow`.`quotation_id`
`vw_customer_sales_flow`.`quotation_status`
`vw_customer_sales_flow`.`project_id`
`vw_customer_sales_flow`.`project_status`
`vw_project_inventory_flow`.*
`vw_project_inventory_flow`.`project_id`
`vw_project_inventory_flow`.`project_status`
`vw_project_inventory_flow`.`transaction_id`
`vw_project_inventory_flow`.`transaction_type`
`vw_project_inventory_flow`.`qty`
`vw_project_inventory_flow`.`note`
`vw_project_inventory_transactions`.*
`vw_project_inventory_transactions`.`project_id`
`vw_project_inventory_transactions`.`project_no`
`vw_project_inventory_transactions`.`project_name`
`vw_project_inventory_transactions`.`transaction_id`
`vw_project_inventory_transactions`.`product_id`
`vw_project_inventory_transactions`.`sku`
`vw_project_inventory_transactions`.`name_tw`
`vw_project_inventory_transactions`.`type`
`vw_project_inventory_transactions`.`qty`
`vw_project_inventory_transactions`.`before_stock`
`vw_project_inventory_transactions`.`after_stock`
`vw_project_inventory_transactions`.`serial_number`
`vw_project_inventory_transactions`.`location`
`vw_project_inventory_transactions`.`created_at`
`workflow_settings`.*
`workflow_settings`.`id`
`workflow_settings`.`setting_key`
`workflow_settings`.`setting_value`
`workflow_settings`.`setting_label`
`workflow_settings`.`created_at`
`workflow_settings`.`updated_at`
別名:
顯示:
排列:
遞增
遞減
遞增
遞減
遞增
遞減
排序:
1
2
3
1
2
3
1
2
3
準則:
插入:
及:
刪除:
或:
修改:
或:
及:
新增
刪除
或:
及:
新增
刪除
新增
刪除
新增/刪除準則列:
-3
-2
-1
0
1
2
3
新增/刪除欄位:
-3
-2
-1
0
1
2
3
使用資料表
accounts_payable
annual_leave_settlements
approval_instance_steps
approval_instances
approval_items
approval_records
approval_roles
approval_rules
approval_workflow_steps
approval_workflows
attendance_makeup_requests
attendance_records
attendance_settings
audit_logs
calibrations
crm_customer_followups
customers
dashboard_card_preferences
department_feature_permissions
departments
employee_approval_roles
employee_comp_leave_balances
employee_feature_permissions
employee_insurance_history
employee_leave_balances
employee_salary_history
employee_salary_settings
employees
erp_feature_categories
erp_feature_menu_settings
erp_features
exchange_rates
expense_applications
expense_approval_logs
expense_item_receipts
expense_items
feature_categories
inventory
inventory_demand_order_items
inventory_demand_orders
inventory_receipts
inventory_sku_categories
inventory_sku_lines
inventory_sku_origins
inventory_transactions
invoice_applications
leave_applications
leave_applications_backup_before_clean
leave_types
overtime_applications
payroll_brackets
payroll_holidays
payroll_records
position_feature_permissions
positions
product_bom_items
product_boms
product_categories
product_inventory
product_inventory_transactions
product_serials
products
project_applications
project_approvals
project_cases
project_cases_backup_20260615
project_categories
project_category_allocations
project_costs
project_invoices
project_no_applications
project_no_applications_backup_20260615
project_order_items
project_payments
project_receivable_schedules
projects
purchase_orders
purchase_requests
quotation_items
quotations
rbac_permissions
rbac_role_permissions
rbac_roles
rbac_user_roles
sales_forecast_followups
sales_forecasts
service_cases
shipment_items
shipments
user_quick_features
user_system_settings
users
vw_customer_quote_project
vw_customer_sales_flow
vw_project_inventory_flow
vw_project_inventory_transactions
workflow_settings
在
reliya_erp
資料庫執行 SQL 指令: