3293 lines
97 KiB
Groff
3293 lines
97 KiB
Groff
2025-05-20 13:10:36,389 WARNING database DDL Query made to DB:
|
|
create table `tabAsset Shift 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',
|
|
`asset` varchar(140),
|
|
`naming_series` varchar(140),
|
|
`finance_book` 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-05-20 13:10:36,499 WARNING database DDL Query made to DB:
|
|
create table `tabAsset Maintenance 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',
|
|
`asset_maintenance` varchar(140),
|
|
`naming_series` varchar(140),
|
|
`asset_name` varchar(140),
|
|
`item_code` varchar(140),
|
|
`item_name` varchar(140),
|
|
`task` varchar(140),
|
|
`task_name` varchar(140),
|
|
`maintenance_type` varchar(140),
|
|
`periodicity` varchar(140),
|
|
`has_certificate` int(1) not null default 0,
|
|
`certificate_attachement` text,
|
|
`maintenance_status` varchar(140),
|
|
`assign_to_name` varchar(140),
|
|
`task_assignee_email` varchar(140),
|
|
`due_date` date,
|
|
`completion_date` date,
|
|
`description` varchar(140),
|
|
`actions_performed` longtext,
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
`_seen` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:36,614 WARNING database DDL Query made to DB:
|
|
create table `tabAsset Repair` (
|
|
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',
|
|
`asset` varchar(140),
|
|
`company` varchar(140),
|
|
`asset_name` varchar(140),
|
|
`naming_series` varchar(140),
|
|
`failure_date` datetime(6),
|
|
`repair_status` varchar(140) default 'Pending',
|
|
`completion_date` datetime(6),
|
|
`cost_center` varchar(140),
|
|
`project` varchar(140),
|
|
`purchase_invoice` varchar(140),
|
|
`capitalize_repair_cost` int(1) not null default 0,
|
|
`stock_consumption` int(1) not null default 0,
|
|
`repair_cost` decimal(21,9) not null default 0,
|
|
`total_repair_cost` decimal(21,9) not null default 0,
|
|
`increase_in_asset_life` int(11) not null default 0,
|
|
`description` longtext,
|
|
`actions_performed` longtext,
|
|
`downtime` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
`_seen` text,
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:36,708 WARNING database DDL Query made to DB:
|
|
create table `tabAsset Repair Consumed 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),
|
|
`warehouse` varchar(140),
|
|
`valuation_rate` decimal(21,9) not null default 0,
|
|
`consumed_quantity` varchar(140),
|
|
`total_value` decimal(21,9) not null default 0,
|
|
`serial_no` text,
|
|
`serial_and_batch_bundle` 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-05-20 13:10:36,802 WARNING database DDL Query made to DB:
|
|
create table `tabAsset Maintenance` (
|
|
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',
|
|
`asset_name` varchar(140) unique,
|
|
`asset_category` varchar(140),
|
|
`company` varchar(140),
|
|
`item_code` varchar(140),
|
|
`item_name` varchar(140),
|
|
`maintenance_team` varchar(140),
|
|
`maintenance_manager` varchar(140),
|
|
`maintenance_manager_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-05-20 13:10:36,911 WARNING database DDL Query made to DB:
|
|
create table `tabLocation` (
|
|
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,
|
|
`parent_location` varchar(140),
|
|
`is_container` int(1) not null default 0,
|
|
`is_group` int(1) not null default 0,
|
|
`latitude` decimal(21,9) not null default 0,
|
|
`longitude` decimal(21,9) not null default 0,
|
|
`area` decimal(21,9) not null default 0,
|
|
`area_uom` varchar(140),
|
|
`location` 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 `parent_location`(`parent_location`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:36,998 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabLocation`
|
|
ADD INDEX IF NOT EXISTS `lft_rgt_index`(lft, rgt)
|
|
2025-05-20 13:10:37,197 WARNING database DDL Query made to DB:
|
|
create table `tabHomepage Section` (
|
|
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',
|
|
`section_based_on` varchar(140),
|
|
`no_of_columns` varchar(140) default '3',
|
|
`section_html` longtext,
|
|
`section_order` 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-05-20 13:10:37,270 WARNING database DDL Query made to DB:
|
|
create table `tabWebsite Filter Field` (
|
|
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',
|
|
`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-05-20 13:10:37,405 WARNING database DDL Query made to DB:
|
|
create table `tabWebsite Attribute` (
|
|
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',
|
|
`attribute` 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-05-20 13:10:37,478 WARNING database DDL Query made to DB:
|
|
create table `tabHomepage Section Card` (
|
|
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),
|
|
`subtitle` varchar(140),
|
|
`image` text,
|
|
`content` text,
|
|
`route` 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-05-20 13:10:37,582 WARNING database DDL Query made to DB:
|
|
create table `tabMaintenance 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',
|
|
`naming_series` varchar(140),
|
|
`customer` varchar(140),
|
|
`status` varchar(140) default 'Draft',
|
|
`transaction_date` date,
|
|
`customer_name` varchar(140),
|
|
`contact_person` varchar(140),
|
|
`contact_mobile` varchar(140),
|
|
`contact_email` varchar(140),
|
|
`contact_display` text,
|
|
`customer_address` varchar(140),
|
|
`address_display` text,
|
|
`territory` varchar(140),
|
|
`customer_group` varchar(140),
|
|
`company` varchar(140),
|
|
`amended_from` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `customer`(`customer`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:37,691 WARNING database DDL Query made to DB:
|
|
create table `tabMaintenance Schedule 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),
|
|
`description` longtext,
|
|
`start_date` date,
|
|
`end_date` date,
|
|
`periodicity` varchar(140),
|
|
`no_of_visits` int(11) not null default 0,
|
|
`sales_person` varchar(140),
|
|
`serial_no` text,
|
|
`sales_order` varchar(140),
|
|
`serial_and_batch_bundle` varchar(140),
|
|
index `item_code`(`item_code`),
|
|
index `start_date`(`start_date`),
|
|
index `end_date`(`end_date`),
|
|
index `sales_order`(`sales_order`),
|
|
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-05-20 13:10:37,778 WARNING database DDL Query made to DB:
|
|
create table `tabMaintenance Visit Purpose` (
|
|
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),
|
|
`service_person` varchar(140),
|
|
`serial_no` varchar(140),
|
|
`description` longtext,
|
|
`work_done` text,
|
|
`prevdoc_doctype` varchar(140),
|
|
`prevdoc_docname` varchar(140),
|
|
`maintenance_schedule_detail` 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-05-20 13:10:37,870 WARNING database DDL Query made to DB:
|
|
create table `tabMaintenance Schedule 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',
|
|
`item_code` varchar(140),
|
|
`item_name` varchar(140),
|
|
`scheduled_date` date,
|
|
`actual_date` date,
|
|
`sales_person` varchar(140),
|
|
`completion_status` varchar(140) default 'Pending',
|
|
`serial_no` text,
|
|
`item_reference` varchar(140),
|
|
index `item_code`(`item_code`),
|
|
index `scheduled_date`(`scheduled_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-05-20 13:10:37,977 WARNING database DDL Query made to DB:
|
|
create table `tabMaintenance Visit` (
|
|
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),
|
|
`customer` varchar(140),
|
|
`customer_name` varchar(140),
|
|
`address_display` text,
|
|
`contact_display` text,
|
|
`contact_mobile` varchar(140),
|
|
`contact_email` varchar(140),
|
|
`maintenance_schedule` varchar(140),
|
|
`maintenance_schedule_detail` varchar(140),
|
|
`mntc_date` date,
|
|
`mntc_time` time(6),
|
|
`completion_status` varchar(140),
|
|
`maintenance_type` varchar(140) default 'Unscheduled',
|
|
`customer_feedback` text,
|
|
`status` varchar(140) default 'Draft',
|
|
`amended_from` varchar(140),
|
|
`company` varchar(140),
|
|
`customer_address` varchar(140),
|
|
`contact_person` varchar(140),
|
|
`territory` varchar(140),
|
|
`customer_group` 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-05-20 13:10:38,070 WARNING database DDL Query made to DB:
|
|
create table `tabImport Supplier Invoice` (
|
|
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',
|
|
`invoice_series` varchar(140),
|
|
`company` varchar(140),
|
|
`item_code` varchar(140),
|
|
`supplier_group` varchar(140),
|
|
`tax_account` varchar(140),
|
|
`default_buying_price_list` varchar(140),
|
|
`zip_file` text,
|
|
`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-05-20 13:10:38,152 WARNING database DDL Query made to DB:
|
|
create table `tabUAE VAT Settings` (
|
|
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) 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-05-20 13:10:38,221 WARNING database DDL Query made to DB:
|
|
create table `tabUAE VAT 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',
|
|
`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-05-20 13:10:38,302 WARNING database DDL Query made to DB:
|
|
create table `tabSouth Africa VAT Settings` (
|
|
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) 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-05-20 13:10:38,410 WARNING database DDL Query made to DB:
|
|
create table `tabLower Deduction Certificate` (
|
|
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',
|
|
`tax_withholding_category` varchar(140),
|
|
`fiscal_year` varchar(140),
|
|
`company` varchar(140),
|
|
`certificate_no` varchar(140) unique,
|
|
`supplier` varchar(140),
|
|
`pan_no` varchar(140),
|
|
`valid_from` date,
|
|
`valid_upto` date,
|
|
`rate` decimal(21,9) not null default 0,
|
|
`certificate_limit` 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-05-20 13:10:38,715 WARNING database DDL Query made to DB:
|
|
create table `tabQuality Action Resolution` (
|
|
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',
|
|
`problem` longtext,
|
|
`resolution` longtext,
|
|
`status` varchar(140),
|
|
`responsible` varchar(140),
|
|
`completion_by` 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-05-20 13:10:38,792 WARNING database DDL Query made to DB:
|
|
create table `tabQuality Meeting` (
|
|
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',
|
|
`status` varchar(140) default 'Open',
|
|
`_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-05-20 13:10:38,881 WARNING database DDL Query made to DB:
|
|
create table `tabNon Conformance` (
|
|
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),
|
|
`procedure` varchar(140),
|
|
`process_owner` varchar(140),
|
|
`full_name` varchar(140),
|
|
`status` varchar(140),
|
|
`details` longtext,
|
|
`corrective_action` longtext,
|
|
`preventive_action` 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-05-20 13:10:38,976 WARNING database DDL Query made to DB:
|
|
create table `tabQuality Review` (
|
|
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` varchar(140),
|
|
`date` date,
|
|
`procedure` varchar(140),
|
|
`status` varchar(140) default 'Open',
|
|
`additional_information` 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-05-20 13:10:39,061 WARNING database DDL Query made to DB:
|
|
create table `tabQuality Feedback Template Parameter` (
|
|
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',
|
|
`parameter` 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-05-20 13:10:39,155 WARNING database DDL Query made to DB:
|
|
create table `tabQuality Procedure` (
|
|
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',
|
|
`quality_procedure_name` varchar(140) unique,
|
|
`process_owner` varchar(140),
|
|
`process_owner_full_name` varchar(140),
|
|
`parent_quality_procedure` varchar(140),
|
|
`is_group` int(1) not null default 0,
|
|
`rgt` int(11) not null default 0,
|
|
`lft` 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-05-20 13:10:39,238 WARNING database DDL Query made to DB:
|
|
create table `tabQuality Review Objective` (
|
|
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',
|
|
`objective` text,
|
|
`target` varchar(140),
|
|
`uom` varchar(140),
|
|
`status` varchar(140) default 'Open',
|
|
`review` 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-05-20 13:10:39,325 WARNING database DDL Query made to DB:
|
|
create table `tabQuality 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',
|
|
`goal` varchar(140) unique,
|
|
`frequency` varchar(140) default 'None',
|
|
`procedure` varchar(140),
|
|
`weekday` varchar(140),
|
|
`date` 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-05-20 13:10:39,398 WARNING database DDL Query made to DB:
|
|
create table `tabQuality Meeting Agenda` (
|
|
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',
|
|
`agenda` 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-05-20 13:10:39,471 WARNING database DDL Query made to DB:
|
|
create table `tabQuality Feedback Parameter` (
|
|
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',
|
|
`parameter` varchar(140),
|
|
`rating` varchar(140) default '1',
|
|
`feedback` 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-05-20 13:10:39,549 WARNING database DDL Query made to DB:
|
|
create table `tabQuality Procedure Process` (
|
|
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',
|
|
`process_description` longtext,
|
|
`procedure` 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-05-20 13:10:39,623 WARNING database DDL Query made to DB:
|
|
create table `tabQuality Goal Objective` (
|
|
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',
|
|
`objective` text,
|
|
`target` varchar(140),
|
|
`uom` 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-05-20 13:10:39,707 WARNING database DDL Query made to DB:
|
|
create table `tabQuality Feedback 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` 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-05-20 13:10:39,796 WARNING database DDL Query made to DB:
|
|
create table `tabQuality Action` (
|
|
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',
|
|
`corrective_preventive` varchar(140) default 'Corrective',
|
|
`review` varchar(140),
|
|
`feedback` varchar(140),
|
|
`status` varchar(140) default 'Open',
|
|
`date` date,
|
|
`goal` varchar(140),
|
|
`procedure` 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-05-20 13:10:39,879 WARNING database DDL Query made to DB:
|
|
create table `tabQuality 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',
|
|
`template` varchar(140),
|
|
`document_type` varchar(140),
|
|
`document_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-05-20 13:10:39,964 WARNING database DDL Query made to DB:
|
|
create table `tabQuality Meeting Minutes` (
|
|
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',
|
|
`document_type` varchar(140),
|
|
`document_name` varchar(140),
|
|
`minute` 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-05-20 13:10:40,079 WARNING database DDL Query made to DB:
|
|
create table `tabCommunication Medium` (
|
|
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',
|
|
`communication_channel` varchar(140),
|
|
`communication_medium_type` varchar(140),
|
|
`catch_all` varchar(140),
|
|
`provider` varchar(140),
|
|
`disabled` 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-05-20 13:10:40,160 WARNING database DDL Query made to DB:
|
|
create table `tabCommunication Medium Timeslot` (
|
|
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',
|
|
`day_of_week` varchar(140),
|
|
`from_time` time(6),
|
|
`to_time` time(6),
|
|
`employee_group` 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-05-20 13:10:40,257 WARNING database DDL Query made to DB:
|
|
create table `tabCall 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',
|
|
`id` varchar(140) unique,
|
|
`from` varchar(140),
|
|
`to` varchar(140),
|
|
`call_received_by` varchar(140),
|
|
`employee_user_id` varchar(140),
|
|
`medium` varchar(140),
|
|
`start_time` datetime(6),
|
|
`end_time` datetime(6),
|
|
`type` varchar(140),
|
|
`customer` varchar(140),
|
|
`status` varchar(140),
|
|
`duration` decimal(21,9),
|
|
`recording_url` varchar(140),
|
|
`type_of_call` varchar(140),
|
|
`summary` 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-05-20 13:10:40,355 WARNING database DDL Query made to DB:
|
|
create table `tabTelephony Call 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',
|
|
`call_type` varchar(140) unique,
|
|
`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-05-20 13:10:40,435 WARNING database DDL Query made to DB:
|
|
create table `tabIncoming Call Handling 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',
|
|
`day_of_week` varchar(140),
|
|
`from_time` time(6) default '9:00:00',
|
|
`to_time` time(6) default '17:00:00',
|
|
`agent_group` 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-05-20 13:10:40,517 WARNING database DDL Query made to DB:
|
|
create table `tabIncoming Call Settings` (
|
|
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',
|
|
`call_routing` varchar(140) default 'Sequential',
|
|
`greeting_message` varchar(140),
|
|
`agent_busy_message` varchar(140),
|
|
`agent_unavailable_message` 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-05-20 13:10:40,606 WARNING database DDL Query made to DB:
|
|
create table `tabVoice Call Settings` (
|
|
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) unique,
|
|
`call_receiving_device` varchar(140) default 'Computer',
|
|
`greeting_message` varchar(140),
|
|
`agent_busy_message` varchar(140),
|
|
`agent_unavailable_message` 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-05-20 13:10:40,702 WARNING database DDL Query made to DB:
|
|
create table `tabBulk Transaction Log 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',
|
|
`from_doctype` varchar(140),
|
|
`transaction_name` varchar(140),
|
|
`date` date,
|
|
`time` time(6),
|
|
`transaction_status` varchar(140),
|
|
`error_description` longtext,
|
|
`to_doctype` varchar(140),
|
|
`retried` int(11) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `from_doctype`(`from_doctype`),
|
|
index `transaction_name`(`transaction_name`),
|
|
index `date`(`date`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:40,914 WARNING database DDL Query made to DB:
|
|
create table `tabSubcontracting Order 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),
|
|
`bom` varchar(140),
|
|
`include_exploded_items` int(1) not null default 0,
|
|
`schedule_date` date,
|
|
`expected_delivery_date` date,
|
|
`description` longtext,
|
|
`image` text,
|
|
`qty` decimal(21,9) not null default 1.0,
|
|
`received_qty` decimal(21,9) not null default 0,
|
|
`returned_qty` decimal(21,9) not null default 0,
|
|
`stock_uom` varchar(140),
|
|
`conversion_factor` decimal(21,9) not null default 1.0,
|
|
`rate` decimal(21,9) not null default 0,
|
|
`amount` decimal(21,9) not null default 0,
|
|
`rm_cost_per_qty` decimal(21,9) not null default 0,
|
|
`service_cost_per_qty` decimal(21,9) not null default 0,
|
|
`additional_cost_per_qty` decimal(21,9) not null default 0,
|
|
`warehouse` varchar(140),
|
|
`expense_account` varchar(140),
|
|
`manufacturer` varchar(140),
|
|
`manufacturer_part_no` varchar(140),
|
|
`material_request` varchar(140),
|
|
`material_request_item` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`project` varchar(140),
|
|
`purchase_order_item` varchar(140),
|
|
`page_break` int(1) not null default 0,
|
|
`subcontracting_conversion_factor` decimal(21,9) not null default 0,
|
|
`job_card` varchar(140),
|
|
index `item_code`(`item_code`),
|
|
index `expected_delivery_date`(`expected_delivery_date`),
|
|
index `material_request`(`material_request`),
|
|
index `material_request_item`(`material_request_item`),
|
|
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-05-20 13:10:41,012 WARNING database DDL Query made to DB:
|
|
create table `tabSubcontracting Order Supplied 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',
|
|
`main_item_code` varchar(140),
|
|
`rm_item_code` varchar(140),
|
|
`stock_uom` varchar(140),
|
|
`conversion_factor` decimal(21,9) not null default 1.0,
|
|
`reserve_warehouse` varchar(140),
|
|
`bom_detail_no` varchar(140),
|
|
`reference_name` varchar(140),
|
|
`rate` decimal(21,9) not null default 0,
|
|
`amount` decimal(21,9) not null default 0,
|
|
`required_qty` decimal(21,9) not null default 0,
|
|
`supplied_qty` decimal(21,9) not null default 0,
|
|
`consumed_qty` decimal(21,9) not null default 0,
|
|
`returned_qty` decimal(21,9) not null default 0,
|
|
`total_supplied_qty` 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-05-20 13:10:41,114 WARNING database DDL Query made to DB:
|
|
create table `tabSubcontracting Receipt Supplied 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',
|
|
`main_item_code` varchar(140),
|
|
`rm_item_code` varchar(140),
|
|
`item_name` varchar(140),
|
|
`bom_detail_no` varchar(140),
|
|
`description` longtext,
|
|
`stock_uom` varchar(140),
|
|
`conversion_factor` decimal(21,9) not null default 1.0,
|
|
`reference_name` varchar(140),
|
|
`rate` decimal(21,9) not null default 0,
|
|
`amount` decimal(21,9) not null default 0,
|
|
`available_qty_for_consumption` decimal(21,9) not null default 0,
|
|
`required_qty` decimal(21,9) not null default 0,
|
|
`consumed_qty` decimal(21,9) not null default 0,
|
|
`current_stock` decimal(21,9) not null default 0,
|
|
`serial_and_batch_bundle` varchar(140),
|
|
`use_serial_batch_fields` int(1) not null default 0,
|
|
`subcontracting_order` varchar(140),
|
|
`serial_no` text,
|
|
`batch_no` 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-05-20 13:10:41,251 WARNING database DDL Query made to DB:
|
|
create table `tabSubcontracting Order` (
|
|
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),
|
|
`purchase_order` varchar(140),
|
|
`supplier` varchar(140),
|
|
`supplier_name` varchar(140),
|
|
`supplier_warehouse` varchar(140),
|
|
`company` varchar(140),
|
|
`transaction_date` date,
|
|
`schedule_date` date,
|
|
`amended_from` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`project` varchar(140),
|
|
`set_warehouse` varchar(140),
|
|
`total_qty` decimal(21,9) not null default 0,
|
|
`total` decimal(21,9) not null default 0,
|
|
`set_reserve_warehouse` varchar(140),
|
|
`supplier_address` varchar(140),
|
|
`address_display` text,
|
|
`contact_person` varchar(140),
|
|
`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,
|
|
`status` varchar(140) default 'Draft',
|
|
`per_received` decimal(21,9) not null default 0,
|
|
`select_print_heading` varchar(140),
|
|
`letter_head` varchar(140),
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `supplier`(`supplier`),
|
|
index `transaction_date`(`transaction_date`),
|
|
index `status`(`status`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:41,369 WARNING database DDL Query made to DB:
|
|
create table `tabSubcontracting BOM` (
|
|
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',
|
|
`is_active` int(1) not null default 1,
|
|
`finished_good` varchar(140),
|
|
`finished_good_qty` decimal(21,9) not null default 1.0,
|
|
`finished_good_uom` varchar(140),
|
|
`finished_good_bom` varchar(140),
|
|
`service_item` varchar(140),
|
|
`service_item_qty` decimal(21,9) not null default 1.0,
|
|
`service_item_uom` varchar(140),
|
|
`conversion_factor` decimal(21,9) not null default 0,
|
|
`_user_tags` text,
|
|
`_comments` text,
|
|
`_assign` text,
|
|
`_liked_by` text,
|
|
index `finished_good`(`finished_good`),
|
|
index `finished_good_bom`(`finished_good_bom`),
|
|
index `service_item`(`service_item`),
|
|
index modified(modified))
|
|
ENGINE=InnoDB
|
|
ROW_FORMAT=DYNAMIC
|
|
CHARACTER SET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci
|
|
2025-05-20 13:10:41,520 WARNING database DDL Query made to DB:
|
|
create table `tabSubcontracting Receipt 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),
|
|
`is_scrap_item` int(1) not null default 0,
|
|
`description` longtext,
|
|
`brand` varchar(140),
|
|
`image` text,
|
|
`received_qty` decimal(21,9) not null default 0,
|
|
`qty` decimal(21,9) not null default 0,
|
|
`rejected_qty` decimal(21,9) not null default 0,
|
|
`returned_qty` decimal(21,9) not null default 0,
|
|
`stock_uom` varchar(140),
|
|
`conversion_factor` decimal(21,9) not null default 1.0,
|
|
`rate` decimal(21,9) not null default 0,
|
|
`amount` decimal(21,9) not null default 0,
|
|
`rm_cost_per_qty` decimal(21,9) not null default 0,
|
|
`service_cost_per_qty` decimal(21,9) not null default 0,
|
|
`additional_cost_per_qty` decimal(21,9) not null default 0,
|
|
`scrap_cost_per_qty` decimal(21,9) not null default 0,
|
|
`rm_supp_cost` decimal(21,9) not null default 0,
|
|
`warehouse` varchar(140),
|
|
`subcontracting_order` varchar(140),
|
|
`subcontracting_order_item` varchar(140),
|
|
`subcontracting_receipt_item` varchar(140),
|
|
`rejected_warehouse` varchar(140),
|
|
`bom` varchar(140),
|
|
`include_exploded_items` int(1) not null default 0,
|
|
`quality_inspection` varchar(140),
|
|
`schedule_date` date,
|
|
`reference_name` varchar(140),
|
|
`serial_and_batch_bundle` varchar(140),
|
|
`use_serial_batch_fields` int(1) not null default 0,
|
|
`rejected_serial_and_batch_bundle` varchar(140),
|
|
`serial_no` text,
|
|
`rejected_serial_no` text,
|
|
`batch_no` varchar(140),
|
|
`manufacturer` varchar(140),
|
|
`manufacturer_part_no` varchar(140),
|
|
`expense_account` varchar(140),
|
|
`cost_center` varchar(140),
|
|
`project` varchar(140),
|
|
`page_break` int(1) not null default 0,
|
|
`purchase_order` varchar(140),
|
|
`purchase_order_item` varchar(140),
|
|
index `item_code`(`item_code`),
|
|
index `subcontracting_order`(`subcontracting_order`),
|
|
index `subcontracting_order_item`(`subcontracting_order_item`),
|
|
index `purchase_order`(`purchase_order`),
|
|
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-05-20 13:10:41,704 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-05-20 13:10:41,828 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-05-20 13:10:41,911 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-05-20 13:10:42,008 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-05-20 13:10:42,068 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-05-20 13:10:47,200 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-05-20 13:10:47,281 WARNING database DDL Query made to DB:
|
|
ALTER TABLE `tabContact` ADD COLUMN `is_billing_contact` int(1) not null default 0
|
|
2025-05-20 13:16:16,816 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-05-20 13:16:16,924 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-05-20 13:16:17,005 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-05-20 13:16:17,136 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-05-20 13:16:17,211 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-05-20 13:16:17,321 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-05-20 13:16:17,672 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-05-20 13:16:17,761 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-05-20 13:16:17,844 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-05-20 13:16:17,949 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-05-20 13:16:18,032 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-05-20 13:16:18,149 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-05-20 13:16:18,246 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-05-20 13:16:18,371 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-05-20 13:16:18,474 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-05-20 13:16:18,584 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-05-20 13:16:18,684 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-05-20 13:16:18,761 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-05-20 13:16:18,860 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-05-20 13:16:18,986 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-05-20 13:16:19,090 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-05-20 13:16:19,214 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-05-20 13:16:19,333 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-05-20 13:16:19,436 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-05-20 13:16:19,642 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-05-20 13:16:19,760 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-05-20 13:16:19,847 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-05-20 13:16:19,969 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-05-20 13:16:20,082 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-05-20 13:16:20,143 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-05-20 13:16:20,241 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-05-20 13:16:20,345 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-05-20 13:16:20,429 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-05-20 13:16:20,518 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-05-20 13:16:20,629 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-05-20 13:16:20,770 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-05-20 13:16:20,884 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-05-20 13:16:20,980 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-05-20 13:16:21,067 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-05-20 13:16:21,163 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-05-20 13:16:21,279 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-05-20 13:16:21,391 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-05-20 13:16:21,506 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-05-20 13:16:21,617 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-05-20 13:16:21,721 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-05-20 13:16:21,856 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-05-20 13:16:21,970 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-05-20 13:16:22,062 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-05-20 13:16:22,152 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-05-20 13:16:22,234 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-05-20 13:16:22,342 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-05-20 13:16:22,451 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-05-20 13:16:22,564 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-05-20 13:16:22,650 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-05-20 13:16:22,740 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-05-20 13:16:22,854 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-05-20 13:16:23,041 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-05-20 13:16:23,139 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-05-20 13:16:23,224 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-05-20 13:16:23,355 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-05-20 13:16:23,452 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-05-20 13:16:23,546 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-05-20 13:16:23,667 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-05-20 13:16:23,776 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-05-20 13:16:23,859 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-05-20 13:16:23,949 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-05-20 13:16:24,185 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-05-20 13:16:24,279 WARNING database DDL Query made to DB:
|
|
create sequence if not exists pwa_notification_id_seq nocache nocycle
|
|
2025-05-20 13:16:24,298 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-05-20 13:16:24,391 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-05-20 13:16:24,513 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-05-20 13:16:24,583 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)
|