### Table: `accounting_periods` (12 columns) - Columns: id:integer (PK), code:varchar, name:varchar, start_date:date, end_date:date, fiscal_year:integer, status:varchar, closed_at:datetime, closed_by:integer, notes:text, created_at:datetime, updated_at:datetime ### Table: `accounts` (18 columns) - Columns: id:integer (PK), account_code:varchar, name:varchar, parent_id:integer, account_type:varchar, account_nature:varchar, system_tag:varchar, is_postable:tinyint(1), is_active:tinyint(1), created_at:datetime, updated_at:datetime, currency:varchar, classification:varchar, account_group:varchar, national_id:varchar, phone:varchar, financial_statement:varchar, level:integer ### Table: `activity_log` (12 columns) - Columns: id:integer (PK), log_name:varchar, description:text, subject_type:varchar, subject_id:integer, causer_type:varchar, causer_id:integer, properties:text, created_at:datetime, updated_at:datetime, event:varchar, batch_uuid:varchar ### Table: `audit_logs` (14 columns) - Columns: id:integer (PK), user_id:integer, user_name:varchar, action_type:varchar, screen_name:varchar, document_type:varchar, document_id:integer, document_number:varchar, old_values:text, new_values:text, ip_address:varchar, user_agent:text, details:text, created_at:datetime ### Table: `bank_accounts` (16 columns) - Columns: id:integer (PK), bank_name:varchar, branch_name:varchar, account_number:varchar, currency:varchar, current_account_id:integer, checks_under_collection_account_id:integer, post_dated_checks_account_id:integer, savings_account_id:integer, expense_account_id:integer, status:varchar, manager_name:varchar, phone:varchar, notes:text, created_at:datetime, updated_at:datetime ### Table: `bank_reconciliations` (14 columns) - Columns: id:integer (PK), statement_date:date, bank_account_id:integer, bank_statement_balance:numeric, book_balance:numeric, unpresented_checks_sum:numeric, uncredited_deposits_sum:numeric, adjusted_balance:numeric, difference:numeric, status:varchar, reconciled_by:integer, notes:text, created_at:datetime, updated_at:datetime ### Table: `banks` (9 columns) - Columns: id:integer (PK), bank_code:integer, bank_name_ar:varchar, bank_name_en:varchar, bank_name_he:varchar, swift_code:varchar, is_active:tinyint(1), created_at:datetime, updated_at:datetime ### Table: `cache` (3 columns) - Columns: key:varchar (PK), value:text, expiration:integer ### Table: `cache_locks` (3 columns) - Columns: key:varchar (PK), owner:varchar, expiration:integer ### Table: `cash_counts` (12 columns) - Columns: id:integer (PK), count_date:date, account_id:integer, theoretical_balance:numeric, actual_counted_balance:numeric, difference:numeric, denominations:text, status:varchar, counted_by:integer, notes:text, created_at:datetime, updated_at:datetime ### Table: `contractors` (7 columns) - Columns: id:integer (PK), name:varchar, phone:varchar, is_active:tinyint(1), notes:text, created_at:datetime, updated_at:datetime ### Table: `daily_sheet_items` (10 columns) - Columns: id:integer (PK), daily_sheet_id:integer, worker_id:integer, hours_worked:numeric, wage_rate:numeric, daily_wage:numeric, notes:varchar, created_at:datetime, updated_at:datetime, wage_type:varchar ### Table: `daily_sheets` (16 columns) - Columns: id:integer (PK), sheet_number:varchar, project_id:integer, contractor_id:integer, sheet_date:date, status:varchar, version:integer, total_workers:integer, total_hours:numeric, total_wages:numeric, notes:text, created_by:integer, posted_at:datetime, locked_at:datetime, created_at:datetime, updated_at:datetime ### Table: `document_headers` (20 columns) - Columns: id:integer (PK), document_type:varchar, document_number:varchar, document_date:date, currency:varchar, exchange_rate:numeric, description:text, status:varchar, project_id:integer, user_id:integer, posted_by:integer, posted_at:datetime, attachment_path:varchar, total_debit:numeric, total_credit:numeric, total_debit_base:numeric, total_credit_base:numeric, print_count:integer, created_at:datetime, updated_at:datetime ### Table: `document_lines` (17 columns) - Columns: id:integer (PK), document_header_id:integer, line_number:integer, account_id:integer, debit:numeric, credit:numeric, debit_base:numeric, credit_base:numeric, line_description:text, project_id:integer, contractor_id:integer, worker_id:integer, check_number:varchar, check_due_date:date, bank_name:varchar, created_at:datetime, updated_at:datetime ### Table: `document_sequences` (14 columns) - Columns: id:integer (PK), document_type:varchar, sequence_name:varchar, prefix:varchar, next_number:integer, padding:integer, suffix:varchar, is_default:tinyint(1), is_active:tinyint(1), created_at:datetime, updated_at:datetime, reset_frequency:varchar, last_period:varchar, pattern:varchar ### Table: `failed_jobs` (7 columns) - Columns: id:integer (PK), uuid:varchar, connection:text, queue:text, payload:text, exception:text, failed_at:datetime ### Table: `fiscal_years` (11 columns) - Columns: id:integer (PK), year:integer, start_date:date, end_date:date, status:varchar, closed_at:datetime, closed_by:integer, opening_journal_id:integer, notes:text, created_at:datetime, updated_at:datetime ### Table: `invoice_items` (14 columns) - Columns: id:integer (PK), invoice_id:integer, product_id:integer, item_description:varchar, quantity:numeric, unit_price:numeric, cost_price:numeric, discount_percent:numeric, discount_amount:numeric, tax_percent:numeric, tax_amount:numeric, total:numeric, created_at:datetime, updated_at:datetime ### Table: `invoices` (31 columns) - Columns: id:integer (PK), document_type:varchar, invoice_number:varchar, sequence_id:integer, invoice_date:date, due_date:date, status:varchar, account_id:integer, customer_name:varchar, customer_phone:varchar, currency:varchar, exchange_rate:numeric, subtotal:numeric, tax_amount:numeric, discount_amount:numeric, total_amount:numeric, paid_amount:numeric, payment_method:varchar, cash_account_id:integer, notes:text, created_by:integer, posted_by:integer, posted_at:datetime, voided_by:integer, voided_at:datetime, journal_entry_id:integer, is_printed:tinyint(1), print_count:integer, attachment_path:varchar, created_at:datetime, updated_at:datetime ### Table: `issued_checks` (13 columns) - Columns: id:integer (PK), check_number:varchar, bank_account_id:integer, beneficiary_name:varchar, amount:numeric, issue_date:date, due_date:date, status:varchar, journal_entry_id:integer, cleared_at:datetime, notes:text, created_at:datetime, updated_at:datetime ### Table: `job_batches` (10 columns) - Columns: id:varchar (PK), name:varchar, total_jobs:integer, pending_jobs:integer, failed_jobs:integer, failed_job_ids:text, options:text, cancelled_at:integer, created_at:integer, finished_at:integer ### Table: `jobs` (7 columns) - Columns: id:integer (PK), queue:varchar, payload:text, attempts:integer, reserved_at:integer, available_at:integer, created_at:integer ### Table: `journal_entries` (17 columns) - Columns: id:integer (PK), entry_number:varchar, entry_date:date, reference_type:varchar, reference_id:integer, description:text, total_debit:numeric, total_credit:numeric, status:varchar, created_by:integer, created_at:datetime, updated_at:datetime, sequence_id:integer, posted_by:integer, posted_at:datetime, print_count:integer, attachment_path:varchar ### Table: `journal_entry_lines` (13 columns) - Columns: id:integer (PK), journal_entry_id:integer, account_id:integer, debit:numeric, credit:numeric, project_id:integer, worker_id:integer, party_type:varchar, party_id:integer, display_in_worker_statement:tinyint(1), line_notes:text, created_at:datetime, updated_at:datetime ### Table: `ledger_entries` (16 columns) - Columns: id:integer (PK), entry_number:varchar, entry_date:date, entry_type:varchar, reference_type:varchar, reference_id:integer, worker_id:integer, project_id:integer, contractor_id:integer, debit:numeric, credit:numeric, display_in_worker_statement:tinyint(1), notes:text, created_by:integer, created_at:datetime, updated_at:datetime ### Table: `memo_vouchers` (14 columns) - Columns: id:integer (PK), voucher_number:varchar, voucher_date:date, target_type:varchar, target_id:integer, target_name:varchar, title:varchar, notes:text, priority:varchar, is_active:tinyint(1), created_by:integer, created_at:datetime, updated_at:datetime, deleted_at:datetime ### Table: `migrations` (3 columns) - Columns: id:integer (PK), migration:varchar, batch:integer ### Table: `model_has_permissions` (3 columns) - Columns: permission_id:integer (PK), model_type:varchar (PK), model_id:integer (PK) ### Table: `model_has_roles` (3 columns) - Columns: role_id:integer (PK), model_type:varchar (PK), model_id:integer (PK) ### Table: `opening_balance_lines` (14 columns) - Columns: id:integer (PK), opening_balance_id:integer, account_id:integer, sub_type:varchar, reference_no:varchar, due_date:date, bank_name:varchar, drawer_name:varchar, debit:numeric, credit:numeric, currency:varchar, notes:varchar, created_at:datetime, updated_at:datetime ### Table: `opening_balances` (15 columns) - Columns: id:integer (PK), document_number:varchar, sequence_id:integer, entry_date:date, fiscal_year_id:integer, status:varchar, total_debit:numeric, total_credit:numeric, notes:text, created_by:integer, posted_by:integer, posted_at:datetime, journal_entry_id:integer, created_at:datetime, updated_at:datetime ### Table: `password_reset_otps` (9 columns) - Columns: id:integer (PK), user_id:integer, target:varchar, otp_code:varchar, expires_at:datetime, is_used:tinyint(1), ip_address:varchar, created_at:datetime, updated_at:datetime ### Table: `password_reset_tokens` (3 columns) - Columns: email:varchar (PK), token:varchar, created_at:datetime ### Table: `payment_vouchers` (20 columns) - Columns: id:integer (PK), voucher_number:varchar, worker_id:integer, project_id:integer, amount:numeric, payment_method:varchar, voucher_date:date, period_month:varchar, notes:text, attachment_path:varchar, user_id:integer, created_at:datetime, updated_at:datetime, status:varchar, sequence_id:integer, journal_entry_id:integer, cash_account_id:integer, posted_by:integer, posted_at:datetime, print_count:integer ### Table: `permissions` (5 columns) - Columns: id:integer (PK), name:varchar, guard_name:varchar, created_at:datetime, updated_at:datetime ### Table: `personal_access_tokens` (10 columns) - Columns: id:integer (PK), tokenable_type:varchar, tokenable_id:integer, name:text, token:varchar, abilities:text, last_used_at:datetime, expires_at:datetime, created_at:datetime, updated_at:datetime ### Table: `product_categories` (8 columns) - Columns: id:integer (PK), name:varchar, code:varchar, icon:varchar, color:varchar, is_active:tinyint(1), created_at:datetime, updated_at:datetime ### Table: `products` (17 columns) - Columns: id:integer (PK), category_id:integer, code:varchar, barcode:varchar, name:varchar, unit:varchar, sale_price:numeric, cost_price:numeric, stock_quantity:numeric, min_stock:numeric, image_path:varchar, inventory_account_id:integer, cogs_account_id:integer, sales_account_id:integer, is_active:tinyint(1), created_at:datetime, updated_at:datetime ### Table: `project_receipts` (11 columns) - Columns: id:integer (PK), receipt_number:varchar, project_id:integer, amount:numeric, receipt_date:date, payment_method:varchar, notes:text, attachment_path:varchar, user_id:integer, created_at:datetime, updated_at:datetime ### Table: `projects` (15 columns) - Columns: id:integer (PK), name:varchar, code:varchar, status:varchar, freeze_reason:text, frozen_at:datetime, budget:numeric, notes:text, created_at:datetime, updated_at:datetime, daily_worker_limit:integer, geofence_lat:numeric, geofence_lng:numeric, geofence_radius_meters:integer, contract_value:numeric ### Table: `quick_info_configs` (11 columns) - Columns: id:integer (PK), role_id:integer, document_type:varchar, info_type:varchar, field_settings:text, font_color:varchar, bg_color:varchar, hide_purchase_price:tinyint(1), show_credit_indicators:tinyint(1), created_at:datetime, updated_at:datetime ### Table: `receipt_vouchers` (21 columns) - Columns: id:integer (PK), voucher_number:varchar, receipt_date:date, payer_account_id:integer, project_id:integer, cash_account_id:integer, cash_amount:numeric, checks_total_amount:numeric, discount_amount:numeric, total_settled_amount:numeric, journal_entry_id:integer, notes:text, created_by:integer, created_at:datetime, updated_at:datetime, status:varchar, sequence_id:integer, posted_by:integer, posted_at:datetime, print_count:integer, attachment_path:varchar ### Table: `received_checks` (23 columns) - Columns: id:integer (PK), receipt_voucher_id:integer, check_number:varchar, bank_name:varchar, due_date:date, amount:numeric, status:varchar, deposited_bank_account_id:integer, collection_journal_id:integer, created_at:datetime, updated_at:datetime, deposited_date:date, collection_date:date, bank_commission:numeric, commission_account_id:integer, endorsed_to_account_id:integer, endorsed_date:date, endorsed_notes:text, endorsement_journal_id:integer, bounced_date:date, bounce_reason:varchar, bounce_fee:numeric, bounce_journal_id:integer ### Table: `role_account_restrictions` (9 columns) - Columns: id:integer (PK), role_id:integer, restriction_type:varchar, account_id:integer, account_code:varchar, account_type:varchar, notes:text, created_at:datetime, updated_at:datetime ### Table: `role_has_permissions` (2 columns) - Columns: permission_id:integer (PK), role_id:integer (PK) ### Table: `role_report_permissions` (16 columns) - Columns: id:integer (PK), role_id:integer, report_key:varchar, report_name:varchar, preview_report:tinyint(1), print_report:tinyint(1), export_excel:tinyint(1), export_pdf:tinyint(1), save_report:tinyint(1), design_report:tinyint(1), edit_report_pages:tinyint(1), change_default_report:tinyint(1), set_report_order:tinyint(1), set_report_layout:tinyint(1), created_at:datetime, updated_at:datetime ### Table: `roles` (5 columns) - Columns: id:integer (PK), name:varchar, guard_name:varchar, created_at:datetime, updated_at:datetime ### Table: `screen_permissions` (15 columns) - Columns: id:integer (PK), role_id:integer, screen_key:varchar, screen_name:varchar, screen_category:varchar, open_screen:tinyint(1), view_posted:tinyint(1), create:tinyint(1), edit:tinyint(1), delete:tinyint(1), print_unposted:tinyint(1), print_posted:tinyint(1), post_unpost:tinyint(1), created_at:datetime, updated_at:datetime ### Table: `sessions` (6 columns) - Columns: id:varchar (PK), user_id:integer, ip_address:varchar, user_agent:text, payload:text, last_activity:integer ### Table: `system_settings` (9 columns) - Columns: id:integer (PK), key:varchar, value:text, group:varchar, type:varchar, label:varchar, description:text, created_at:datetime, updated_at:datetime ### Table: `user_project_access` (2 columns) - Columns: user_id:integer (PK), project_id:integer (PK) ### Table: `user_sessions` (12 columns) - Columns: id:integer (PK), user_id:integer, session_id:varchar, ip_address:varchar, user_agent:text, device_name:varchar, login_at:datetime, last_activity:datetime, logout_at:datetime, status:varchar, created_at:datetime, updated_at:datetime ### Table: `user_workspace_preferences` (8 columns) - Columns: id:integer (PK), user_id:integer, tabs_config:text, open_tabs:text, quick_shortcuts:text, active_workspace:varchar, created_at:datetime, updated_at:datetime ### Table: `users` (25 columns) - Columns: id:integer (PK), name:varchar, email:varchar, email_verified_at:datetime, password:varchar, remember_token:varchar, created_at:datetime, updated_at:datetime, username:varchar, phone:varchar, max_voucher_limit:numeric, all_projects_access:tinyint(1), status:varchar, must_change_password:tinyint(1), last_login:datetime, job_title:varchar, default_project_id:integer, default_cash_account_id:integer, default_bank_account_id:integer, hide_balances:tinyint(1), prevent_price_edit:tinyint(1), failed_login_attempts:integer, locked_until:datetime, otp_code:varchar, otp_expires_at:datetime ### Table: `workers` (49 columns) - Columns: id:integer (PK), worker_code:varchar, full_name:varchar, national_id:varchar, phone:varchar, whatsapp_number:varchar, whatsapp_opt_in:tinyint(1), wage_type:varchar, wage_rate:numeric, contractor_id:integer, status:varchar, freeze_reason:text, frozen_at:datetime, notes:text, created_at:datetime, updated_at:datetime, blacklist_reason:text, blacklisted_at:datetime, pending_wage_rate:numeric, wage_approval_status:varchar, wage_approved_by:integer, account_id:integer, account_code:varchar, short_code:varchar, name_en:varchar, group:varchar, currency:varchar, transportation_allowance:numeric, salary_includes_transportation:tinyint(1), overtime_rate:numeric, daily_work_hours:numeric, weekly_work_days:integer, weekly_off_day:varchar, job_title:varchar, shift_start:varchar, shift_end:varchar, biometric_id:varchar, hire_date:date, termination_date:date, birth_date:date, gender:varchar, marital_status:varchar, dependents_count:integer, secondary_phone:varchar, city:varchar, address:text, emergency_contact:varchar, avatar_path:varchar, attachments:text