erp.shahsolutions.in / 127.0.0.1 / isp_stock_management

There are no favourite tables.

Customise appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customise the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Untitled *

v		isp_stock_management app_settings
setting_key : varchar(100)
setting_value : text
updated_by : bigint(20) unsigned
updated_at : timestamp

v		isp_stock_management attendance_requests
id : bigint(20) unsigned
user_id : bigint(20) unsigned
request_type : enum('outside_workplace','work_from_home','holiday')
from_date : date
to_date : date
period : enum('full_day','first_half','second_half','hours')
reason : text
status : enum('pending','approved','rejected')
approved_by : bigint(20) unsigned
approved_at : datetime
admin_remarks : text
created_at : timestamp
updated_at : timestamp

v		isp_stock_management audit_logs
id : bigint(20) unsigned
company_id : bigint(20) unsigned
user_id : bigint(20) unsigned
event : varchar(120)
auditable_type : varchar(150)
auditable_id : bigint(20) unsigned
old_values : longtext
new_values : longtext
url : varchar(255)
ip_address : varchar(45)
user_agent : varchar(255)
device_info : varchar(255)
created_at : timestamp

v		isp_stock_management backup_jobs
id : bigint(20) unsigned
backup_type : enum('database','files','full','offsite')
status : enum('running','success','failed')
started_at : datetime
finished_at : datetime
backup_path : varchar(500)
db_files : int(11)
files_copied : int(11)
files_skipped : int(11)
bytes_copied : bigint(20)
message : text
created_by : bigint(20) unsigned
created_at : timestamp

v		isp_stock_management branches
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_code : varchar(50)
name : varchar(150)
address : text
city : varchar(100)
state : varchar(100)
phone : varchar(30)
email : varchar(150)
is_head_office : tinyint(1)
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
franchisee_id : bigint(20) unsigned

v		isp_stock_management companies
id : bigint(20) unsigned
company_code : varchar(50)
name : varchar(150)
legal_name : varchar(200)
gst_number : varchar(30)
phone : varchar(30)
email : varchar(150)
address : text
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

v		isp_stock_management customers
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
customer_code : varchar(80)
name : varchar(150)
phone : varchar(30)
email : varchar(150)
address : text
latitude : decimal(10,7)
longitude : decimal(10,7)
plan_name : varchar(150)
status : enum('active','inactive','disconnected')
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
franchisee_name : varchar(150)
mac_address : varchar(50)
expiry_at : datetime
sub_package : varchar(150)
ip_address : varchar(45)
nas_ip : varchar(45)
router_serial : varchar(150)
router_type : varchar(80)

v		isp_stock_management departments
id : bigint(20) unsigned
department_code : varchar(50)
name : varchar(150)
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

v		isp_stock_management device_installations
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
product_id : bigint(20) unsigned
serialized_item_id : bigint(20) unsigned
customer_id : bigint(20) unsigned
pop_location_id : bigint(20) unsigned
engineer_id : bigint(20) unsigned
installation_transaction_id : bigint(20) unsigned
install_type : enum('customer','pop')
customer_name_snapshot : varchar(150)
install_address : text
installed_at : timestamp
current_status : enum('active','disconnected','replaced','faulty','under_testing')
monitoring_enabled : tinyint(1)
monitoring_status : enum('unknown','online','offline','warning')
last_movement_transaction_id : bigint(20) unsigned
removed_at : timestamp
removal_transaction_id : bigint(20) unsigned
remarks : text
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

v		isp_stock_management employee_duty_sessions
id : bigint(20) unsigned
user_id : bigint(20) unsigned
duty_date : date
started_at : datetime
ended_at : datetime
start_lat : decimal(10,7)
start_lng : decimal(10,7)
end_lat : decimal(10,7)
end_lng : decimal(10,7)
start_accuracy : decimal(10,2)
end_accuracy : decimal(10,2)
status : enum('on_duty','ended','location_denied')
device_info : varchar(255)
ip_address : varchar(45)
created_at : timestamp
updated_at : timestamp
start_selfie_path : varchar(255)
start_device_id : varchar(120)
end_device_id : varchar(120)
pending_task_end_reason : text
end_selfie_path : varchar(255)
start_meter_reading : decimal(12,2)
end_meter_reading : decimal(12,2)
start_meter_photo_path : varchar(255)
end_meter_photo_path : varchar(255)

v		isp_stock_management employee_location_points
id : bigint(20) unsigned
user_id : bigint(20) unsigned
duty_session_id : bigint(20) unsigned
captured_at : datetime
latitude : decimal(10,7)
longitude : decimal(10,7)
accuracy_m : decimal(10,2)
event_type : enum('login','start_duty','heartbeat','movement','keep_alive','service_started','manual_debug','sync_ok','sync_error','config_error','gps_disabled','location_disabled','location_permission_denied','gps_request_error','task_start','task_done','installation','collection','end_duty','manual')
source : enum('browser','android','ios','system')
device_info : varchar(255)
ip_address : varchar(45)
created_at : timestamp
client_point_id : varchar(80)
synced_from_device_at : datetime
app_version_code : int(11)
app_version_name : varchar(40)
battery_percent : tinyint(3) unsigned

v		isp_stock_management employee_shifts
id : bigint(20) unsigned
shift_name : varchar(120)
start_time : time
end_time : time
late_grace_minutes : int(10) unsigned
standard_hours : decimal(5,2)
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

v		isp_stock_management employee_tracking_tokens
id : bigint(20) unsigned
user_id : int(11)
duty_session_id : bigint(20) unsigned
token_hash : char(64)
expires_at : datetime
revoked_at : datetime
created_at : timestamp

v		isp_stock_management employee_workplace_mappings
id : bigint(20) unsigned
user_id : bigint(20) unsigned
workplace_id : bigint(20) unsigned
created_at : timestamp

v		isp_stock_management erp_broadcast_messages
id : bigint(20) unsigned
title : varchar(160)
message : text
audience_scope : enum('all')
priority : enum('normal','important','urgent')
status : enum('active','inactive')
created_by : bigint(20) unsigned
created_at : timestamp
expires_at : datetime

v		isp_stock_management erp_broadcast_reads
id : bigint(20) unsigned
broadcast_id : bigint(20) unsigned
user_id : bigint(20) unsigned
seen_at : datetime

v		isp_stock_management erp_media_files
id : bigint(20) unsigned
module : varchar(40)
media_type : varchar(80)
linked_type : varchar(80)
linked_id : varchar(120)
local_path : varchar(500)
public_path : varchar(500)
firebase_bucket : varchar(255)
firebase_object : varchar(700)
original_name : varchar(255)
mime_type : varchar(120)
file_size : bigint(20) unsigned
uploaded_by : bigint(20) unsigned
uploaded_at : datetime
created_at : timestamp
updated_at : timestamp

v		isp_stock_management erp_modules
id : bigint(20) unsigned
parent_id : bigint(20) unsigned
module_key : varchar(100)
name : varchar(150)
description : text
url : varchar(255)
sort_order : int(11)
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp

v		isp_stock_management firebase_backup_files
id : bigint(20) unsigned
source_label : varchar(150)
local_path_hash : char(40)
local_path : varchar(700)
object_name : varchar(700)
file_size : bigint(20)
file_mtime : bigint(20)
firebase_generation : varchar(100)
uploaded_at : datetime
created_at : timestamp
updated_at : timestamp

v		isp_stock_management franchisees
id : bigint(20) unsigned
company_id : bigint(20) unsigned
franchisee_code : varchar(50)
franchisee_name : varchar(150)
mobile_number : varchar(30)
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

v		isp_stock_management import_logs
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
import_type : enum('existing_customer_router','opening_stock','product_master','customer_master','router_collection')
original_filename : varchar(255)
stored_file_path : varchar(255)
total_rows : int(10) unsigned
success_rows : int(10) unsigned
failed_rows : int(10) unsigned
status : enum('processing','completed','completed_with_errors','failed')
created_by : bigint(20) unsigned
created_at : timestamp
completed_at : timestamp

v		isp_stock_management import_log_errors
id : bigint(20) unsigned
import_log_id : bigint(20) unsigned
row_number : int(10) unsigned
field_name : varchar(100)
error_message : text
row_payload : longtext
created_at : timestamp

v		isp_stock_management permissions
id : bigint(20) unsigned
permission_key : varchar(120)
module : varchar(80)
display_name : varchar(150)
created_at : timestamp

v		isp_stock_management petrol_allowance_adjustments
id : bigint(20) unsigned
duty_session_id : bigint(20) unsigned
start_meter_reading : decimal(12,2)
end_meter_reading : decimal(12,2)
km_override : decimal(12,2)
amount_override : decimal(14,2)
reason : varchar(500)
updated_by : bigint(20) unsigned
created_at : timestamp
updated_at : timestamp

v		isp_stock_management pop_locations
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
pop_code : varchar(80)
name : varchar(150)
address : text
latitude : decimal(10,7)
longitude : decimal(10,7)
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

v		isp_stock_management products
id : bigint(20) unsigned
company_id : bigint(20) unsigned
product_category_id : bigint(20) unsigned
sku : varchar(80)
name : varchar(150)
brand : varchar(120)
model : varchar(120)
unit_type : enum('pcs','meters','box','roll','pair','set','packet')
serial_required : tinyint(1)
mac_required : tinyint(1)
warranty_required : tinyint(1)
warranty_months : int(10) unsigned
minimum_stock_level : decimal(14,3)
branch_allowed : tinyint(1)
active_monitoring_device : tinyint(1)
qr_barcode_enabled : tinyint(1)
approval_status : enum('draft','pending','approved','rejected')
approved_by : bigint(20) unsigned
approved_at : timestamp
status : enum('active','inactive')
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
stock_movement_class : enum('normal','frequent','rare')
image_required : tinyint(1)
minimum_order_quantity : decimal(14,3)

v		isp_stock_management product_approval_logs
id : bigint(20) unsigned
product_id : bigint(20) unsigned
action : enum('submitted','approved','rejected','reopened')
old_status : varchar(30)
new_status : varchar(30)
remarks : text
acted_by : bigint(20) unsigned
acted_at : timestamp
ip_address : varchar(45)
device_info : varchar(255)

v		isp_stock_management product_categories
id : bigint(20) unsigned
name : varchar(100)
category_type : enum('active','passive','consumable','accessory')
description : text
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp

v		isp_stock_management product_makes
id : bigint(20) unsigned
name : varchar(120)
status : enum('active','inactive')
created_at : timestamp

v		isp_stock_management repair_jobs
id : bigint(20) unsigned
job_no : varchar(80)
company_id : bigint(20) unsigned
serialized_item_id : bigint(20) unsigned
repair_vendor_id : bigint(20) unsigned
fault_reported_by : bigint(20) unsigned
fault_date : date
fault_description : text
dispatch_transaction_id : bigint(20) unsigned
return_transaction_id : bigint(20) unsigned
repair_cost : decimal(12,2)
job_status : enum('open','sent_to_vendor','returned','closed','cancelled')
final_status : enum('usable','repaired','scrap','under_testing','pending')
remarks : text
created_at : timestamp
updated_at : timestamp

v		isp_stock_management repair_vendors
id : bigint(20) unsigned
company_id : bigint(20) unsigned
vendor_code : varchar(80)
name : varchar(150)
contact_person : varchar(150)
phone : varchar(30)
email : varchar(150)
address : text
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

v		isp_stock_management roles
id : bigint(20) unsigned
name : varchar(100)
display_name : varchar(150)
scope : enum('system','company','branch')
is_system_role : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		isp_stock_management role_permissions
role_id : bigint(20) unsigned
permission_id : bigint(20) unsigned
created_at : timestamp

v		isp_stock_management router_collection_visits
id : bigint(20) unsigned
transaction_id : bigint(20) unsigned
engineer_id : bigint(20) unsigned
outcome : varchar(30)
reason : varchar(255)
notes : text
photo_path : varchar(500)
serial_number : varchar(255)
mac_address : varchar(255)
latitude : decimal(10,7)
longitude : decimal(10,7)
accuracy_m : decimal(10,2)
visited_at : datetime
created_at : timestamp

v		isp_stock_management schema_migrations
migration_key : varchar(120)
description : varchar(255)
executed_by : bigint(20) unsigned
executed_at : timestamp

v		isp_stock_management serialized_items
id : bigint(20) unsigned
company_id : bigint(20) unsigned
product_id : bigint(20) unsigned
serial_number : varchar(150)
mac_address : varchar(50)
qr_code : varchar(190)
barcode : varchar(190)
current_location_id : bigint(20) unsigned
current_condition : enum('new','used','faulty','under_testing','repaired','scrap')
lifecycle_status : enum('available','in_transfer','with_engineer','installed','faulty','warranty','repair','testing','scrap','lost')
supplier_id : bigint(20) unsigned
purchase_invoice_no : varchar(100)
purchase_date : date
warranty_start_date : date
warranty_end_date : date
is_installed : tinyint(1)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

v		isp_stock_management stock_adjustment_requests
id : bigint(20) unsigned
request_no : varchar(80)
company_id : bigint(20) unsigned
location_id : bigint(20) unsigned
product_id : bigint(20) unsigned
serialized_item_id : bigint(20) unsigned
requested_quantity_change : decimal(14,3)
reason : text
approval_status : enum('pending','approved','rejected')
approved_by : bigint(20) unsigned
approved_at : timestamp
stock_transaction_id : bigint(20) unsigned
created_by : bigint(20) unsigned
created_at : timestamp
updated_at : timestamp

v		isp_stock_management stock_balances
id : bigint(20) unsigned
company_id : bigint(20) unsigned
location_id : bigint(20) unsigned
product_id : bigint(20) unsigned
stock_condition : enum('new','used','faulty','under_testing','repaired','scrap')
quantity : decimal(14,3)
updated_at : timestamp

v		isp_stock_management stock_employee_transfers
id : bigint(20) unsigned
transfer_no : varchar(80)
stock_transaction_id : bigint(20) unsigned
stock_transaction_item_id : bigint(20) unsigned
from_user_id : bigint(20) unsigned
to_user_id : bigint(20) unsigned
installed_status : enum('pending','installed','not_installed','partial_installed')
status : enum('pending','accepted','cancelled')
reason : text
accepted_at : timestamp
created_by : bigint(20) unsigned
created_at : timestamp
updated_at : timestamp

v		isp_stock_management stock_locations
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
location_code : varchar(80)
name : varchar(150)
location_type : enum('head_office','branch_store','noc','field_engineer','customer','pop','supplier','repair_vendor','scrap')
user_id : bigint(20) unsigned
customer_id : bigint(20) unsigned
pop_location_id : bigint(20) unsigned
supplier_id : bigint(20) unsigned
repair_vendor_id : bigint(20) unsigned
is_stock_available_location : tinyint(1)
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

v		isp_stock_management stock_partial_installations
id : bigint(20) unsigned
stock_transaction_item_id : bigint(20) unsigned
installed_qty : decimal(14,3)
balance_qty : decimal(14,3)
customer_reference : varchar(150)
proof_image_path : varchar(255)
remarks : text
installed_by : bigint(20) unsigned
installed_at : timestamp
created_at : timestamp
deleted_at : timestamp

v		isp_stock_management stock_summary_cache
company_id : bigint(20) unsigned
location_id : bigint(20) unsigned
product_id : bigint(20) unsigned
inward_qty : decimal(14,3)
outward_qty : decimal(14,3)
stock_qty : decimal(14,3)
updated_at : timestamp

v		isp_stock_management stock_transactions
id : bigint(20) unsigned
transaction_no : varchar(80)
transaction_type : enum('purchase_inward','opening_stock_import','ho_to_branch_transfer','branch_to_ho_transfer','branch_to_branch_transfer','ho_to_noc','noc_to_branch','branch_to_field_engineer','field_engineer_to_customer_installation','customer_disconnect_return','customer_upgrade_replacement','faulty_replacement','warranty_return_to_supplier','repair_vendor_dispatch','repair_vendor_return','noc_testing','pop_installation','scrap','stock_adjustment')
company_id : bigint(20) unsigned
from_location_id : bigint(20) unsigned
to_location_id : bigint(20) unsigned
customer_id : bigint(20) unsigned
pop_location_id : bigint(20) unsigned
engineer_id : bigint(20) unsigned
supplier_id : bigint(20) unsigned
repair_vendor_id : bigint(20) unsigned
related_transaction_id : bigint(20) unsigned
transaction_at : timestamp
dispatch_confirmed_at : timestamp
received_confirmed_at : timestamp
approval_status : enum('not_required','pending','approved','rejected')
approved_by : bigint(20) unsigned
approved_at : timestamp
status : enum('draft','pending_dispatch','dispatched','pending_receive','received','completed','cancelled','rejected')
remarks : text
supporting_document_path : varchar(255)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
ip_address : varchar(45)
device_info : varchar(255)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
person_name : varchar(150)
last_visit_at : datetime
last_visit_outcome : varchar(30)
last_visit_reason : varchar(255)
last_visit_photo_path : varchar(500)
last_visit_latitude : decimal(10,7)
last_visit_longitude : decimal(10,7)
last_visit_accuracy : decimal(10,2)
last_visit_by : bigint(20) unsigned

v		isp_stock_management stock_transaction_items
id : bigint(20) unsigned
stock_transaction_id : bigint(20) unsigned
product_id : bigint(20) unsigned
serialized_item_id : bigint(20) unsigned
quantity : decimal(14,3)
unit_type : varchar(30)
condition_before : enum('new','used','faulty','under_testing','repaired','scrap')
condition_after : enum('new','used','faulty','under_testing','repaired','scrap')
serial_number : varchar(150)
mac_address : varchar(50)
remarks : text
created_at : timestamp
installed_status : enum('pending','installed','not_installed','partial_installed')
installation_proof_path : varchar(255)
installation_marked_by : bigint(20) unsigned
installation_marked_at : timestamp
returned_from_item_id : bigint(20) unsigned
installation_purpose : varchar(40)
customer_username : varchar(100)
replacement_reason : varchar(150)
old_router_serial : varchar(150)
old_router_mac : varchar(80)
old_router_collected : tinyint(1)
stock_purpose : varchar(20)

v		isp_stock_management suppliers
id : bigint(20) unsigned
company_id : bigint(20) unsigned
supplier_code : varchar(80)
name : varchar(150)
contact_person : varchar(150)
phone : varchar(30)
email : varchar(150)
address : text
gst_number : varchar(30)
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
supplier_name : varchar(150)
supplier_type : enum('supplier','repair_vendor','both','other_vendor')
mobile_number : varchar(30)

v		isp_stock_management task_activity_logs
id : bigint(20) unsigned
task_instance_id : bigint(20) unsigned
actor_user_id : bigint(20) unsigned
event_type : varchar(40)
message : text
created_at : timestamp
attachment_path : varchar(255)
attachment_name : varchar(180)
edited_at : datetime
seen_at : datetime

v		isp_stock_management task_instances
id : bigint(20) unsigned
template_id : bigint(20) unsigned
title : varchar(180)
description : text
assigned_to_user_id : bigint(20) unsigned
assigned_by_user_id : bigint(20) unsigned
due_at : datetime
priority : enum('low','normal','high','urgent')
proof_required : tinyint(1)
proof_path : varchar(255)
completion_remarks : text
points : decimal(8,2)
status : enum('pending','in_progress','submitted','approved','rejected','overdue','cancelled')
completed_at : datetime
approved_by : bigint(20) unsigned
approved_at : datetime
created_at : timestamp
updated_at : timestamp
not_completed_reason : text
carried_forward_from_id : bigint(20) unsigned
approver_user_id : bigint(20) unsigned
tat_minutes : int(10) unsigned

v		isp_stock_management task_observers
task_instance_id : bigint(20) unsigned
observer_user_id : bigint(20) unsigned
added_by_user_id : bigint(20) unsigned
created_at : timestamp

v		isp_stock_management task_reminders
id : bigint(20) unsigned
task_instance_id : bigint(20) unsigned
from_user_id : bigint(20) unsigned
to_user_id : bigint(20) unsigned
message : varchar(255)
status : enum('sent','seen')
created_at : timestamp
seen_at : datetime

v		isp_stock_management task_templates
id : bigint(20) unsigned
title : varchar(180)
description : text
department : varchar(80)
assigned_to_user_id : bigint(20) unsigned
assigned_by_user_id : bigint(20) unsigned
priority : enum('low','normal','high','urgent')
recurrence : enum('once','hourly','daily','weekly','biweekly','monthly','quarterly','yearly')
start_date : date
due_day : tinyint(3) unsigned
due_time : time
proof_required : tinyint(1)
points : decimal(8,2)
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
approver_user_id : bigint(20) unsigned
tat_minutes : int(10) unsigned

v		isp_stock_management task_template_observers
task_template_id : bigint(20) unsigned
observer_user_id : bigint(20) unsigned
added_by_user_id : bigint(20) unsigned
created_at : timestamp

v		isp_stock_management users
id : bigint(20) unsigned
company_id : bigint(20) unsigned
primary_branch_id : bigint(20) unsigned
role_id : bigint(20) unsigned
employee_code : varchar(50)
name : varchar(150)
email : varchar(150)
phone : varchar(30)
password : varchar(255)
sso_provider : varchar(80)
sso_subject : varchar(190)
status : enum('active','inactive','blocked')
last_login_at : timestamp
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp
attendance_anywhere : tinyint(1)
attendance_device_id : varchar(120)
attendance_device_registered_at : datetime
attendance_device_reset_at : datetime
attendance_device_reset_by : bigint(20) unsigned
department_id : bigint(20) unsigned
shift_id : bigint(20) unsigned
alternate_mobile : varchar(20)
nearest_relative_contact : varchar(30)
blood_group : varchar(20)
employee_address : text
employee_id_proof_path : varchar(255)
employee_photo_path : varchar(255)
tracking_required : tinyint(1)
salary_amount : decimal(12,2)
salary_effective_from : date
allow_apple_web_login : tinyint(1)
apple_web_device_hash : varchar(128)
apple_web_device_registered_at : datetime
apple_web_device_reset_at : datetime
apple_web_device_reset_by : bigint(20) unsigned
date_of_birth : date
employee_id_proof_type : varchar(80)
employee_id_proof_number : varchar(100)
bike_meter_required : tinyint(1)

v		isp_stock_management user_branch_mappings
id : bigint(20) unsigned
user_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
can_issue_stock : tinyint(1)
can_receive_stock : tinyint(1)
can_install_device : tinyint(1)
created_at : timestamp

v		isp_stock_management user_franchisee_mappings
id : bigint(20) unsigned
user_id : bigint(20) unsigned
franchisee_name : varchar(150)
created_at : timestamp

v		isp_stock_management user_remember_tokens
id : bigint(20) unsigned
user_id : bigint(20) unsigned
selector : varchar(40)
validator_hash : char(64)
expires_at : datetime
user_agent : varchar(255)
ip_address : varchar(64)
created_at : timestamp
last_used_at : datetime
revoked_at : datetime

v		isp_stock_management vw_serial_trace
serialized_item_id : bigint(20) unsigned
serial_number : varchar(150)
mac_address : varchar(50)
sku : varchar(80)
product_name : varchar(150)
lifecycle_status : enum('available','in_transfer','with_engineer','installed','faulty','warranty','repair','testing','scrap','lost')
current_condition : enum('new','used','faulty','under_testing','repaired','scrap')
current_location : varchar(150)
current_location_type : enum('head_office','branch_store','noc','field_engineer','customer','pop','supplier','repair_vendor','scrap')
transaction_no : varchar(80)
transaction_type : enum('purchase_inward','opening_stock_import','ho_to_branch_transfer','branch_to_ho_transfer','branch_to_branch_transfer','ho_to_noc','noc_to_branch','branch_to_field_engineer','field_engineer_to_customer_installation','customer_disconnect_return','customer_upgrade_replacement','faulty_replacement','warranty_return_to_supplier','repair_vendor_dispatch','repair_vendor_return','noc_testing','pop_installation','scrap','stock_adjustment')
transaction_at : timestamp
from_location : varchar(150)
to_location : varchar(150)
remarks : text

v		isp_stock_management vw_stock_on_hand
company_name : varchar(150)
location_name : varchar(150)
location_type : enum('head_office','branch_store','noc','field_engineer','customer','pop','supplier','repair_vendor','scrap')
branch_name : varchar(150)
category_name : varchar(100)
sku : varchar(80)
product_name : varchar(150)
brand : varchar(120)
model : varchar(120)
stock_condition : enum('new','used','faulty','under_testing','repaired','scrap')
quantity : decimal(14,3)
unit_type : enum('pcs','meters','box','roll','pair','set','packet')
minimum_stock_level : decimal(14,3)
is_low_stock : int(1)

v		isp_stock_management warranty_claims
id : bigint(20) unsigned
claim_no : varchar(80)
company_id : bigint(20) unsigned
serialized_item_id : bigint(20) unsigned
supplier_id : bigint(20) unsigned
fault_reported_by : bigint(20) unsigned
fault_date : date
fault_description : text
dispatch_transaction_id : bigint(20) unsigned
return_transaction_id : bigint(20) unsigned
claim_status : enum('open','sent_to_supplier','replacement_received','repaired_received','rejected','closed')
final_status : enum('usable','repaired','scrap','under_testing','pending')
remarks : text
created_at : timestamp
updated_at : timestamp

v		isp_stock_management workplaces
id : bigint(20) unsigned
workplace_code : varchar(50)
name : varchar(150)
latitude : decimal(10,7)
longitude : decimal(10,7)
radius_m : int(10) unsigned
status : enum('active','inactive')
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

Create relationship
FOREIGN KEY
on delete
on update