将文件拖动至此

SQL 上传 ( 0 ) x -

页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令：
调试 SQL
数量
运行顺序
用时
排序条件：
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 : 用时 :
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
未命名 *
v 显示/隐藏表格列表 全屏查看 从其他数据库中添加表 新页面 打开页面 保存页面 保存页面为 删除页 新建数据表 创建关系 选择要显示的字段 重新载入 帮助 折角连接 / 直接连接 对齐网格 v 全部收缩/展开 反向收缩/展开 显示/隐藏关系线 导出架构 > 移动菜单 > 固定文字
v v
数据表数量： 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)
* faculty_id : int(11)
* academic_dept_id : int(11)
* year_level : enum('1','2','3','4','5','6','all')
* credit_hours : int(11)
* theory_hours : int(11)
* practical_hours : int(11)
* level : tinyint(4)
* is_active : tinyint(1)
* is_shared : tinyint(1)
* shared_departments : text
* notes : text
* created_at : timestamp
v warehouse_assets_system academic_departments
* id : int(11)
* name_ar : varchar(200)
* name_en : varchar(200)
* code : varchar(30)
* faculty_id : int(11)
* head_staff_id : int(11)
* specialization_start_year : tinyint(1)
* has_specializations : tinyint(1)
* established_year : year(4)
* is_active : tinyint(1)
* 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_sections
* id : int(11)
* academic_year_id : int(11)
* semester_id : int(11)
* name : varchar(50)
* gender : enum('mixed','male','female')
* max_students : int(11)
* current_students : int(11)
* space_id : int(11)
* is_active : tinyint(1)
* 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)
* faculty_id : int(11)
* academic_dept_id : int(11)
* section_name : varchar(100)
* office_location : varchar(100)
* specialization : varchar(200)
* secondary_specialization : varchar(200)
* academic_degree : enum('phd','master','bachelor','diploma')
* is_visiting : tinyint(1)
* home_institution : varchar(200)
* available_days : varchar(20)
* available_start_hour : tinyint(4)
* available_end_hour : tinyint(4)
* graduation_university : varchar(200)
* graduation_year : year(4)
* 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('pending','active','on_leave','suspended','retired','rejected')
* notes : text
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system academic_years
* id : int(11)
* name_ar : varchar(100)
* year_number : tinyint(4)
* faculty_id : int(11)
* dept_id : int(11)
* is_general : tinyint(1)
* time_offset_hours : decimal(3,1)
* total_students : int(11)
* is_active : tinyint(1)
* 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)
* housing_city_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 attendance_sessions
* id : int(11)
* slot_id : int(11)
* session_date : date
* qr_token : varchar(64)
* expires_at : datetime
* created_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 auto_reorder_requests
* id : int(11)
* consumable_id : int(11)
* current_stock : decimal(12,2)
* reorder_quantity : decimal(12,2)
* status : enum('pending','approved','rejected','ordered')
* created_at : timestamp
* approved_by : int(11)
* approved_at : timestamp
* notes : text
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)
* reorder_point : decimal(12,2)
* reorder_quantity : decimal(12,2)
* avg_daily_consumption : decimal(10,4)
* last_reorder_date : date
* warehouse_id : int(11)
* supplier_id : int(11)
* image : varchar(255)
* is_active : tinyint(1)
* created_at : timestamp
* account_code : varchar(20)
* housing_city_id : int(11)
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 course_sections
* id : int(11)
* semester_id : int(11)
* course_id : int(11)
* section_name : varchar(50)
* student_count : int(11)
* max_capacity : int(11)
* gender : enum('mixed','male','female')
* assignment_id : int(11)
* space_id : int(11)
* notes : varchar(255)
* created_by : int(11)
* created_at : timestamp
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)
* department_type : enum('administrative','academic','service')
* 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
* zk_user_id : varchar(20)
v warehouse_assets_system employee_contracts
* id : int(11)
* contract_number : varchar(50)
* employee_id : int(11)
* contract_type : enum('permanent','temporary','part_time','probation','renewal')
* start_date : date
* end_date : date
* basic_salary : decimal(12,2)
* housing_allowance : decimal(10,2)
* transport_allowance : decimal(10,2)
* meal_allowance : decimal(10,2)
* other_allowances : decimal(10,2)
* working_hours : decimal(4,1)
* working_days : tinyint(4)
* probation_months : tinyint(4)
* notice_period_days : int(11)
* status : enum('draft','active','expired','terminated','renewed')
* termination_reason : text
* termination_date : date
* journal_entry_id : int(11)
* notes : text
* attachment : varchar(255)
* created_by : int(11)
* created_at : timestamp
* updated_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 employee_shifts
* id : int(11)
* employee_id : int(11)
* shift_id : int(11)
* work_date : date
* created_at : timestamp
v warehouse_assets_system employee_work_schedule
* id : int(11)
* employee_id : int(11)
* schedule_id : int(11)
* effective_from : date
* effective_to : date
* notes : text
* created_at : timestamp
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 faculties
* id : int(11)
* name_ar : varchar(200)
* name_en : varchar(200)
* code : varchar(20)
* dean_name : varchar(200)
* dean_staff_id : int(11)
* established_year : year(4)
* is_active : tinyint(1)
* 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 housing_academic_years
* id : int(11)
* year_label : varchar(20)
* is_active : tinyint(1)
* start_date : date
* end_date : date
* created_at : timestamp
v warehouse_assets_system housing_applications
* id : int(11)
* student_name : varchar(200)
* student_code : varchar(50)
* payment_code : varchar(50)
* gender : enum('male','female')
* nationality : enum('egyptian','foreign')
* city_id : int(11)
* national_id : varchar(14)
* faculty : varchar(100)
* study_year : varchar(50)
* prev_grade : varchar(50)
* medical_result : varchar(100)
* medical_date : date
* housing_notice_date : date
* religion : varchar(50)
* student_phone : varchar(20)
* father_name : varchar(200)
* father_national_id : varchar(14)
* father_phone : varchar(20)
* father_job : varchar(100)
* father_address : text
* guardian_name : varchar(200)
* guardian_national_id : varchar(14)
* guardian_phone : varchar(20)
* guardian_relation : varchar(50)
* guardian_address : text
* guardian_abroad : tinyint(1)
* parents_status : enum('both_alive','one_dead','both_dead')
* room_type : enum('single','double','special_needs')
* student_type : enum('new','returning')
* period_id : int(11)
* meal_plan : tinyint(1)
* health_condition : tinyint(1)
* health_notes : text
* student_photo : varchar(500)
* documents_pdf : varchar(500)
* emergency_name : varchar(200)
* emergency_phone : varchar(20)
* emergency_alt_phone : varchar(20)
* emergency_relation : varchar(50)
* status : enum('pending','approved','rejected','waitlist','evacuated')
* academic_year : varchar(20)
* notes : text
* rejection_reason : text
* room_number : varchar(20)
* checkin_date : date
* checkout_date : date
* evacuation_reason : enum('normal','administrative','other')
* evacuation_notes : text
* fees_amount : decimal(10,2)
* fees_paid : decimal(10,2)
* payment_status : enum('unpaid','partial','paid')
* journal_entry_id : int(11)
* receivable_id : int(11)
* created_at : timestamp
* updated_at : timestamp
* created_by : int(11)
* reviewed_by : int(11)
* reviewed_at : timestamp
* waitlist_priority : int(11)
v warehouse_assets_system housing_application_periods
* id : int(11)
* academic_year_id : int(11)
* student_type : enum('returning','new','all')
* start_date : date
* end_date : date
* is_active : tinyint(1)
* notes : text
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
v warehouse_assets_system housing_cities
* id : int(11)
* name : varchar(200)
* address : text
* gender : enum('male','female')
* capacity : int(11)
* buildings_count : int(11)
* rooms_single : int(11)
* rooms_double : int(11)
* rooms_special : int(11)
* buildings : text
* is_active : tinyint(1)
* notes : text
* created_at : timestamp
v warehouse_assets_system housing_city_custody
* id : int(11)
* city_id : int(11)
* item_type : enum('asset','consumable')
* item_id : int(11)
* item_name : varchar(300)
* quantity : decimal(10,2)
* unit : varchar(50)
* location_in_city : varchar(200)
* assigned_date : date
* assigned_by : int(11)
* status : enum('active','returned','damaged','lost')
* notes : text
* created_at : timestamp
* updated_at : timestamp
v warehouse_assets_system housing_complaints
* id : int(11)
* application_id : int(11)
* type : enum('maintenance','complaint','suggestion','other')
* category : enum('plumbing','electrical','furniture','cleanliness','noise','security','internet','other')
* title : varchar(255)
* description : text
* priority : enum('low','medium','high','urgent')
* status : enum('open','in_progress','resolved','closed','rejected')
* assigned_to : int(11)
* resolved_at : timestamp
* resolution_notes : text
* journal_entry_id : int(11)
* maintenance_cost : decimal(10,2)
* attachment : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v warehouse_assets_system housing_complaint_updates
* id : int(11)
* complaint_id : int(11)
* note : text
* status_change : varchar(50)
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system housing_documents
* id : int(11)
* application_id : int(11)
* doc_type : enum('national_id','photo','acceptance_letter','medical','other')
* doc_name : varchar(200)
* file_path : varchar(500)
* uploaded_at : timestamp
* notes : text
v warehouse_assets_system housing_items_catalog
* id : int(11)
* category_id : int(11)
* item_type : enum('asset','consumable')
* name_ar : varchar(300)
* name_en : varchar(300)
* unit : varchar(50)
* description : text
* account_code : varchar(20)
* estimated_value : decimal(10,2)
* useful_life_years : int(11)
* is_active : tinyint(1)
* sort_order : int(11)
* created_at : timestamp
v warehouse_assets_system housing_item_categories
* id : int(11)
* name_ar : varchar(200)
* item_type : enum('asset','consumable')
* account_code : varchar(20)
* description : text
* is_active : tinyint(1)
* created_at : timestamp
v warehouse_assets_system housing_leaves
* id : int(11)
* application_id : int(11)
* leave_type : enum('exit_permit','daily_leave','weekend_leave','emergency_leave','vacation')
* leave_date : date
* return_date : date
* leave_time : time
* return_time : time
* destination : varchar(255)
* purpose : text
* guardian_name : varchar(200)
* guardian_phone : varchar(20)
* guardian_relation : varchar(100)
* status : enum('pending','approved','rejected','returned')
* approved_by : int(11)
* approved_at : timestamp
* notes : text
* created_at : timestamp
v warehouse_assets_system housing_monthly_installments
* id : int(11)
* application_id : int(11)
* month_year : varchar(7)
* amount : decimal(10,2)
* due_date : date
* paid_date : date
* payment_id : int(11)
* status : enum('pending','paid','late','waived')
* journal_entry_id : int(11)
* notes : text
* created_at : timestamp
v warehouse_assets_system housing_notifications
* id : int(11)
* application_id : int(11)
* student_name : varchar(200)
* student_phone : varchar(20)
* type : enum('sms','whatsapp','email','system')
* event : enum('applied','approved','rejected','waitlist','evacuated','payment','payment_reminder','monthly_fee','update_rejected')
* message : text
* status : enum('pending','sent','failed')
* error_msg : text
* sent_at : timestamp
* created_at : timestamp
v warehouse_assets_system housing_notification_settings
* id : int(11)
* setting_key : varchar(100)
* setting_value : text
* description : varchar(255)
v warehouse_assets_system housing_otp
* id : int(11)
* application_id : int(11)
* otp_code : varchar(6)
* phone : varchar(20)
* expires_at : timestamp
* used : tinyint(1)
* created_at : timestamp
v warehouse_assets_system housing_payments
* id : int(11)
* application_id : int(11)
* amount : decimal(10,2)
* payment_date : date
* month_year : varchar(7)
* payment_type : varchar(50)
* payment_method : enum('cash','bank_transfer','check','other')
* status : enum('pending','confirmed','cancelled')
* receipt_number : varchar(50)
* notes : text
* journal_entry_id : int(11)
* receivable_id : int(11)
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system housing_policies
* id : int(11)
* title : varchar(255)
* category : enum('general','financial','behavior','safety','maintenance','other')
* content : text
* is_active : tinyint(1)
* sort_order : int(11)
* created_by : int(11)
* created_at : timestamp
* updated_at : timestamp
v warehouse_assets_system housing_rooms
* id : int(11)
* city_id : int(11)
* room_number : varchar(20)
* building : varchar(50)
* floor : tinyint(2)
* room_type : enum('single','double','special_needs','administrative')
* capacity : tinyint(2)
* current_occupancy : tinyint(2)
* is_active : tinyint(1)
* notes : text
v warehouse_assets_system housing_room_prices
* id : int(11)
* city_id : int(11)
* room_type : enum('single','double','special_needs')
* price_per_month : decimal(10,2)
* academic_year : varchar(20)
* is_active : tinyint(1)
* notes : text
* created_at : timestamp
v warehouse_assets_system housing_update_requests
* id : int(11)
* application_id : int(11)
* request_type : varchar(100)
* old_value : text
* new_value : text
* status : enum('pending','approved','rejected')
* admin_notes : text
* created_at : timestamp
* reviewed_at : timestamp
* reviewed_by : int(11)
v warehouse_assets_system housing_violations
* id : int(11)
* application_id : int(11)
* violation_type : enum('late_payment','noise','damage','absence','smoking','other')
* description : text
* fine_amount : decimal(10,2)
* fine_paid : decimal(10,2)
* fine_status : enum('unpaid','partial','paid','waived')
* severity : enum('minor','moderate','major')
* incident_date : date
* action_taken : text
* status : enum('open','resolved','appealed')
* created_by : int(11)
* created_at : timestamp
* resolved_at : timestamp
* journal_entry_id : int(11)
v warehouse_assets_system housing_violation_payments
* id : int(11)
* violation_id : int(11)
* amount : decimal(10,2)
* payment_date : date
* receipt_number : varchar(50)
* notes : text
* created_by : int(11)
* created_at : timestamp
v warehouse_assets_system housing_visits
* id : int(11)
* application_id : int(11)
* visitor_name : varchar(200)
* visitor_national_id : varchar(20)
* visitor_phone : varchar(20)
* visitor_relation : varchar(100)
* visit_date : date
* visit_time_in : time
* visit_time_out : time
* purpose : text
* status : enum('scheduled','checked_in','checked_out','cancelled')
* notes : text
* approved_by : int(11)
* created_at : timestamp
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
* font_name_size : tinyint(4)
* font_natid_size : tinyint(4)
* font_job_size : tinyint(4)
* show_website : tinyint(1)
* website_url : varchar(100)
* show_signature : tinyint(1)
* barcode_height : tinyint(4)
* photo_height : tinyint(4)
* qr_size : tinyint(4)
* card_gradient : varchar(200)
* text_color : varchar(20)
* show_natid_label : tinyint(1)
* website_bottom : tinyint(4)
* website_font_size : tinyint(4)
* website_color : varchar(30)
* photo_width : tinyint(4)
* show_dept : tinyint(1)
* signature_height : tinyint(4)
* signature_name : varchar(100)
* signature_title : varchar(200)
* font_code_size : tinyint(4)
* border_radius : tinyint(4)
* logo_size : tinyint(4)
v warehouse_assets_system internal_messages
* id : int(11)
* sender_id : int(11)
* receiver_id : int(11)
* subject : varchar(255)
* body : text
* priority : enum('normal','high','urgent')
* label : varchar(50)
* is_starred : tinyint(1)
* broadcast_dept_id : int(11)
* attachment : varchar(255)
* is_read : tinyint(1)
* read_at : timestamp
* is_deleted_sender : tinyint(1)
* is_deleted_receiver : tinyint(1)
* parent_id : 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 lecture_notifications
* id : int(11)
* slot_id : int(11)
* staff_id : int(11)
* notify_type : enum('1hour','15min','day_before')
* notify_date : date
* sent_at : timestamp
* is_sent : tinyint(1)
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 otp_codes
* id : int(11)
* user_id : int(11)
* code : varchar(6)
* expires_at : datetime
* is_used : tinyint(1)
* created_at : timestamp
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 schedule_policies
* id : int(11)
* policy_key : varchar(100)
* policy_name : varchar(200)
* policy_value : varchar(500)
* value_type : enum('integer','boolean','time','json','text')
* category : enum('time','staff','rooms','distribution','constraints')
* description : text
* min_value : varchar(50)
* max_value : varchar(50)
* is_active : tinyint(1)
* updated_by : int(11)
* updated_at : timestamp
v warehouse_assets_system schedule_slots
* id : int(11)
* assignment_id : int(11)
* semester_id : int(11)
* space_id : int(11)
* day_of_week : tinyint(4)
* start_time : time
* end_time : time
* slot_type : enum('theory','practical')
* group_name : varchar(50)
* notes : varchar(255)
* 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)
* space_category : enum('academic','administrative','service')
* department_id : int(11)
* responsible_id : int(11)
* building : varchar(150)
* building_id : int(11)
* floor : varchar(50)
* floor_id : int(11)
* capacity : int(11)
* notes : text
* equipment : 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)
* has_projector : tinyint(1)
* has_ac : tinyint(1)
* has_internet : tinyint(1)
* has_smartboard : tinyint(1)
* computer_count : int(11)
* status : enum('available','occupied','maintenance','closed')
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)
* category : enum('academic','administrative','service')
* icon : varchar(10)
* color : varchar(20)
* description : varchar(255)
* 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_consumption_log
* id : int(11)
* consumable_id : int(11)
* consumed_qty : decimal(12,2)
* log_date : date
* 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 students
* id : int(11)
* student_code : varchar(30)
* full_name : varchar(255)
* full_name_en : varchar(255)
* national_id : varchar(14)
* faculty_id : int(11)
* dept_id : int(11)
* academic_year_id : int(11)
* section_id : int(11)
* gender : enum('male','female')
* email : varchar(255)
* phone : varchar(20)
* enrollment_year : year(4)
* gpa : decimal(4,2)
* photo : varchar(255)
* status : enum('active','suspended','graduated','transferred','withdrawn')
* notes : text
* created_at : timestamp
v warehouse_assets_system student_attendance
* id : int(11)
* slot_id : int(11)
* attendance_date : date
* student_name : varchar(255)
* student_id : varchar(50)
* student_db_id : int(11)
* status : enum('present','absent','late','excused')
* section_name : varchar(50)
* scan_time : timestamp
* ip_address : varchar(45)
* selfie_photo : varchar(255)
* device_fingerprint : varchar(64)
v warehouse_assets_system student_courses
* id : int(11)
* student_id : int(11)
* course_id : int(11)
* semester_id : int(11)
* section_id : int(11)
* assignment_id : int(11)
* midterm_grade : decimal(5,2)
* final_grade : decimal(5,2)
* practical_grade : decimal(5,2)
* total_grade : decimal(5,2)
* grade_letter : varchar(5)
* attendance_pct : decimal(5,2)
* status : enum('enrolled','passed','failed','withdrawn','incomplete')
* registered_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)
* section_id : int(11)
* group_type : enum('regular','shared','visiting')
* shared_depts : text
* space_preference : int(11)
* 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 upload_ip_log
* id : int(11)
* ip : varchar(45)
* user_agent : varchar(500)
* national_id : varchar(14)
* student_name : varchar(200)
* file_type : enum('photo','documents')
* file_name : varchar(200)
* file_size : int(11)
* action : enum('upload','rejected')
* reject_reason : varchar(200)
* created_at : timestamp
v warehouse_assets_system users
* id : int(11)
* username : varchar(100)
* password_hash : varchar(255)
* employee_id : int(11)
* academic_staff_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)
* must_change_password : tinyint(1)
v warehouse_assets_system v_schedule_conflicts
* slot1_id : int(11)
* slot2_id : int(11)
* day_of_week : tinyint(4)
* start_time : time
* end_time : time
* room_name : varchar(255)
* slot1_label : varchar(513)
* slot2_label : varchar(513)
* conflict_type : varchar(14)
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
* early_leave_tolerance : int(11)
* break_duration : int(11)
* break_start : time
* break_end : time
* total_hours : decimal(4,2)
* overtime_allowed : tinyint(4)
* notes : text
v warehouse_assets_system work_shifts
* id : int(11)
* schedule_id : int(11)
* shift_name : varchar(100)
* shift_start : time
* shift_end : time
* late_tolerance : int(11)
* early_tolerance : int(11)
* break_duration : int(11)
* sort_order : int(11)
* is_active : tinyint(4)
* created_at : timestamp
v warehouse_assets_system zk_attendance_log
* id : int(11)
* employee_id : int(11)
* zk_user_id : varchar(20)
* punch_time : datetime
* punch_type : tinyint(4)
* synced_at : timestamp
v warehouse_assets_system zk_devices
* id : int(11)
* name : varchar(100)
* ip : varchar(50)
* port : int(11)
* is_active : tinyint(4)
* location : varchar(200)
* model : varchar(100)
* serial : varchar(100)
* last_sync : datetime
* notes : text
* created_at : timestamp
创建关系
FOREIGN KEY
on delete
on update
删除关系