Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v warehouse_assets_system academic_courses
* id : int(11)
* course_code : varchar(30)
* name_ar : varchar(255)
* name_en : varchar(255)
* department_id : int(11)
* credit_hours : int(11)
* theory_hours : int(11)
* practical_hours : int(11)
* level : tinyint(4)
* is_active : tinyint(1)
* notes : text
* created_at : timestamp
v warehouse_assets_system academic_payroll
* id : int(11)
* staff_id : int(11)
* semester_id : int(11)
* month : tinyint(4)
* year : smallint(6)
* theory_hours : decimal(8,2)
* practical_hours : decimal(8,2)
* extra_hours : decimal(8,2)
* theory_amount : decimal(12,2)
* practical_amount : decimal(12,2)
* extra_amount : decimal(12,2)
* gross_salary : decimal(12,2)
* deductions : decimal(12,2)
* net_salary : decimal(12,2)
* status : enum('draft','approved','paid')
* journal_entry_id : int(11)
* payment_entry_id : int(11)
* notes : text
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system academic_ranks
* id : int(11)
* name_ar : varchar(100)
* name_en : varchar(100)
* code : varchar(30)
* sort_order : tinyint(4)
* base_hourly_theory : decimal(10,2)
* base_hourly_practical : decimal(10,2)
* base_hourly_extra : decimal(10,2)
* min_hours_required : int(11)
* max_hours_allowed : int(11)
* is_active : tinyint(1)
* notes : text
* created_at : timestamp
v warehouse_assets_system academic_semesters
* id : int(11)
* name_ar : varchar(100)
* academic_year : varchar(20)
* semester_number : tinyint(4)
* start_date : date
* end_date : date
* status : enum('upcoming','active','ended')
* created_at : timestamp
v warehouse_assets_system academic_staff
* id : int(11)
* staff_code : varchar(30)
* full_name : varchar(255)
* full_name_en : varchar(255)
* rank_id : int(11)
* department_id : int(11)
* national_id : varchar(14)
* email : varchar(255)
* phone : varchar(20)
* hire_date : date
* photo : varchar(255)
* salary_basic : decimal(12,2)
* staff_type : enum('permanent','part_time','external','delegate')
* custom_hourly_theory : decimal(10,2)
* custom_hourly_practical : decimal(10,2)
* custom_hourly_extra : decimal(10,2)
* portal_username : varchar(100)
* portal_password : varchar(255)
* portal_active : tinyint(1)
* status : enum('active','on_leave','suspended','retired')
* notes : text
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system accounting_periods
* id : int(11)
* fiscal_year : smallint(6)
* fiscal_period : tinyint(4)
* period_name : varchar(50)
* start_date : date
* end_date : date
* status : enum('open','closing','closed')
* closed_by : int(11)
* closed_at : timestamp
* opening_entry_id : int(11)
* closing_notes : text
* total_debit : decimal(14,2)
* total_credit : decimal(14,2)
* entries_count : int(11)
* created_at : timestamp
v warehouse_assets_system accounts
* id : int(11)
* code : varchar(20)
* name_ar : varchar(200)
* name_en : varchar(200)
* parent_id : int(11)
* account_type : enum('asset','liability','equity','revenue','expense')
* account_class : enum('1','2','3','4','5')
* level : tinyint(4)
* is_parent : tinyint(1)
* normal_balance : enum('debit','credit')
* opening_balance : decimal(14,2)
* is_active : tinyint(1)
* notes : text
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
v warehouse_assets_system accounts_receivable
* id : int(11)
* invoice_number : varchar(50)
* debtor_type : enum('student','department','external','other')
* debtor_name : varchar(300)
* debtor_code : varchar(50)
* account_code : varchar(20)
* description : varchar(500)
* invoice_date : date
* due_date : date
* amount : decimal(14,2)
* paid_amount : decimal(14,2)
* status : enum('pending','partial','paid','overdue','cancelled')
* revenue_account : varchar(20)
* journal_entry_id : int(11)
* payment_entry_id : int(11)
* notes : text
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
v warehouse_assets_system api_tokens
* id : int(11)
* token : varchar(64)
* name : varchar(255)
* user_id : int(11)
* permissions : longtext
* last_used_at : timestamp
* expires_at : timestamp
* is_active : tinyint(1)
* created_at : timestamp
v warehouse_assets_system ar_payments
* id : int(11)
* ar_id : int(11)
* payment_date : date
* amount : decimal(14,2)
* payment_method : enum('cash','bank','check','other')
* reference : varchar(100)
* journal_entry_id : int(11)
* notes : varchar(500)
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system assets
* id : int(11)
* asset_code : varchar(50)
* serial_number : int(11)
* category_id : int(11)
* name : varchar(255)
* description : text
* addition_number : varchar(100)
* added_date : date
* quantity : int(11)
* unit_price : decimal(14,2)
* total_value : decimal(16,2)
* depreciation_rate : decimal(5,2)
* warehouse_id : int(11)
* space_id : int(11)
* current_location : varchar(255)
* supplier : varchar(255)
* supplier_id : int(11)
* warranty_expiry : date
* status : enum('active','under_maintenance','disposed','damaged')
* image : varchar(255)
* notes : text
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
* depreciation_method : enum('straight_line','declining')
* useful_life_years : int(11)
* salvage_value : decimal(14,2)
* accumulated_depreciation : decimal(14,2)
* last_depreciation_date : date
* journal_entry_id : int(11)
v warehouse_assets_system asset_attachments
* id : int(11)
* asset_id : int(11)
* file_path : varchar(255)
* file_type : varchar(50)
* uploaded_at : timestamp
v warehouse_assets_system asset_bookings
* id : int(11)
* asset_id : int(11)
* booking_number : varchar(30)
* employee_id : int(11)
* department_id : int(11)
* purpose : varchar(255)
* booking_date : date
* start_time : time
* end_time : time
* return_time : timestamp
* status : enum('pending','approved','in_use','returned','cancelled')
* approved_by : int(11)
* approved_at : timestamp
* notes : text
* condition_on_return : enum('good','fair','damaged')
* created_at : timestamp
v warehouse_assets_system asset_depreciation_log
* id : int(11)
* asset_id : int(11)
* fiscal_year : year(4)
* annual_depreciation : decimal(14,2)
* accumulated_depreciation : decimal(14,2)
* book_value : decimal(14,2)
* calculated_at : timestamp
v warehouse_assets_system asset_depreciation_schedule
* id : int(11)
* asset_id : int(11)
* depreciation_year : smallint(6)
* depreciation_month : tinyint(4)
* depreciation_amount : decimal(14,2)
* book_value_before : decimal(14,2)
* book_value_after : decimal(14,2)
* journal_entry_id : int(11)
* status : enum('scheduled','posted')
* created_at : timestamp
v warehouse_assets_system asset_disposals
* id : int(11)
* asset_id : int(11)
* disposal_type : enum('scrapped','sold','donated','transferred','lost','other')
* disposal_date : date
* disposal_value : decimal(12,2)
* reason : text
* recipient : varchar(255)
* receipt_number : varchar(100)
* approved_by : int(11)
* notes : text
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system asset_images
* id : int(11)
* asset_id : int(11)
* image_path : varchar(255)
* uploaded_at : timestamp
v warehouse_assets_system asset_maintenance
* id : int(11)
* asset_id : int(11)
* maintenance_date : date
* next_due_date : date
* description : text
* cost : decimal(12,2)
* performed_by : varchar(150)
* status : enum('scheduled','completed','overdue')
v warehouse_assets_system attendance
* id : int(11)
* employee_id : int(11)
* attend_date : date
* check_in : time
* check_out : time
* status : enum('present','absent','late','early_leave','holiday','leave','remote')
* late_minutes : int(11)
* early_minutes : int(11)
* work_hours : decimal(4,2)
* notes : varchar(500)
* recorded_by : int(11)
* created_at : timestamp
v warehouse_assets_system audit_log
* id : bigint(20)
* user_id : int(11)
* action : varchar(100)
* module : varchar(100)
* record_id : int(11)
* details : text
* ip_address : varchar(45)
* created_at : timestamp
v warehouse_assets_system bank_reconciliation
* id : int(11)
* account_code : varchar(20)
* period_month : tinyint(4)
* period_year : smallint(6)
* statement_date : date
* statement_balance : decimal(14,2)
* book_balance : decimal(14,2)
* difference : decimal(14,2)
* status : enum('draft','reconciled')
* notes : text
* reconciled_by : int(11)
* reconciled_at : timestamp
* journal_entry_id : int(11)
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system bank_reconciliation_items
* id : int(11)
* reconciliation_id : int(11)
* item_type : enum('outstanding_check','deposit_in_transit','bank_error','book_error','bank_charge','bank_interest','other')
* description : varchar(500)
* amount : decimal(14,2)
* transaction_date : date
* journal_entry_id : int(11)
* is_cleared : tinyint(1)
* cleared_date : date
* created_at : timestamp
v warehouse_assets_system budgets
* id : int(11)
* fiscal_year : smallint(6)
* department_id : int(11)
* budget_type : enum('assets','consumables','maintenance','contracts','other')
* title : varchar(255)
* planned_amount : decimal(14,2)
* notes : text
* status : enum('draft','approved','closed')
* approved_by : int(11)
* approved_at : timestamp
* created_by : int(11)
* created_at : timestamp
* account_code : varchar(20)
* committed_amount : decimal(14,2)
* actual_amount : decimal(14,2)
* journal_entry_id : int(11)
v warehouse_assets_system budget_transactions
* id : int(11)
* budget_id : int(11)
* transaction_date : date
* amount : decimal(14,2)
* transaction_type : enum('po','invoice','maintenance','other')
* reference_id : int(11)
* reference_number : varchar(100)
* description : varchar(255)
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system buildings
* id : int(11)
* code : varchar(20)
* name : varchar(150)
* name_en : varchar(150)
* address : text
* floors_count : int(11)
* year_built : year(4)
* area_sqm : decimal(10,2)
* description : text
* is_active : tinyint(1)
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system building_floors
* id : int(11)
* building_id : int(11)
* floor_num : int(11)
* name : varchar(100)
* description : text
* is_active : tinyint(1)
* fp_width : int(11)
* fp_height : int(11)
* fp_bg : varchar(7)
v warehouse_assets_system categories
* id : int(11)
* code : varchar(20)
* name_ar : varchar(150)
* parent_id : int(11)
* book_type : enum('asset','consumable')
* depreciation_min : decimal(5,2)
* depreciation_max : decimal(5,2)
* level : tinyint(4)
v warehouse_assets_system clearance_approvals
* id : bigint(20)
* request_id : int(11)
* step_id : int(11)
* status : enum('pending','approved','rejected','not_applicable')
* notes : text
* approved_by : int(11)
* approved_at : timestamp
* created_at : timestamp
v warehouse_assets_system clearance_requests
* id : int(11)
* request_number : varchar(50)
* person_type : enum('employee','academic_staff')
* person_id : int(11)
* reason : enum('resignation','retirement','termination','transfer','end_contract','other')
* reason_notes : text
* last_working_day : date
* status : enum('pending','in_progress','completed','rejected')
* notes : text
* created_by : int(11)
* completed_at : timestamp
* rejected_by : int(11)
* rejected_at : timestamp
* created_at : timestamp
* updated_at : timestamp
* journal_entry_id : int(11)
v warehouse_assets_system clearance_steps
* id : int(11)
* step_name : varchar(150)
* step_name_en : varchar(150)
* responsible_dept : varchar(100)
* step_order : int(11)
* applies_to : enum('both','employee','academic_staff')
* is_required : tinyint(1)
* is_active : tinyint(1)
* notes : text
v warehouse_assets_system consumables
* id : int(11)
* item_code : varchar(50)
* category_id : int(11)
* name : varchar(255)
* description : text
* unit : varchar(50)
* current_stock : decimal(12,2)
* min_stock_alert : decimal(12,2)
* warehouse_id : int(11)
* supplier_id : int(11)
* image : varchar(255)
* is_active : tinyint(1)
* created_at : timestamp
* account_code : varchar(20)
v warehouse_assets_system contracts
* id : int(11)
* contract_number : varchar(100)
* title : varchar(255)
* supplier_id : int(11)
* contract_type : enum('maintenance','supply','service','construction','other')
* start_date : date
* end_date : date
* total_value : decimal(14,2)
* paid_value : decimal(14,2)
* status : enum('active','completed','terminated','expired')
* description : text
* attachment : varchar(255)
* created_by : int(11)
* created_at : timestamp
* journal_entry_id : int(11)
* expense_account : varchar(20)
* notes : text
v warehouse_assets_system contract_payments
* id : int(11)
* contract_id : int(11)
* payment_number : int(11)
* title : varchar(255)
* due_date : date
* amount : decimal(14,2)
* paid_date : date
* paid_amount : decimal(14,2)
* status : enum('pending','paid','overdue','cancelled')
* notes : varchar(255)
* created_at : timestamp
* journal_entry_id : int(11)
* account_code : varchar(20)
v warehouse_assets_system correspondence
* id : int(11)
* ref_number : varchar(50)
* type : enum('incoming','outgoing')
* direction : enum('internal','external')
* subject : varchar(500)
* category_id : int(11)
* priority : enum('normal','urgent','confidential','top_secret')
* status : enum('new','in_progress','replied','archived','cancelled')
* sender_name : varchar(255)
* sender_entity : varchar(255)
* sender_ref : varchar(100)
* sender_date : date
* receiver_name : varchar(255)
* receiver_entity : varchar(255)
* department_id : int(11)
* employee_id : int(11)
* assigned_to : int(11)
* correspondence_date : date
* received_date : date
* due_date : date
* reply_date : date
* summary : text
* notes : text
* tags : varchar(500)
* replied_by : int(11)
* reply_ref : varchar(100)
* parent_id : int(11)
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
v warehouse_assets_system correspondence_attachments
* id : int(11)
* correspondence_id : int(11)
* file_name : varchar(255)
* file_path : varchar(500)
* file_type : varchar(50)
* file_size : int(11)
* is_primary : tinyint(1)
* uploaded_by : int(11)
* uploaded_at : timestamp
v warehouse_assets_system correspondence_categories
* id : int(11)
* name : varchar(100)
* color : varchar(20)
* icon : varchar(50)
* sort_order : int(11)
* is_active : tinyint(1)
v warehouse_assets_system correspondence_log
* id : int(11)
* correspondence_id : int(11)
* action : varchar(100)
* notes : text
* done_by : int(11)
* done_at : timestamp
v warehouse_assets_system correspondence_recipients
* id : int(11)
* correspondence_id : int(11)
* employee_id : int(11)
* department_id : int(11)
* recipient_name : varchar(255)
* read_at : timestamp
* acknowledged_at : timestamp
* notes : text
v warehouse_assets_system cost_center_allocations
* id : int(11)
* journal_entry_id : int(11)
* journal_line_id : int(11)
* department_id : int(11)
* account_code : varchar(20)
* amount : decimal(14,2)
* allocation_pct : decimal(5,2)
* fiscal_year : smallint(6)
* fiscal_period : tinyint(4)
* notes : varchar(500)
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system cost_center_distribution_keys
* id : int(11)
* account_code : varchar(20)
* department_id : int(11)
* percentage : decimal(5,2)
* is_active : tinyint(1)
v warehouse_assets_system custody_records
* id : bigint(20)
* employee_id : int(11)
* item_type : enum('asset','consumable')
* item_id : int(11)
* voucher_number : varchar(100)
* custody_date : date
* quantity : decimal(12,2)
* item_condition : enum('new','used','needs_maintenance','damaged')
* movement_type : enum('receive','return','transfer')
* transferred_to_employee_id : int(11)
* signature_path : varchar(255)
* verification_qr : varchar(255)
* balance_after : decimal(12,2)
* notes : text
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system custody_return_requests
* id : int(11)
* employee_id : int(11)
* item_type : enum('asset','consumable')
* item_id : int(11)
* quantity : decimal(12,2)
* unit_codes : longtext
* reason : varchar(255)
* status : enum('pending','approved','rejected')
* reviewed_by : int(11)
* reviewed_at : timestamp
* review_notes : varchar(255)
* warehouse_id : int(11)
* created_at : timestamp
* journal_entry_id : int(11)
v warehouse_assets_system custody_unit_items
* id : bigint(20)
* custody_id : bigint(20)
* unit_id : bigint(20)
* unit_code : varchar(80)
* status : enum('issued','returned','damaged')
* returned_at : timestamp
* notes : varchar(255)
v warehouse_assets_system departments
* id : int(11)
* name : varchar(150)
* cost_center_code : varchar(20)
* budget_amount : decimal(14,2)
* parent_id : int(11)
v warehouse_assets_system department_asset_entitlements
* id : int(11)
* department_id : int(11)
* category_id : int(11)
* quantity_entitled : int(11)
* quantity_actual : int(11)
* notes : text
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
v warehouse_assets_system disposal_reasons
* id : int(11)
* name_ar : varchar(150)
* is_active : tinyint(1)
v warehouse_assets_system documents
* id : int(11)
* title : varchar(255)
* description : text
* file_path : varchar(500)
* file_name : varchar(255)
* file_size : int(11)
* file_type : varchar(100)
* doc_type : enum('contract','invoice','po','maintenance','report','correspondence','other')
* entity_type : varchar(50)
* entity_id : int(11)
* tags : varchar(500)
* is_confidential : tinyint(1)
* uploaded_by : int(11)
* created_at : timestamp
v warehouse_assets_system employees
* id : int(11)
* employee_code : varchar(50)
* national_id : varchar(20)
* full_name : varchar(150)
* job_title : varchar(150)
* department_id : int(11)
* hire_date : date
* email : varchar(150)
* phone : varchar(20)
* gender : enum('male','female')
* birth_date : date
* basic_salary : decimal(12,2)
* bank_account : varchar(50)
* address : text
* emergency_contact : varchar(100)
* emergency_phone : varchar(20)
* notes : text
* status : enum('pending','active','resigned','transferred','rejected','retired')
* photo : varchar(255)
* created_at : timestamp
v warehouse_assets_system employee_entitlements
* id : int(11)
* employee_id : int(11)
* entitlement_type : enum('salary','allowance','bonus','overtime','deduction','other')
* title : varchar(255)
* amount : decimal(12,2)
* is_recurring : tinyint(1)
* period_month : tinyint(4)
* period_year : smallint(6)
* status : enum('pending','paid','cancelled')
* payment_date : date
* notes : text
* created_by : int(11)
* created_at : timestamp
* journal_entry_id : int(11)
* account_code : varchar(20)
v warehouse_assets_system employee_leave_balance
* id : int(11)
* employee_id : int(11)
* leave_type_id : int(11)
* year : int(11)
* total_days : decimal(6,1)
* used_days : decimal(6,1)
* pending_days : decimal(6,1)
v warehouse_assets_system employee_payroll
* id : bigint(20)
* employee_id : int(11)
* month : tinyint(4)
* year : smallint(6)
* basic_salary : decimal(12,2)
* allowances : decimal(12,2)
* bonuses : decimal(12,2)
* deductions : decimal(12,2)
* penalties : decimal(12,2)
* social_insurance : decimal(10,2)
* medical_insurance : decimal(10,2)
* income_tax : decimal(10,2)
* employer_social : decimal(10,2)
* net_salary : decimal(12,2)
* notes : text
* status : enum('draft','approved','paid')
* paid_at : timestamp
* created_by : int(11)
* created_at : timestamp
* journal_entry_id : int(11)
* payment_entry_id : int(11)
* gross_salary : decimal(12,2)
v warehouse_assets_system employee_penalties
* id : int(11)
* employee_id : int(11)
* penalty_type : enum('warning','fine','suspension','other')
* reason : text
* amount : decimal(10,2)
* penalty_date : date
* notes : text
* issued_by : int(11)
* created_at : timestamp
* journal_entry_id : int(11)
v warehouse_assets_system entitlement_rules
* id : int(11)
* rule_name : varchar(255)
* applies_to : enum('rank','staff','all')
* rank_id : int(11)
* staff_id : int(11)
* rate_theory : decimal(10,2)
* rate_practical : decimal(10,2)
* rate_extra : decimal(10,2)
* min_hours_extra : int(11)
* effective_from : date
* effective_to : date
* is_active : tinyint(1)
* notes : text
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system fiscal_year_closing
* id : int(11)
* fiscal_year : smallint(6)
* status : enum('open','closing','closed')
* total_revenue : decimal(14,2)
* total_expense : decimal(14,2)
* net_profit_loss : decimal(14,2)
* closing_entry_id : int(11)
* transfer_entry_id : int(11)
* closed_by : int(11)
* closed_at : timestamp
* notes : text
* created_at : timestamp
v warehouse_assets_system goods_receipts
* id : int(11)
* gr_number : varchar(30)
* po_id : int(11)
* receipt_date : date
* warehouse_id : int(11)
* total_received : decimal(14,2)
* journal_entry_id : int(11)
* notes : text
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system goods_receipt_items
* id : int(11)
* gr_id : int(11)
* poi_id : int(11)
* received_qty : decimal(12,2)
* unit_price : decimal(14,2)
* total_price : decimal(14,2)
v warehouse_assets_system id_card_settings
* id : int(11)
* name : varchar(100)
* card_type : enum('employee','academic','all')
* width_mm : decimal(6,2)
* height_mm : decimal(6,2)
* orientation : enum('landscape','portrait')
* cards_per_row : tinyint(4)
* cards_per_page : tinyint(4)
* margin_mm : decimal(5,2)
* gap_mm : decimal(5,2)
* show_photo : tinyint(1)
* show_barcode : tinyint(1)
* show_qr : tinyint(1)
* show_back : tinyint(1)
* show_natid : tinyint(1)
* color_primary : varchar(20)
* color_secondary : varchar(20)
* printer_name : varchar(100)
* paper_size : enum('A4','A5','Letter','Custom')
* is_default : tinyint(1)
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system invoice_payments
* id : int(11)
* invoice_id : int(11)
* payment_date : date
* amount : decimal(14,2)
* payment_method : enum('cash','bank_transfer','check','other')
* reference_number : varchar(100)
* notes : varchar(255)
* created_by : int(11)
* created_at : timestamp
* journal_entry_id : int(11)
* revenue_account : varchar(20)
v warehouse_assets_system item_units
* id : bigint(20)
* item_type : enum('asset','consumable')
* item_id : int(11)
* unit_code : varchar(80)
* warehouse_id : int(11)
* status : enum('in_stock','issued','disposed','damaged','under_maintenance')
* assigned_to_employee_id : int(11)
* last_scanned_at : timestamp
* notes : varchar(255)
* created_at : timestamp
v warehouse_assets_system journal_approval_log
* id : int(11)
* entry_id : int(11)
* action : enum('submitted','approved','rejected','cancelled')
* user_id : int(11)
* notes : varchar(500)
* created_at : timestamp
v warehouse_assets_system journal_entries
* id : int(11)
* entry_number : varchar(30)
* entry_date : date
* description : varchar(500)
* reference_type : varchar(50)
* reference_id : int(11)
* reference_number : varchar(100)
* fiscal_year : smallint(6)
* fiscal_period : tinyint(4)
* total_debit : decimal(14,2)
* total_credit : decimal(14,2)
* status : enum('draft','posted','reversed')
* approval_status : enum('pending','approved','rejected')
* approval_required : tinyint(1)
* reviewed_by : int(11)
* reviewed_at : timestamp
* review_notes : varchar(500)
* posted_by : int(11)
* posted_at : timestamp
* reversed_entry : int(11)
* notes : text
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
v warehouse_assets_system journal_entry_lines
* id : int(11)
* entry_id : int(11)
* line_number : smallint(6)
* account_id : int(11)
* description : varchar(300)
* debit_amount : decimal(14,2)
* credit_amount : decimal(14,2)
* cost_center : varchar(100)
v warehouse_assets_system leave_requests
* id : int(11)
* request_number : varchar(50)
* employee_id : int(11)
* leave_type_id : int(11)
* start_date : date
* end_date : date
* days_count : decimal(5,1)
* reason : text
* status : enum('pending','manager_approved','hr_approved','rejected')
* manager_id : int(11)
* manager_notes : text
* manager_decided_at : timestamp
* hr_id : int(11)
* hr_notes : text
* hr_decided_at : timestamp
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
v warehouse_assets_system leave_types
* id : int(11)
* name_ar : varchar(100)
* name_en : varchar(100)
* days_per_year : int(11)
* is_paid : tinyint(1)
* color : varchar(20)
* is_active : tinyint(1)
* created_at : timestamp
v warehouse_assets_system notifications
* id : bigint(20)
* user_id : int(11)
* title : varchar(255)
* message : text
* is_read : tinyint(1)
* created_at : timestamp
* type : enum('info','warning','danger','success')
v warehouse_assets_system official_holidays
* id : int(11)
* name : varchar(200)
* holiday_date : date
* year : smallint(6)
* is_recurring : tinyint(1)
v warehouse_assets_system payroll_settings
* id : int(11)
* setting_key : varchar(100)
* value : decimal(10,4)
* description : varchar(300)
* updated_at : timestamp
v warehouse_assets_system performance_criteria
* id : int(11)
* template_id : int(11)
* name : varchar(200)
* description : text
* max_score : decimal(5,2)
* weight : decimal(5,2)
* category : enum('technical','behavioral','management','other')
* sort_order : int(11)
v warehouse_assets_system performance_evaluations
* id : int(11)
* employee_id : int(11)
* template_id : int(11)
* evaluator_id : int(11)
* period_year : smallint(6)
* period_quarter : tinyint(4)
* period_month : tinyint(4)
* eval_date : date
* total_score : decimal(5,2)
* max_score : decimal(5,2)
* percentage : decimal(5,2)
* grade : enum('excellent','very_good','good','acceptable','poor')
* notes : text
* strengths : text
* improvements : text
* status : enum('draft','submitted','approved')
* approved_by : int(11)
* approved_at : timestamp
* created_at : timestamp
v warehouse_assets_system performance_scores
* id : int(11)
* evaluation_id : int(11)
* criteria_id : int(11)
* score : decimal(5,2)
* notes : varchar(500)
v warehouse_assets_system performance_templates
* id : int(11)
* name : varchar(200)
* description : text
* period : enum('monthly','quarterly','semi_annual','annual')
* is_active : tinyint(1)
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system permissions
* id : int(11)
* module : varchar(100)
* action : varchar(50)
v warehouse_assets_system po_receipts
* id : int(11)
* po_id : int(11)
* receipt_date : date
* received_by : int(11)
* notes : text
* created_at : timestamp
v warehouse_assets_system po_receipt_items
* id : int(11)
* receipt_id : int(11)
* po_item_id : int(11)
* quantity_received : decimal(12,2)
* condition_notes : varchar(255)
v warehouse_assets_system prepaid_amortization
* id : int(11)
* prepaid_id : int(11)
* period_year : smallint(6)
* period_month : tinyint(4)
* amount : decimal(14,2)
* journal_entry_id : int(11)
* status : enum('pending','posted')
* posted_at : timestamp
v warehouse_assets_system prepaid_expenses
* id : int(11)
* entry_number : varchar(50)
* description : varchar(500)
* vendor_name : varchar(255)
* expense_account : varchar(20)
* total_amount : decimal(14,2)
* start_date : date
* end_date : date
* months_total : int(11)
* monthly_amount : decimal(14,2)
* amortized_amount : decimal(14,2)
* remaining_amount : decimal(14,2)
* status : enum('active','completed','cancelled')
* initial_entry_id : int(11)
* notes : text
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system project_assets
* id : int(11)
* project_id : int(11)
* asset_id : int(11)
* consumable_id : int(11)
* quantity : decimal(10,2)
* assigned_date : date
* return_date : date
* notes : varchar(255)
v warehouse_assets_system project_expenses
* id : int(11)
* project_id : int(11)
* expense_date : date
* category : enum('equipment','consumables','travel','services','salaries','other')
* description : varchar(255)
* amount : decimal(12,2)
* reference_id : int(11)
* reference_type : varchar(50)
* created_by : int(11)
* created_at : timestamp
* journal_entry_id : int(11)
* account_code : varchar(20)
v warehouse_assets_system project_team
* id : int(11)
* project_id : int(11)
* staff_id : int(11)
* role_in_project : varchar(100)
* join_date : date
v warehouse_assets_system purchase_orders
* id : int(11)
* po_number : varchar(50)
* supplier_id : int(11)
* warehouse_id : int(11)
* department_id : int(11)
* order_date : date
* expected_delivery : date
* actual_delivery : date
* total_amount : decimal(14,2)
* status : enum('draft','pending','approved','partially_received','received','cancelled')
* notes : text
* tender_id : int(11)
* invoice_id : int(11)
* created_by : int(11)
* approved_by : int(11)
* approved_at : timestamp
* created_at : timestamp
* updated_at : timestamp
* budget_id : int(11)
* journal_entry_id : int(11)
* payment_entry_id : int(11)
* item_type : enum('asset','consumable','service','other')
* received_amount : decimal(14,2)
* paid_amount : decimal(14,2)
v warehouse_assets_system purchase_order_items
* id : int(11)
* po_id : int(11)
* item_type : enum('asset','consumable','other')
* item_id : int(11)
* item_name : varchar(255)
* item_code : varchar(100)
* quantity_ordered : decimal(12,2)
* quantity_received : decimal(12,2)
* unit_price : decimal(14,2)
* total_price : decimal(14,2)
* notes : varchar(255)
v warehouse_assets_system regulations
* id : int(11)
* reg_number : varchar(50)
* title : varchar(255)
* category_id : int(11)
* description : text
* content : longtext
* file_path : varchar(255)
* file_name : varchar(255)
* version : varchar(20)
* status : enum('draft','active','archived')
* effective_date : date
* expiry_date : date
* related_module : varchar(50)
* requires_ack : tinyint(1)
* tags : varchar(500)
* views_count : int(11)
* created_by : int(11)
* updated_by : int(11)
* created_at : timestamp
* updated_at : timestamp
v warehouse_assets_system regulation_acknowledgments
* id : int(11)
* regulation_id : int(11)
* user_id : int(11)
* employee_id : int(11)
* acknowledged_at : timestamp
* notes : text
v warehouse_assets_system regulation_categories
* id : int(11)
* name_ar : varchar(100)
* name_en : varchar(100)
* icon : varchar(50)
* color : varchar(20)
* sort_order : int(11)
* is_active : tinyint(1)
* created_at : timestamp
v warehouse_assets_system regulation_reads
* id : int(11)
* regulation_id : int(11)
* user_id : int(11)
* employee_id : int(11)
* read_at : timestamp
v warehouse_assets_system requisitions
* id : int(11)
* request_number : varchar(50)
* employee_id : int(11)
* warehouse_id : int(11)
* reason : text
* priority : enum('normal','urgent','critical')
* status : enum('pending','manager_approved','warehouse_approved','rejected','delivered')
* created_at : timestamp
* updated_at : timestamp
v warehouse_assets_system requisition_approvals
* id : int(11)
* requisition_id : int(11)
* approver_id : int(11)
* approval_level : enum('direct_manager','warehouse_keeper','final')
* decision : enum('approved','rejected')
* comments : text
* decided_at : timestamp
v warehouse_assets_system requisition_items
* id : int(11)
* requisition_id : int(11)
* item_type : enum('asset','consumable')
* item_id : int(11)
* quantity_requested : decimal(12,2)
* quantity_approved : decimal(12,2)
* space_id : int(11)
* quantity_delivered : decimal(12,2)
v warehouse_assets_system requisition_unit_items
* id : bigint(20)
* requisition_id : int(11)
* item_id : int(11)
* unit_id : bigint(20)
* unit_code : varchar(80)
* created_at : timestamp
v warehouse_assets_system research_projects
* id : int(11)
* project_code : varchar(50)
* title_ar : varchar(255)
* title_en : varchar(255)
* project_type : enum('research','development','consulting','infrastructure','other')
* department_id : int(11)
* principal_investigator_id : int(11)
* start_date : date
* end_date : date
* budget : decimal(14,2)
* funding_source : varchar(255)
* status : enum('planning','active','completed','suspended','cancelled')
* description : text
* created_by : int(11)
* created_at : timestamp
* journal_entry_id : int(11)
* expense_account : varchar(20)
* actual_spent : decimal(14,2)
v warehouse_assets_system revenue_entries
* id : int(11)
* entry_number : varchar(30)
* revenue_date : date
* revenue_type : enum('academic','contract','service','rental','training','other')
* account_code : varchar(20)
* payer_name : varchar(255)
* payer_type : enum('student','department','external','other')
* description : varchar(500)
* amount : decimal(14,2)
* vat_amount : decimal(14,2)
* total_amount : decimal(14,2)
* payment_method : enum('cash','bank_transfer','check','other')
* reference_number : varchar(100)
* bank_account : varchar(100)
* journal_entry_id : int(11)
* fiscal_year : smallint(6)
* fiscal_period : tinyint(4)
* status : enum('draft','posted','cancelled')
* notes : text
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system roles
* id : int(11)
* name : varchar(100)
* description : varchar(255)
* created_at : timestamp
v warehouse_assets_system role_permissions
* role_id : int(11)
* permission_id : int(11)
v warehouse_assets_system room_allocations
* id : int(11)
* space_id : int(11)
* academic_course_id : int(11)
* assignment_id : int(11)
* semester_id : int(11)
* allocated_to : varchar(255)
* purpose : enum('lecture','lab','exam','meeting','event','other')
* day_of_week : tinyint(4)
* start_time : time
* end_time : time
* start_date : date
* end_date : date
* recurrence : enum('once','weekly','daily')
* capacity : int(11)
* notes : text
* status : enum('confirmed','tentative','cancelled')
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system scheduled_reports
* id : int(11)
* name : varchar(255)
* report_type : enum('annual_summary','expenses','depreciation','low_stock','custody','maintenance_due','entitlements')
* frequency : enum('daily','weekly','monthly','yearly')
* send_day : tinyint(4)
* send_time : time
* recipients : text
* last_sent : timestamp
* next_send : timestamp
* is_active : tinyint(1)
* parameters : longtext
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system spaces
* id : int(11)
* code : varchar(50)
* name : varchar(255)
* space_type_id : int(11)
* building : varchar(150)
* building_id : int(11)
* floor : varchar(50)
* floor_id : int(11)
* capacity : int(11)
* notes : text
* is_active : tinyint(1)
* created_at : timestamp
* fp_x : decimal(8,2)
* fp_y : decimal(8,2)
* fp_w : decimal(8,2)
* fp_h : decimal(8,2)
* fp_color : varchar(20)
* fp_floor_id : int(11)
v warehouse_assets_system space_assignment_log
* id : bigint(20)
* asset_id : int(11)
* space_id : int(11)
* assigned_date : date
* moved_out_date : date
* assigned_by : int(11)
* notes : varchar(255)
* created_at : timestamp
v warehouse_assets_system space_types
* id : int(11)
* name_ar : varchar(100)
* is_active : tinyint(1)
v warehouse_assets_system staff_monthly_entitlements
* id : int(11)
* staff_id : int(11)
* semester_id : int(11)
* month : tinyint(4)
* year : smallint(6)
* total_theory_hours : decimal(6,1)
* total_practical_hours : decimal(6,1)
* total_extra_hours : decimal(6,1)
* rate_theory : decimal(10,2)
* rate_practical : decimal(10,2)
* rate_extra : decimal(10,2)
* amount_theory : decimal(12,2)
* amount_practical : decimal(12,2)
* amount_extra : decimal(12,2)
* deductions : decimal(12,2)
* net_amount : decimal(12,2)
* status : enum('draft','approved','paid')
* notes : text
* approved_by : int(11)
* approved_at : timestamp
* paid_at : timestamp
* created_at : timestamp
v warehouse_assets_system stock_counts
* id : int(11)
* warehouse_id : int(11)
* count_date : date
* performed_by : int(11)
* status : enum('in_progress','completed')
* count_type : enum('manual','barcode')
v warehouse_assets_system stock_count_items
* id : int(11)
* stock_count_id : int(11)
* item_type : enum('asset','consumable')
* item_id : int(11)
* expected_quantity : decimal(12,2)
* actual_quantity : decimal(12,2)
* difference : decimal(12,2)
* notes : text
v warehouse_assets_system stock_movements
* id : bigint(20)
* item_type : enum('asset','consumable')
* item_id : int(11)
* warehouse_id : int(11)
* movement_date : date
* voucher_number : varchar(100)
* source_destination : varchar(255)
* quantity_in : decimal(12,2)
* quantity_out_actual : decimal(12,2)
* quantity_out_other : decimal(12,2)
* disposal_reason_id : int(11)
* item_condition : enum('new','used','needs_maintenance','damaged')
* balance_after : decimal(14,2)
* notes : text
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system suppliers
* id : int(11)
* name : varchar(255)
* contact_person : varchar(150)
* phone : varchar(50)
* email : varchar(150)
* address : varchar(255)
* tax_number : varchar(100)
* notes : text
* is_active : tinyint(1)
* created_at : timestamp
* rating : decimal(4,2)
* eval_count : int(11)
* category : enum('preferred','approved','conditional','blacklisted')
* bank_name : varchar(150)
* bank_account : varchar(100)
* payment_terms : varchar(100)
v warehouse_assets_system supplier_evaluations
* id : int(11)
* supplier_id : int(11)
* po_id : int(11)
* eval_date : date
* evaluator_id : int(11)
* quality_score : decimal(4,2)
* delivery_score : decimal(4,2)
* price_score : decimal(4,2)
* service_score : decimal(4,2)
* docs_score : decimal(4,2)
* total_score : decimal(5,2)
* percentage : decimal(5,2)
* grade : enum('excellent','very_good','good','acceptable','poor')
* notes : text
* created_at : timestamp
v warehouse_assets_system supplier_invoices
* id : int(11)
* supplier_id : int(11)
* invoice_number : varchar(100)
* invoice_date : date
* due_date : date
* amount : decimal(14,2)
* paid_amount : decimal(14,2)
* currency : varchar(10)
* status : enum('pending','partial','paid','overdue','cancelled')
* related_asset_id : int(11)
* related_po : varchar(100)
* notes : text
* attachment : varchar(255)
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
v warehouse_assets_system supplier_invoices_acc
* id : int(11)
* invoice_number : varchar(50)
* supplier_id : int(11)
* po_id : int(11)
* gr_id : int(11)
* invoice_date : date
* due_date : date
* amount : decimal(14,2)
* vat_amount : decimal(14,2)
* total_amount : decimal(14,2)
* paid_amount : decimal(14,2)
* status : enum('pending','partially_paid','paid','cancelled')
* journal_entry_id : int(11)
* payment_entry_id : int(11)
* notes : text
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system supplier_payments
* id : int(11)
* payment_number : varchar(30)
* supplier_id : int(11)
* invoice_id : int(11)
* payment_date : date
* amount : decimal(14,2)
* payment_method : enum('bank_transfer','check','cash','other')
* bank_account : varchar(100)
* reference_number : varchar(100)
* journal_entry_id : int(11)
* notes : text
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system supplier_price_history
* id : int(11)
* supplier_id : int(11)
* item_name : varchar(255)
* item_code : varchar(100)
* unit_price : decimal(12,2)
* currency : varchar(10)
* price_date : date
* source : enum('po','invoice','quote','manual')
* source_id : int(11)
* notes : varchar(255)
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system system_settings
* setting_key : varchar(100)
* setting_value : text
* setting_type : enum('text','color','file','number','boolean')
* label_ar : varchar(255)
* group_name : varchar(100)
* updated_at : timestamp
v warehouse_assets_system tax_brackets
* id : int(11)
* min_amount : decimal(12,2)
* max_amount : decimal(12,2)
* rate : decimal(5,2)
* description : varchar(200)
v warehouse_assets_system teaching_assignments
* id : int(11)
* staff_id : int(11)
* course_id : int(11)
* semester_id : int(11)
* section_name : varchar(50)
* student_count : int(11)
* teaching_type : enum('theory','practical','both')
* weekly_theory_hours : decimal(4,1)
* weekly_practical_hours : decimal(4,1)
* is_extra : tinyint(1)
* notes : varchar(255)
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system teaching_attendance
* id : int(11)
* assignment_id : int(11)
* session_date : date
* status : enum('present','absent','compensated','holiday')
* actual_hours : decimal(4,1)
* notes : varchar(255)
* recorded_by : int(11)
* created_at : timestamp
v warehouse_assets_system tenders
* id : int(11)
* tender_number : varchar(50)
* title : varchar(255)
* description : text
* tender_type : enum('supply','maintenance','service','construction','other')
* department_id : int(11)
* estimated_value : decimal(14,2)
* publish_date : date
* submission_deadline : date
* opening_date : date
* status : enum('draft','published','closed','awarded','cancelled')
* winner_supplier_id : int(11)
* awarded_amount : decimal(14,2)
* notes : text
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system tender_items
* id : int(11)
* tender_id : int(11)
* item_name : varchar(255)
* quantity : decimal(12,2)
* unit : varchar(50)
* specifications : text
v warehouse_assets_system tender_offers
* id : int(11)
* tender_id : int(11)
* supplier_id : int(11)
* submission_date : date
* total_amount : decimal(14,2)
* delivery_days : int(11)
* warranty_months : int(11)
* technical_score : tinyint(4)
* financial_score : tinyint(4)
* final_score : tinyint(4)
* status : enum('submitted','evaluated','accepted','rejected')
* notes : text
* created_at : timestamp
v warehouse_assets_system tender_offer_items
* id : int(11)
* offer_id : int(11)
* tender_item_id : int(11)
* unit_price : decimal(14,2)
* total_price : decimal(14,2)
* notes : varchar(255)
v warehouse_assets_system users
* id : int(11)
* username : varchar(100)
* password_hash : varchar(255)
* employee_id : int(11)
* role_id : int(11)
* warehouse_id : int(11)
* is_active : tinyint(1)
* two_factor_enabled : tinyint(1)
* two_factor_secret : varchar(255)
* last_login : datetime
* created_at : timestamp
* api_token : varchar(64)
* fcm_token : varchar(255)
v warehouse_assets_system warehouses
* id : int(11)
* name : varchar(150)
* location : varchar(255)
* building_id : int(11)
* manager_id : int(11)
* is_active : tinyint(1)
v warehouse_assets_system warehouse_transfers
* id : int(11)
* item_type : enum('asset','consumable')
* item_id : int(11)
* from_warehouse_id : int(11)
* to_warehouse_id : int(11)
* quantity : decimal(12,2)
* transfer_date : date
* approved_by : int(11)
* notes : text
* created_at : timestamp
v warehouse_assets_system weekly_schedule
* id : int(11)
* assignment_id : int(11)
* semester_id : int(11)
* day_of_week : tinyint(4)
* start_time : time
* end_time : time
* room : varchar(100)
* schedule_type : enum('theory','practical')
* notes : varchar(255)
v warehouse_assets_system workflow_configs
* id : int(11)
* workflow_type : enum('requisition','purchase_order','disposal','maintenance','entitlement')
* step_number : tinyint(4)
* step_name : varchar(100)
* approver_role_id : int(11)
* approver_user_id : int(11)
* condition_field : varchar(100)
* condition_operator : enum('>','<','>=','<=','=','any')
* condition_value : decimal(14,2)
* is_active : tinyint(1)
* notify_on_reach : tinyint(1)
* created_at : timestamp
v warehouse_assets_system work_schedule
* id : int(11)
* name : varchar(100)
* work_start : time
* work_end : time
* late_tolerance : int(11)
* work_days : varchar(20)
* is_default : tinyint(1)
* created_at : timestamp
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship