2025-06-23 23:36:34,634 WARNING database DDL Query made to DB: create table `tabSubcontracting Receipt` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140) default '{supplier_name}', `naming_series` varchar(140), `supplier` varchar(140), `supplier_name` varchar(140), `supplier_delivery_note` varchar(140), `company` varchar(140), `posting_date` date, `posting_time` time(6), `set_posting_time` int(1) not null default 0, `is_return` int(1) not null default 0, `return_against` varchar(140), `cost_center` varchar(140), `project` varchar(140), `set_warehouse` varchar(140), `rejected_warehouse` varchar(140), `supplier_warehouse` varchar(140), `total_qty` decimal(21,9) not null default 0, `total` decimal(21,9) not null default 0, `in_words` varchar(240), `bill_no` varchar(140), `bill_date` date, `supplier_address` varchar(140), `contact_person` varchar(140), `address_display` text, `contact_display` text, `contact_mobile` text, `contact_email` text, `shipping_address` varchar(140), `shipping_address_display` text, `billing_address` varchar(140), `billing_address_display` text, `distribute_additional_costs_based_on` varchar(140) default 'Qty', `total_additional_costs` decimal(21,9) not null default 0, `amended_from` varchar(140), `range` varchar(140), `represents_company` varchar(140), `status` varchar(140) default 'Draft', `per_returned` decimal(21,9) not null default 0, `auto_repeat` varchar(140), `letter_head` varchar(140), `language` varchar(140), `instructions` text, `select_print_heading` varchar(140), `remarks` text, `transporter_name` varchar(140), `lr_no` varchar(140), `lr_date` date, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `supplier`(`supplier`), index `posting_date`(`posting_date`), index `status`(`status`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:34,751 WARNING database DDL Query made to DB: create table `tabSubcontracting Order Service Item` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `item_code` varchar(140), `item_name` varchar(140), `qty` decimal(21,9) not null default 0, `rate` decimal(21,9) not null default 0, `amount` decimal(21,9) not null default 0, `fg_item` varchar(140), `fg_item_qty` decimal(21,9) not null default 1.0, `purchase_order_item` varchar(140), `material_request` varchar(140), `material_request_item` varchar(140), index `item_code`(`item_code`), index `purchase_order_item`(`purchase_order_item`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:34,840 WARNING database DDL Query made to DB: create table `tabCode List` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140), `canonical_uri` varchar(140), `url` varchar(140), `default_common_code` varchar(140), `version` varchar(140), `publisher` varchar(140), `publisher_id` varchar(140), `description` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:34,931 WARNING database DDL Query made to DB: create table `tabCommon Code` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `code_list` varchar(140), `title` varchar(300), `common_code` varchar(300), `description` text, `additional_data` longtext, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `code_list`(`code_list`), index `common_code`(`common_code`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:34,988 WARNING database DDL Query made to DB: ALTER TABLE `tabCommon Code` ADD INDEX IF NOT EXISTS `code_list_common_code_index`(code_list, common_code) 2025-06-23 23:36:39,332 WARNING database DDL Query made to DB: ALTER TABLE `tabAddress` ADD COLUMN `tax_category` varchar(140), ADD COLUMN `is_your_company_address` int(1) not null default 0 2025-06-23 23:36:39,412 WARNING database DDL Query made to DB: ALTER TABLE `tabContact` ADD COLUMN `is_billing_contact` int(1) not null default 0 2025-06-23 23:36:40,349 WARNING database DDL Query made to DB: create table `tabLeave Block List Date` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `block_date` date, `reason` text, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:40,459 WARNING database DDL Query made to DB: create table `tabTraining Program` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `training_program` varchar(140), `status` varchar(140) default 'Scheduled', `company` varchar(140), `trainer_name` varchar(140), `trainer_email` varchar(140), `supplier` varchar(140), `contact_number` varchar(140), `description` longtext, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:40,548 WARNING database DDL Query made to DB: create table `tabShift Location` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `location_name` varchar(140) unique, `checkin_radius` int(11) not null default 0, `latitude` decimal(21,9) not null default 0, `longitude` decimal(21,9) not null default 0, `geolocation` longtext, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:40,654 WARNING database DDL Query made to DB: create table `tabExpense Taxes and Charges` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `account_head` varchar(140), `rate` decimal(21,9) not null default 0, `tax_amount` decimal(21,9) not null default 0, `total` decimal(21,9) not null default 0, `description` text, `cost_center` varchar(140), `project` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:40,735 WARNING database DDL Query made to DB: create table `tabExpense Claim Advance` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee_advance` varchar(140), `posting_date` date, `advance_paid` decimal(21,9) not null default 0, `unclaimed_amount` decimal(21,9) not null default 0, `return_amount` decimal(21,9) not null default 0, `allocated_amount` decimal(21,9) not null default 0, `advance_account` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:40,849 WARNING database DDL Query made to DB: create table `tabEmployee Advance` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `employee` varchar(140), `employee_name` varchar(140), `posting_date` date, `company` varchar(140), `department` varchar(140), `currency` varchar(140), `exchange_rate` decimal(21,9) not null default 0, `purpose` text, `advance_amount` decimal(21,9) not null default 0, `paid_amount` decimal(21,9) not null default 0, `pending_amount` decimal(21,9) not null default 0, `claimed_amount` decimal(21,9) not null default 0, `return_amount` decimal(21,9) not null default 0, `advance_account` varchar(140), `mode_of_payment` varchar(140), `repay_unclaimed_amount_from_salary` int(1) not null default 0, `status` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:41,062 WARNING database DDL Query made to DB: create table `tabShift Schedule` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `shift_type` varchar(140), `frequency` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `amended_from`(`amended_from`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:41,152 WARNING database DDL Query made to DB: create table `tabOffer Term` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `offer_term` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:41,237 WARNING database DDL Query made to DB: create table `tabGrievance Type` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `description` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:41,341 WARNING database DDL Query made to DB: create table `tabTravel Request Costing` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `expense_type` varchar(140), `sponsored_amount` decimal(21,9) not null default 0, `funded_amount` decimal(21,9) not null default 0, `total_amount` decimal(21,9) not null default 0, `comments` text, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:41,418 WARNING database DDL Query made to DB: create table `tabEmployee Feedback Criteria` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `criteria` varchar(140) unique, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:41,527 WARNING database DDL Query made to DB: create table `tabVehicle Log` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `license_plate` varchar(140), `employee` varchar(140), `model` varchar(140), `make` varchar(140), `date` date, `odometer` int(11) not null default 0, `last_odometer` int(11) not null default 0, `fuel_qty` decimal(21,9) not null default 0, `price` decimal(21,9) not null default 0, `supplier` varchar(140), `invoice` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:41,618 WARNING database DDL Query made to DB: create table `tabEmployee Promotion` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `salary_currency` varchar(140), `promotion_date` date, `company` varchar(140), `current_ctc` decimal(21,9) not null default 0, `revised_ctc` decimal(21,9) not null default 0, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:41,730 WARNING database DDL Query made to DB: create table `tabEmployee Grievance` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `subject` varchar(140), `raised_by` varchar(140), `employee_name` varchar(140), `designation` varchar(140), `date` date, `status` varchar(140) default 'Open', `reports_to` varchar(140), `grievance_against_party` varchar(140), `grievance_against` varchar(140), `grievance_type` varchar(140), `associated_document_type` varchar(140), `associated_document` varchar(140), `description` text, `cause_of_grievance` text, `resolved_by` varchar(140), `resolution_date` date, `employee_responsible` varchar(140), `resolution_detail` text, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:41,838 WARNING database DDL Query made to DB: create table `tabInterest` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `interest` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:41,945 WARNING database DDL Query made to DB: create table `tabInterview Round` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `round_name` varchar(140) unique, `interview_type` varchar(140), `expected_average_rating` decimal(3,2), `designation` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:42,048 WARNING database DDL Query made to DB: create table `tabDaily Work Summary Group User` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `user` varchar(140), `email` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:42,127 WARNING database DDL Query made to DB: create table `tabEmployee Health Insurance` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `health_insurance_name` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:42,226 WARNING database DDL Query made to DB: create table `tabShift Request` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `shift_type` varchar(140), `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `status` varchar(140) default 'Draft', `company` varchar(140), `approver` varchar(140), `from_date` date, `to_date` date, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:42,331 WARNING database DDL Query made to DB: create table `tabEmployee Transfer` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `transfer_date` date, `company` varchar(140), `new_company` varchar(140), `department` varchar(140), `reallocate_leaves` int(1) not null default 0, `create_new_employee_id` int(1) not null default 0, `new_employee_id` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:42,426 WARNING database DDL Query made to DB: create table `tabEmployee Grade` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `default_salary_structure` varchar(140), `currency` varchar(140), `default_base_pay` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:42,547 WARNING database DDL Query made to DB: create table `tabEmployee Checkin` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `log_type` varchar(140), `shift` varchar(140), `time` datetime(6), `device_id` varchar(140), `skip_auto_attendance` int(1) not null default 0, `attendance` varchar(140), `latitude` decimal(21,9) not null default 0, `longitude` decimal(21,9) not null default 0, `geolocation` longtext, `shift_start` datetime(6), `shift_end` datetime(6), `offshift` int(1) not null default 0, `shift_actual_start` datetime(6), `shift_actual_end` datetime(6), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `shift`(`shift`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:42,654 WARNING database DDL Query made to DB: create table `tabCompensatory Leave Request` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `leave_type` varchar(140), `leave_allocation` varchar(140), `work_from_date` date, `work_end_date` date, `half_day` int(1) not null default 0, `half_day_date` date, `reason` text, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:42,750 WARNING database DDL Query made to DB: create table `tabDaily Work Summary` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `daily_work_summary_group` varchar(140), `status` varchar(140) default 'Open', `email_sent_to` longtext, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:42,936 WARNING database DDL Query made to DB: create table `tabAttendance` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `employee` varchar(140), `employee_name` varchar(140), `working_hours` decimal(21,9) not null default 0, `status` varchar(140) default 'Present', `leave_type` varchar(140), `leave_application` varchar(140), `attendance_date` date, `company` varchar(140), `department` varchar(140), `attendance_request` varchar(140), `half_day_status` varchar(140), `shift` varchar(140), `in_time` datetime(6), `out_time` datetime(6), `late_entry` int(1) not null default 0, `early_exit` int(1) not null default 0, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `status`(`status`), index `attendance_date`(`attendance_date`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:43,030 WARNING database DDL Query made to DB: create table `tabIdentification Document Type` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `identification_document_type` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:43,113 WARNING database DDL Query made to DB: create table `tabTraining Result` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `training_event` varchar(140) unique, `amended_from` varchar(140), `employee_emails` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:43,233 WARNING database DDL Query made to DB: create table `tabLeave Application` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `employee` varchar(140), `employee_name` varchar(140), `leave_type` varchar(140), `company` varchar(140), `department` varchar(140), `from_date` date, `to_date` date, `half_day` int(1) not null default 0, `half_day_date` date, `total_leave_days` decimal(21,9) not null default 0, `description` text, `leave_balance` decimal(21,9) not null default 0, `leave_approver` varchar(140), `leave_approver_name` varchar(140), `follow_via_email` int(1) not null default 1, `posting_date` date, `status` varchar(140) default 'Open', `salary_slip` varchar(140), `color` varchar(140), `letter_head` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `leave_type`(`leave_type`), index `from_date`(`from_date`), index `to_date`(`to_date`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:43,313 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Application` ADD INDEX IF NOT EXISTS `employee_from_date_to_date_index`(employee, from_date, to_date) 2025-06-23 23:36:43,368 WARNING database DDL Query made to DB: create table `tabEmployee Boarding Activity` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `activity_name` varchar(140), `user` varchar(140), `role` varchar(140), `begin_on` int(11) not null default 0, `duration` int(11) not null default 0, `task` varchar(140), `task_weight` decimal(21,9) not null default 0, `required_for_employee_creation` int(1) not null default 0, `description` longtext, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:43,457 WARNING database DDL Query made to DB: create table `tabLeave Policy Assignment` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `company` varchar(140), `leave_policy` varchar(140), `carry_forward` int(1) not null default 0, `assignment_based_on` varchar(140), `leave_period` varchar(140), `effective_from` date, `effective_to` date, `leaves_allocated` int(1) not null default 0, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:43,542 WARNING database DDL Query made to DB: create table `tabDepartment Approver` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `approver` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:43,618 WARNING database DDL Query made to DB: create table `tabJob Offer Term Template` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140) unique, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:43,704 WARNING database DDL Query made to DB: create table `tabSkill` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `skill_name` varchar(140) unique, `description` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:43,815 WARNING database DDL Query made to DB: create table `tabEmployee Performance Feedback` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `designation` varchar(140), `company` varchar(140), `reviewer` varchar(140), `reviewer_name` varchar(140), `reviewer_designation` varchar(140), `user` varchar(140), `added_on` datetime(6), `appraisal_cycle` varchar(140), `appraisal` varchar(140), `total_score` decimal(21,9) not null default 0, `feedback` longtext, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:43,962 WARNING database DDL Query made to DB: create table `tabAppraisal Cycle` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `cycle_name` varchar(140) unique, `company` varchar(140), `status` varchar(140) default 'Not Started', `start_date` date, `end_date` date, `description` longtext, `kra_evaluation_method` varchar(140) default 'Automated Based on Goal Progress', `calculate_final_score_based_on_formula` int(1) not null default 0, `final_score_formula` longtext, `branch` varchar(140), `department` varchar(140), `designation` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:44,071 WARNING database DDL Query made to DB: create table `tabShift Schedule Assignment` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `company` varchar(140), `shift_schedule` varchar(140), `shift_location` varchar(140), `shift_status` varchar(140) default 'Active', `enabled` int(1) not null default 1, `create_shifts_after` date, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:44,161 WARNING database DDL Query made to DB: create table `tabEmployee Feedback Rating` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `criteria` varchar(140), `per_weightage` decimal(21,9) not null default 0, `rating` decimal(3,2), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:44,243 WARNING database DDL Query made to DB: create table `tabAppraisee` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `appraisal_template` varchar(140), `department` varchar(140), `designation` varchar(140), `branch` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:44,334 WARNING database DDL Query made to DB: create table `tabTraining Feedback` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `course` varchar(140), `training_event` varchar(140), `event_name` varchar(140), `trainer_name` varchar(140), `feedback` text, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:44,445 WARNING database DDL Query made to DB: create table `tabJob Requisition` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `designation` varchar(140), `department` varchar(140), `no_of_positions` int(11) not null default 0, `expected_compensation` decimal(21,9) not null default 0, `company` varchar(140), `status` varchar(140), `requested_by` varchar(140), `requested_by_name` varchar(140), `requested_by_dept` varchar(140), `requested_by_designation` varchar(140), `posting_date` date, `completed_on` date, `expected_by` date, `time_to_fill` decimal(21,9), `description` longtext, `reason_for_requesting` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:44,547 WARNING database DDL Query made to DB: create table `tabInterview` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `interview_round` varchar(140), `job_applicant` varchar(140), `job_opening` varchar(140), `designation` varchar(140), `resume_link` varchar(140), `status` varchar(140) default 'Pending', `scheduled_on` date, `from_time` time(6), `to_time` time(6), `expected_average_rating` decimal(3,2), `average_rating` decimal(3,2), `interview_summary` text, `reminded` int(1) not null default 0, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:44,645 WARNING database DDL Query made to DB: create table `tabLeave Period` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `from_date` date, `to_date` date, `is_active` int(1) not null default 0, `company` varchar(140), `optional_holiday_list` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:44,744 WARNING database DDL Query made to DB: create table `tabAppraisal Goal` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `kra` text, `per_weightage` decimal(21,9) not null default 0, `score` decimal(21,9) not null default 0, `score_earned` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:44,841 WARNING database DDL Query made to DB: create table `tabShift Assignment` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `company` varchar(140), `department` varchar(140), `shift_type` varchar(140), `shift_location` varchar(140), `status` varchar(140) default 'Active', `start_date` date, `end_date` date, `shift_request` varchar(140), `shift_schedule_assignment` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `shift_type`(`shift_type`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:44,960 WARNING database DDL Query made to DB: create table `tabLeave Encashment` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `company` varchar(140), `leave_period` varchar(140), `leave_type` varchar(140), `leave_allocation` varchar(140), `leave_balance` decimal(21,9) not null default 0, `actual_encashable_days` decimal(21,9) not null default 0, `encashment_days` decimal(21,9) not null default 0, `encashment_amount` decimal(21,9) not null default 0, `pay_via_payment_entry` int(1) not null default 0, `expense_account` varchar(140), `payable_account` varchar(140), `posting_date` date, `currency` varchar(140), `paid_amount` decimal(21,9) not null default 0, `cost_center` varchar(140), `encashment_date` date, `additional_salary` varchar(140), `amended_from` varchar(140), `status` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:45,073 WARNING database DDL Query made to DB: create table `tabTraining Event Employee` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `status` varchar(140) default 'Open', `attendance` varchar(140), `is_mandatory` int(1) not null default 1, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:45,163 WARNING database DDL Query made to DB: create table `tabLeave Block List` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `leave_block_list_name` varchar(140) unique, `company` varchar(140), `applies_to_all_departments` int(1) not null default 0, `leave_type` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:45,257 WARNING database DDL Query made to DB: create table `tabEmployee Onboarding Template` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140), `company` varchar(140), `department` varchar(140), `designation` varchar(140), `employee_grade` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:45,340 WARNING database DDL Query made to DB: create table `tabEmployee Property History` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `property` varchar(140), `current` varchar(140), `new` varchar(140), `fieldname` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:45,437 WARNING database DDL Query made to DB: create table `tabShift Type` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `start_time` time(6), `end_time` time(6), `holiday_list` varchar(140), `color` varchar(140) default 'Blue', `enable_auto_attendance` int(1) not null default 0, `determine_check_in_and_check_out` varchar(140), `working_hours_calculation_based_on` varchar(140), `begin_check_in_before_shift_start_time` int(11) not null default 60, `allow_check_out_after_shift_end_time` int(11) not null default 60, `mark_auto_attendance_on_holidays` int(1) not null default 0, `working_hours_threshold_for_half_day` decimal(21,9) not null default 0, `working_hours_threshold_for_absent` decimal(21,9) not null default 0, `process_attendance_after` date, `last_sync_of_checkin` datetime(6), `auto_update_last_sync` int(1) not null default 0, `enable_late_entry_marking` int(1) not null default 0, `late_entry_grace_period` int(11) not null default 0, `enable_early_exit_marking` int(1) not null default 0, `early_exit_grace_period` int(11) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:45,528 WARNING database DDL Query made to DB: create table `tabVehicle Service` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `service_item` varchar(140), `type` varchar(140), `frequency` varchar(140), `expense_amount` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:45,632 WARNING database DDL Query made to DB: create table `tabTravel Request` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `travel_type` varchar(140), `travel_funding` varchar(140), `travel_proof` text, `purpose_of_travel` varchar(140), `details_of_sponsor` varchar(140), `employee` varchar(140), `employee_name` varchar(140), `cell_number` varchar(140), `prefered_email` varchar(140), `company` varchar(140), `date_of_birth` date, `personal_id_type` varchar(140), `personal_id_number` varchar(140), `passport_number` varchar(140), `description` text, `cost_center` varchar(140), `name_of_organizer` varchar(140), `address_of_organizer` varchar(140), `other_details` text, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:45,710 WARNING database DDL Query made to DB: create table `tabJob Applicant Source` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `source_name` varchar(140), `details` longtext, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:45,794 WARNING database DDL Query made to DB: create table `tabExpense Claim Type` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `deferred_expense_account` int(1) not null default 0, `expense_type` varchar(140) unique, `description` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:45,898 WARNING database DDL Query made to DB: create table `tabEmployee Onboarding` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `job_applicant` varchar(140), `job_offer` varchar(140), `employee_onboarding_template` varchar(140), `company` varchar(140), `boarding_status` varchar(140) default 'Pending', `project` varchar(140), `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `designation` varchar(140), `employee_grade` varchar(140), `holiday_list` varchar(140), `date_of_joining` date, `boarding_begins_on` date, `notify_users_by_email` int(1) not null default 0, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:46,074 WARNING database DDL Query made to DB: create table `tabExpense Claim Detail` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `expense_date` date, `expense_type` varchar(140), `default_account` varchar(140), `description` longtext, `amount` decimal(21,9) not null default 0, `sanctioned_amount` decimal(21,9) not null default 0, `cost_center` varchar(140), `project` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:46,161 WARNING database DDL Query made to DB: create table `tabTravel Itinerary` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `travel_from` varchar(140), `travel_to` varchar(140), `mode_of_travel` varchar(140), `meal_preference` varchar(140), `travel_advance_required` int(1) not null default 0, `advance_amount` varchar(140), `departure_date` datetime(6), `arrival_date` datetime(6), `lodging_required` int(1) not null default 0, `preferred_area_for_lodging` varchar(140), `check_in_date` date, `check_out_date` date, `other_details` text, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:46,236 WARNING database DDL Query made to DB: create table `tabAppraisal KRA` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `kra` varchar(140), `per_weightage` decimal(21,9) not null default 0, `goal_completion` decimal(21,9) not null default 0, `goal_score` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:46,321 WARNING database DDL Query made to DB: create table `tabStaffing Plan` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `company` varchar(140), `department` varchar(140), `from_date` date, `to_date` date, `total_estimated_budget` decimal(21,9) not null default 0, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:46,404 WARNING database DDL Query made to DB: create table `tabAppointment Letter content` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140), `description` longtext, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:46,500 WARNING database DDL Query made to DB: create table `tabEmployee Separation` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `designation` varchar(140), `employee_grade` varchar(140), `company` varchar(140), `boarding_status` varchar(140) default 'Pending', `resignation_letter_date` date, `boarding_begins_on` date, `project` varchar(140), `employee_separation_template` varchar(140), `notify_users_by_email` int(1) not null default 0, `exit_interview` longtext, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:46,612 WARNING database DDL Query made to DB: create table `tabLeave Allocation` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `company` varchar(140), `leave_type` varchar(140), `from_date` date, `to_date` date, `new_leaves_allocated` decimal(21,9) not null default 0, `carry_forward` int(1) not null default 0, `unused_leaves` decimal(21,9) not null default 0, `total_leaves_allocated` decimal(21,9) not null default 0, `total_leaves_encashed` decimal(21,9) not null default 0, `compensatory_request` varchar(140), `leave_period` varchar(140), `leave_policy` varchar(140), `leave_policy_assignment` varchar(140), `carry_forwarded_leaves_count` decimal(21,9) not null default 0, `expired` int(1) not null default 0, `amended_from` varchar(140), `description` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `employee_name`(`employee_name`), index `leave_type`(`leave_type`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:46,697 WARNING database DDL Query made to DB: create table `tabLeave Policy Detail` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `leave_type` varchar(140), `annual_allocation` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:46,774 WARNING database DDL Query made to DB: create table `tabAppraisal Template Goal` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `key_result_area` varchar(140), `per_weightage` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:46,857 WARNING database DDL Query made to DB: create table `tabTraining Result Employee` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `hours` decimal(21,9) not null default 0, `grade` varchar(140), `comments` text, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:47,084 WARNING database DDL Query made to DB: create table `tabExit Interview` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `employee` varchar(140), `employee_name` varchar(140), `email` varchar(140), `company` varchar(140), `status` varchar(140), `date` date, `department` varchar(140), `designation` varchar(140), `reports_to` varchar(140), `date_of_joining` date, `relieving_date` date, `ref_doctype` varchar(140), `questionnaire_email_sent` int(1) not null default 0, `reference_document_name` varchar(140), `interview_summary` longtext, `employee_status` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:47,175 WARNING database DDL Query made to DB: create sequence if not exists pwa_notification_id_seq nocache nocycle 2025-06-23 23:36:47,190 WARNING database DDL Query made to DB: create table `tabPWA Notification` ( name bigint primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `to_user` varchar(140), `from_user` varchar(140), `message` longtext, `read` int(1) not null default 0, `reference_document_type` varchar(140), `reference_document_name` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `to_user`(`to_user`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:47,285 WARNING database DDL Query made to DB: create table `tabLeave Policy` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:47,402 WARNING database DDL Query made to DB: create table `tabLeave Ledger Entry` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `leave_type` varchar(140), `transaction_type` varchar(140), `transaction_name` varchar(140), `company` varchar(140), `leaves` decimal(21,9) not null default 0, `from_date` date, `to_date` date, `holiday_list` varchar(140), `is_carry_forward` int(1) not null default 0, `is_expired` int(1) not null default 0, `is_lwp` int(1) not null default 0, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `transaction_type`(`transaction_type`), index `transaction_name`(`transaction_name`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:47,474 WARNING database DDL Query made to DB: ALTER TABLE `tabLeave Ledger Entry` ADD INDEX IF NOT EXISTS `transaction_type_transaction_name_index`(transaction_type, transaction_name) 2025-06-23 23:36:47,532 WARNING database DDL Query made to DB: create table `tabJob Offer` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `job_applicant` varchar(140), `applicant_name` varchar(140), `applicant_email` varchar(140), `status` varchar(140), `offer_date` date, `designation` varchar(140), `company` varchar(140), `job_offer_term_template` varchar(140), `select_terms` varchar(140), `terms` longtext, `letter_head` varchar(140), `select_print_heading` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:47,615 WARNING database DDL Query made to DB: create table `tabVehicle Service Item` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `service_item` varchar(140) unique, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:47,717 WARNING database DDL Query made to DB: create table `tabFull and Final Statement` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `transaction_date` date, `company` varchar(140), `status` varchar(140) default 'Unpaid', `amended_from` varchar(140), `date_of_joining` date, `relieving_date` date, `designation` varchar(140), `department` varchar(140), `total_asset_recovery_cost` decimal(21,9) not null default 0, `total_payable_amount` decimal(21,9) not null default 0, `total_receivable_amount` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:47,811 WARNING database DDL Query made to DB: create table `tabSkill Assessment` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `skill` varchar(140), `rating` decimal(3,2), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:47,896 WARNING database DDL Query made to DB: create table `tabInterview Feedback` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `interview` varchar(140), `interview_round` varchar(140), `job_applicant` varchar(140), `interviewer` varchar(140), `result` varchar(140), `average_rating` decimal(3,2), `feedback` text, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:48,013 WARNING database DDL Query made to DB: create table `tabJob Applicant` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `applicant_name` varchar(140), `email_id` varchar(140), `phone_number` varchar(140), `country` varchar(140), `job_title` varchar(140), `designation` varchar(140), `status` varchar(140), `source` varchar(140), `source_name` varchar(140), `employee_referral` varchar(140), `applicant_rating` decimal(3,2), `notes` varchar(140), `cover_letter` text, `resume_attachment` text, `resume_link` varchar(140), `currency` varchar(140), `lower_range` decimal(21,9) not null default 0, `upper_range` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `job_title`(`job_title`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:48,093 WARNING database DDL Query made to DB: create table `tabJob Offer Term` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `offer_term` varchar(140), `value` text, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:48,172 WARNING database DDL Query made to DB: create table `tabKRA` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140) unique, `description` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:48,255 WARNING database DDL Query made to DB: create table `tabStaffing Plan Detail` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `designation` varchar(140), `vacancies` int(11) not null default 0, `estimated_cost_per_position` decimal(21,9) not null default 0, `total_estimated_cost` decimal(21,9) not null default 0, `current_count` int(11) not null default 0, `current_openings` int(11) not null default 0, `number_of_positions` int(11) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:48,357 WARNING database DDL Query made to DB: create table `tabAttendance Request` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `company` varchar(140), `from_date` date, `to_date` date, `half_day` int(1) not null default 0, `half_day_date` date, `include_holidays` int(1) not null default 0, `shift` varchar(140), `reason` varchar(140), `explanation` text, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:48,460 WARNING database DDL Query made to DB: create table `tabAppointment Letter Template` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `template_name` varchar(140) unique, `introduction` longtext, `closing_notes` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:48,597 WARNING database DDL Query made to DB: create table `tabJob Opening` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `job_title` varchar(140), `designation` varchar(140), `status` varchar(140), `posted_on` datetime(6), `closes_on` date, `closed_on` date, `company` varchar(140), `department` varchar(140), `employment_type` varchar(140), `location` varchar(140), `staffing_plan` varchar(140), `planned_vacancies` int(11) not null default 0, `job_requisition` varchar(140), `vacancies` int(11) not null default 0, `publish` int(1) not null default 0, `route` varchar(140) unique, `publish_applications_received` int(1) not null default 1, `job_application_route` varchar(140), `description` longtext, `currency` varchar(140), `lower_range` decimal(21,9) not null default 0, `upper_range` decimal(21,9) not null default 0, `salary_per` varchar(140) default 'Month', `publish_salary_range` int(1) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:48,679 WARNING database DDL Query made to DB: create table `tabInterview Type` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `description` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:48,779 WARNING database DDL Query made to DB: create table `tabDaily Work Summary Group` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `enabled` int(1) not null default 1, `send_emails_at` varchar(140), `holiday_list` varchar(140), `subject` varchar(140) default 'What did you work on today?', `message` longtext default '

Please share what did you do today. If you reply by midnight, your response will be recorded!

', `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:48,945 WARNING database DDL Query made to DB: create table `tabInterviewer` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `user` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:49,042 WARNING database DDL Query made to DB: create table `tabFull and Final Outstanding Statement` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `component` varchar(140), `reference_document_type` varchar(140), `reference_document` varchar(140), `account` varchar(140), `paid_via_salary_slip` int(1) not null default 0, `amount` decimal(21,9) not null default 0, `status` varchar(140) default 'Unsettled', `remark` text, index `reference_document`(`reference_document`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:49,123 WARNING database DDL Query made to DB: create table `tabExpected Skill Set` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `skill` varchar(140), `description` text, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:49,205 WARNING database DDL Query made to DB: create table `tabEmployment Type` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee_type_name` varchar(140) unique, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:49,305 WARNING database DDL Query made to DB: create table `tabAppraisal Template` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `template_title` varchar(140) unique, `description` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:49,402 WARNING database DDL Query made to DB: create table `tabEmployee Training` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `training` varchar(140), `training_date` date, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:49,529 WARNING database DDL Query made to DB: create table `tabExpense Claim` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `company` varchar(140), `expense_approver` varchar(140), `approval_status` varchar(140) default 'Draft', `total_sanctioned_amount` decimal(21,9) not null default 0, `total_taxes_and_charges` decimal(21,9) not null default 0, `total_advance_amount` decimal(21,9) not null default 0, `grand_total` decimal(21,9) not null default 0, `total_claimed_amount` decimal(21,9) not null default 0, `total_amount_reimbursed` decimal(21,9) not null default 0, `posting_date` date, `is_paid` int(1) not null default 0, `mode_of_payment` varchar(140), `payable_account` varchar(140), `clearance_date` date, `remark` text, `project` varchar(140), `cost_center` varchar(140), `status` varchar(140) default 'Draft', `task` varchar(140), `amended_from` varchar(140), `delivery_trip` varchar(140), `vehicle_log` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `approval_status`(`approval_status`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:49,666 WARNING database DDL Query made to DB: create table `tabAppraisal` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `naming_series` varchar(140), `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `designation` varchar(140), `employee_image` text, `company` varchar(140), `appraisal_cycle` varchar(140), `start_date` date, `end_date` date, `final_score` decimal(21,9) not null default 0, `appraisal_template` varchar(140), `rate_goals_manually` int(1) not null default 0, `goal_score_percentage` decimal(21,9) not null default 0, `remarks` text, `total_score` decimal(21,9) not null default 0, `avg_feedback_score` decimal(21,9) not null default 0, `self_score` decimal(21,9) not null default 0, `reflections` longtext, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:49,804 WARNING database DDL Query made to DB: create table `tabLeave Type` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `leave_type_name` varchar(140) unique, `max_leaves_allowed` decimal(21,9) not null default 0, `applicable_after` int(11) not null default 0, `max_continuous_days_allowed` int(11) not null default 0, `is_carry_forward` int(1) not null default 0, `is_lwp` int(1) not null default 0, `is_ppl` int(1) not null default 0, `fraction_of_daily_salary_per_leave` decimal(21,9) not null default 0, `is_optional_leave` int(1) not null default 0, `allow_negative` int(1) not null default 0, `allow_over_allocation` int(1) not null default 0, `include_holiday` int(1) not null default 0, `is_compensatory` int(1) not null default 0, `maximum_carry_forwarded_leaves` decimal(21,9) not null default 0, `expire_carry_forwarded_leaves_after_days` int(11) not null default 0, `allow_encashment` int(1) not null default 0, `max_encashable_leaves` int(11) not null default 0, `non_encashable_leaves` int(11) not null default 0, `earning_component` varchar(140), `is_earned_leave` int(1) not null default 0, `earned_leave_frequency` varchar(140), `allocate_on_day` varchar(140) default 'Last Day', `rounding` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:49,900 WARNING database DDL Query made to DB: create table `tabInterview Detail` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `interviewer` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:49,987 WARNING database DDL Query made to DB: create table `tabEmployee Skill Map` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140) unique, `employee_name` varchar(140), `designation` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:50,082 WARNING database DDL Query made to DB: create table `tabAppointment Letter` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `job_applicant` varchar(140), `applicant_name` varchar(140), `company` varchar(140), `appointment_date` date, `appointment_letter_template` varchar(140), `introduction` longtext, `closing_notes` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:50,214 WARNING database DDL Query made to DB: create table `tabFull and Final Asset` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `reference` varchar(140), `asset_name` varchar(140), `date` datetime(6), `actual_cost` decimal(21,9) not null default 0, `cost` decimal(21,9) not null default 0, `account` varchar(140), `action` varchar(140) default 'Return', `status` varchar(140), `description` text, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:50,321 WARNING database DDL Query made to DB: create table `tabEmployee Referral` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `first_name` varchar(140), `last_name` varchar(140), `full_name` varchar(140), `date` date, `status` varchar(140), `for_designation` varchar(140), `email` varchar(140) unique, `contact_no` varchar(140), `resume_link` varchar(140), `current_employer` varchar(140), `current_job_title` varchar(140), `resume` text, `referrer` varchar(140), `referrer_name` varchar(140), `is_applicable_for_referral_bonus` int(1) not null default 1, `referral_payment_status` varchar(140), `department` varchar(140), `qualification_reason` longtext, `work_references` longtext, `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:50,422 WARNING database DDL Query made to DB: create table `tabPurpose of Travel` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `purpose_of_travel` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:50,503 WARNING database DDL Query made to DB: create table `tabLeave Block List Allow` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `allow_user` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:50,581 WARNING database DDL Query made to DB: create table `tabExpense Claim Account` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `company` varchar(140), `default_account` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:50,658 WARNING database DDL Query made to DB: create table `tabDesignation Skill` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `skill` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:50,770 WARNING database DDL Query made to DB: create table `tabGoal` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `goal_name` varchar(140), `is_group` int(1) not null default 0, `parent_goal` varchar(140), `progress` decimal(21,9) not null default 0, `status` varchar(140) default 'Pending', `employee` varchar(140), `employee_name` varchar(140), `company` varchar(140), `user` varchar(140), `start_date` date, `end_date` date, `appraisal_cycle` varchar(140), `kra` varchar(140), `description` longtext, `lft` int(11) not null default 0, `rgt` int(11) not null default 0, `old_parent` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:50,876 WARNING database DDL Query made to DB: create table `tabEmployee Separation Template` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `title` varchar(140), `company` varchar(140), `department` varchar(140), `designation` varchar(140), `employee_grade` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:50,989 WARNING database DDL Query made to DB: create table `tabTraining Event` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `event_name` varchar(140) unique, `training_program` varchar(140), `event_status` varchar(140), `has_certificate` int(1) not null default 0, `type` varchar(140), `level` varchar(140), `company` varchar(140), `trainer_name` varchar(140), `trainer_email` varchar(140), `supplier` varchar(140), `contact_number` varchar(140), `course` varchar(140), `location` varchar(140), `start_time` datetime(6), `end_time` datetime(6), `introduction` longtext, `amended_from` varchar(140), `employee_emails` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:51,075 WARNING database DDL Query made to DB: create table `tabEmployee Skill` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `skill` varchar(140), `proficiency` decimal(3,2), `evaluation_date` date, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:51,904 WARNING database DDL Query made to DB: create table `tabEmployee Benefit Claim` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `claim_date` date, `currency` varchar(140), `company` varchar(140), `amended_from` varchar(140), `earning_component` varchar(140), `max_amount_eligible` decimal(21,9) not null default 0, `pay_against_benefit_claim` int(1) not null default 0, `claimed_amount` decimal(21,9) not null default 0, `salary_slip` varchar(140), `attachments` text, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:52,114 WARNING database DDL Query made to DB: create table `tabSalary Slip` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `company` varchar(140), `department` varchar(140), `designation` varchar(140), `branch` varchar(140), `posting_date` date, `letter_head` varchar(140), `status` varchar(140), `salary_withholding` varchar(140), `salary_withholding_cycle` varchar(140), `currency` varchar(140), `exchange_rate` decimal(21,9) not null default 1.0, `payroll_frequency` varchar(140), `start_date` date, `end_date` date, `salary_structure` varchar(140), `payroll_entry` varchar(140), `mode_of_payment` varchar(140), `salary_slip_based_on_timesheet` int(1) not null default 0, `deduct_tax_for_unclaimed_employee_benefits` int(1) not null default 0, `deduct_tax_for_unsubmitted_tax_exemption_proof` int(1) not null default 0, `total_working_days` decimal(21,9) not null default 0, `unmarked_days` decimal(21,9) not null default 0, `leave_without_pay` decimal(21,9) not null default 0, `absent_days` decimal(21,9) not null default 0, `payment_days` decimal(21,9) not null default 0, `total_working_hours` decimal(21,9) not null default 0, `hour_rate` decimal(21,9) not null default 0, `base_hour_rate` decimal(21,9) not null default 0, `gross_pay` decimal(21,9) not null default 0, `base_gross_pay` decimal(21,9) not null default 0, `gross_year_to_date` decimal(21,9) not null default 0, `base_gross_year_to_date` decimal(21,9) not null default 0, `total_deduction` decimal(21,9) not null default 0, `base_total_deduction` decimal(21,9) not null default 0, `net_pay` decimal(21,9) not null default 0, `base_net_pay` decimal(21,9) not null default 0, `rounded_total` decimal(21,9) not null default 0, `base_rounded_total` decimal(21,9) not null default 0, `year_to_date` decimal(21,9) not null default 0, `base_year_to_date` decimal(21,9) not null default 0, `month_to_date` decimal(21,9) not null default 0, `base_month_to_date` decimal(21,9) not null default 0, `total_in_words` varchar(240), `base_total_in_words` varchar(240), `ctc` decimal(21,9) not null default 0, `income_from_other_sources` decimal(21,9) not null default 0, `total_earnings` decimal(21,9) not null default 0, `non_taxable_earnings` decimal(21,9) not null default 0, `standard_tax_exemption_amount` decimal(21,9) not null default 0, `tax_exemption_declaration` decimal(21,9) not null default 0, `deductions_before_tax_calculation` decimal(21,9) not null default 0, `annual_taxable_amount` decimal(21,9) not null default 0, `income_tax_deducted_till_date` decimal(21,9) not null default 0, `current_month_income_tax` decimal(21,9) not null default 0, `future_income_tax_deductions` decimal(21,9) not null default 0, `total_income_tax` decimal(21,9) not null default 0, `journal_entry` varchar(140), `amended_from` varchar(140), `bank_name` varchar(140), `bank_account_no` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `employee`(`employee`), index `start_date`(`start_date`), index `end_date`(`end_date`), index `salary_structure`(`salary_structure`), index `payroll_entry`(`payroll_entry`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:52,197 WARNING database DDL Query made to DB: ALTER TABLE `tabSalary Slip` ADD INDEX IF NOT EXISTS `employee_start_date_end_date_index`(employee, start_date, end_date) 2025-06-23 23:36:52,253 WARNING database DDL Query made to DB: create table `tabGratuity Rule` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `disable` int(1) not null default 0, `calculate_gratuity_amount_based_on` varchar(140), `total_working_days_per_year` int(11) not null default 365, `work_experience_calculation_function` varchar(140) default 'Round off Work Experience', `minimum_year_for_gratuity` int(11) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:52,358 WARNING database DDL Query made to DB: create table `tabRetention Bonus` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `company` varchar(140), `date_of_joining` varchar(140), `salary_component` varchar(140), `bonus_amount` decimal(21,9) not null default 0, `bonus_payment_date` date, `currency` varchar(140), `amended_from` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:52,460 WARNING database DDL Query made to DB: create table `tabPayroll Employee Detail` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `designation` varchar(140), `is_salary_withheld` int(1) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:52,556 WARNING database DDL Query made to DB: create table `tabEmployee Benefit Application` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `employee` varchar(140), `employee_name` varchar(140), `department` varchar(140), `date` date, `payroll_period` varchar(140), `company` varchar(140), `amended_from` varchar(140), `currency` varchar(140), `max_benefits` decimal(21,9) not null default 0, `remaining_benefit` decimal(21,9) not null default 0, `total_amount` decimal(21,9) not null default 0, `pro_rata_dispensed_amount` decimal(21,9) not null default 0, `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:52,654 WARNING database DDL Query made to DB: create table `tabGratuity Applicable Component` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `salary_component` varchar(140), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:52,769 WARNING database DDL Query made to DB: create table `tabSalary Detail` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `salary_component` varchar(140), `abbr` varchar(140), `amount` decimal(21,9) not null default 0, `year_to_date` decimal(21,9) not null default 0, `additional_salary` varchar(140), `is_recurring_additional_salary` int(1) not null default 0, `statistical_component` int(1) not null default 0, `depends_on_payment_days` int(1) not null default 0, `exempted_from_income_tax` int(1) not null default 0, `is_tax_applicable` int(1) not null default 0, `is_flexible_benefit` int(1) not null default 0, `variable_based_on_taxable_salary` int(1) not null default 0, `do_not_include_in_total` int(1) not null default 0, `deduct_full_tax_on_selected_payroll_date` int(1) not null default 0, `condition` longtext, `amount_based_on_formula` int(1) not null default 0, `formula` longtext, `default_amount` decimal(21,9) not null default 0, `additional_amount` decimal(21,9) not null default 0, `tax_on_flexible_benefit` decimal(21,9) not null default 0, `tax_on_additional_salary` decimal(21,9) not null default 0, index `salary_component`(`salary_component`), index `exempted_from_income_tax`(`exempted_from_income_tax`), index `is_tax_applicable`(`is_tax_applicable`), index `variable_based_on_taxable_salary`(`variable_based_on_taxable_salary`), parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:52,890 WARNING database DDL Query made to DB: create table `tabSalary Structure` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `company` varchar(140), `letter_head` varchar(140), `is_active` varchar(140) default 'Yes', `is_default` varchar(140) default 'No', `currency` varchar(140), `amended_from` varchar(140), `leave_encashment_amount_per_day` decimal(21,9) not null default 0, `max_benefits` decimal(21,9) not null default 0, `salary_slip_based_on_timesheet` int(1) not null default 0, `payroll_frequency` varchar(140) default 'Monthly', `salary_component` varchar(140), `hour_rate` decimal(21,9) not null default 0, `total_earning` decimal(21,9) not null default 0, `total_deduction` decimal(21,9) not null default 0, `net_pay` decimal(21,9) not null default 0, `mode_of_payment` varchar(140), `payment_account` varchar(140), `_user_tags` text, `_comments` text, `_assign` text, `_liked_by` text, index `company`(`company`), index `currency`(`currency`), index `salary_slip_based_on_timesheet`(`salary_slip_based_on_timesheet`), index `payroll_frequency`(`payroll_frequency`), index modified(modified)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci 2025-06-23 23:36:52,989 WARNING database DDL Query made to DB: create table `tabIncome Tax Slab Other Charges` ( name varchar(140) primary key, creation datetime(6), modified datetime(6), modified_by varchar(140), owner varchar(140), docstatus int(1) not null default '0', idx int(8) not null default '0', `description` varchar(140), `percent` decimal(21,9) not null default 0, `min_taxable_income` decimal(21,9) not null default 0, `max_taxable_income` decimal(21,9) not null default 0, parent varchar(140), parentfield varchar(140), parenttype varchar(140), index parent(parent)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci