Change Log
- Merge Inventory Source Code 3.54.12.16
Checking structure phase 2
ALTER TABLE surveil_member_507 ADD `e1_507` int NULL
ALTER TABLE surveil_member_507 ADD `e0_507` int NULL
ALTER TABLE surveil_member_507 MODIFY COLUMN `epi_group_code` varchar(2)
ALTER TABLE surveil_member ADD `provis_nation_code` varchar(3) NULL
ALTER TABLE surveil_member MODIFY COLUMN `epi_group_code` char(2)
ALTER TABLE stock_warehouse ADD `warehouse_write_po_position` varchar(250) NULL
ALTER TABLE stock_warehouse ADD `warehouse_write_po_name` varchar(250) NULL
ALTER TABLE stock_transfer_draw_list ADD `transaction_datetime` datetime NULL
ALTER TABLE stock_trancation_itemdata ADD `total_qty` int NULL
ALTER TABLE stock_trancation_itemdata ADD `stock_trancation_date` datetime NULL
ALTER TABLE stock_trancation_itemdata ADD `adj_qty` int NULL
ALTER TABLE stock_trancation_itemdata ADD `issue_qty` int NULL
ALTER TABLE stock_trancation_itemdata ADD `receive_qty` int NULL
ALTER TABLE stock_trancation_itemdata ADD `remain_qty` int NULL
ALTER TABLE stock_trancation_itemdata ADD `stock_item_unit_id` int NULL
ALTER TABLE stock_trancation_itemdata ADD `item_id` int NULL
ALTER TABLE stock_trancation_itemdata ADD `warehouse_id` int NULL
ALTER TABLE stock_test ADD `stock_committee_group_name` varchar(100) NULL
ALTER TABLE stock_subdraw ADD `project_plan_id` int NULL
ALTER TABLE stock_subdraw ADD `project_id` varchar(30) NULL
ALTER TABLE stock_subcard ADD `transaction_datetime` datetime NULL
ALTER TABLE stock_subcard ADD `out_unit_id` int NULL
ALTER TABLE stock_subcard ADD `in_unit_id` int NULL
ALTER TABLE stock_subcard ADD `stock_item_unit_name` varchar(50) NULL
ALTER TABLE stock_subcard ADD `out_unit_name` varchar(50) NULL
ALTER TABLE stock_subcard ADD `in_unit_name` varchar(50) NULL
ALTER TABLE stock_subcard ADD `stock_substockcard_name` varchar(100) NULL
ALTER TABLE stock_subcard ADD `out_qty` int NULL
ALTER TABLE stock_subcard ADD `in_qty` int NULL
ALTER TABLE stock_subcard ADD `left_qty` int NULL
ALTER TABLE stock_subcard ADD `expire_date` date NULL
ALTER TABLE stock_subcard ADD `lot_no` varchar(30) NULL
ALTER TABLE stock_subcard ADD `stock_draw_list_id` int NULL
ALTER TABLE stock_subcard ADD `stock_substockcard_group` varchar(10) NULL
ALTER TABLE stock_subcard ADD `department_id` int NULL
ALTER TABLE stock_subcard ADD `stock_item_unit_id` int NULL
ALTER TABLE stock_subcard ADD `ref_no` varchar(50) NULL
ALTER TABLE stock_subcard ADD `item_id` int NULL
ALTER TABLE stock_subcard ADD `stock_substockcard_type` int NULL
ALTER TABLE stock_subcard ADD `stock_substockcard_date` date NULL
ALTER TABLE stock_return ADD `item_count` int NULL
ALTER TABLE stock_project_plan ADD `project_plan_status` int NULL
ALTER TABLE stock_project_plan ADD `project_plan_name` varchar(200) NULL
ALTER TABLE stock_project ADD `project_status` int NULL
ALTER TABLE stock_project ADD `project_detail` varchar(300) NULL
ALTER TABLE stock_project ADD `project_name` varchar(100) NULL
ALTER TABLE stock_po_detail ADD `stock_co_po_detail_id` int NULL
ALTER TABLE stock_po_detail ADD `request_list_id` int NULL
ALTER TABLE stock_po_committee ADD `stock_co_po_detail_id` int NULL
ALTER TABLE stock_po_committee ADD `stock_doctor_id` varchar(20) NULL
ALTER TABLE stock_plan_list ADD `year_qty` int NULL
ALTER TABLE stock_plan ADD `warehouse_id` int NULL
ALTER TABLE stock_masterunit ADD `stock_masterunit_name` varchar(100) NULL
ALTER TABLE stock_manual_detail ADD `transaction_datetime` datetime NULL
ALTER TABLE stock_item_list ADD `item_barcode` varchar(20) NULL
ALTER TABLE stock_item ADD `item_type_group` varchar(30) NULL
ALTER TABLE stock_draw_list ADD `stock_transfer_draw_list_id` int NULL
ALTER TABLE stock_cutpay_list ADD `stock_package_qty_balance` int NULL
ALTER TABLE stock_cutpay_list ADD `statusAdjust` varchar(10) NULL
ALTER TABLE stock_committee_detail ADD `stock_committee_Position_id` int NULL
ALTER TABLE stock_committee_detail ADD `stock_committee_group_id` int NULL
ALTER TABLE stock_committee_detail ADD `stock_committee_id` varchar(10) NULL
ALTER TABLE stock_co_po_detail ADD `stock_co_po_detail_status` int NULL
ALTER TABLE stock_co_po_detail ADD `stock_co_po_detail_name` varchar(80) NULL
ALTER TABLE stock_check_warehouse_head ADD `warehouse_id` int NULL
ALTER TABLE stock_check_warehouse_head ADD `stock_count` int NULL
ALTER TABLE stock_check_warehouse_head ADD `remark` varchar(200) NULL
ALTER TABLE stock_check_warehouse_head ADD `stock_check_no` varchar(30) NULL
ALTER TABLE stock_check_warehouse_head ADD `staff` varchar(30) NULL
ALTER TABLE stock_check_warehouse_head ADD `stock_user_id` int NULL
ALTER TABLE stock_check_warehouse_head ADD `stock_check_date` date NULL
ALTER TABLE stock_check_warehouse_detail ADD `remain_qty` int NULL
ALTER TABLE stock_check_warehouse_detail ADD `stock_package_qty` int NULL
ALTER TABLE stock_check_warehouse_detail ADD `stock_item_unit` int NULL
ALTER TABLE stock_check_warehouse_detail ADD `item_qty` int NULL
ALTER TABLE stock_check_warehouse_detail ADD `item_list_id` int NULL
ALTER TABLE stock_check_warehouse_detail ADD `item_id` int NULL
ALTER TABLE stock_check_warehouse_detail ADD `stock_check_warehouse_head_id` int NULL
ALTER TABLE stock_budget_list ADD `stock_datetime` datetime NULL
ALTER TABLE stock_budget_list ADD `stock_user_id` int NULL
ALTER TABLE stock_budget_list ADD `stock_budget_year` varchar(20) NULL
ALTER TABLE stock_budget_list ADD `budget_id` int NULL
ALTER TABLE stock_budget_list ADD `stock_budget_detail_id` int NULL
ALTER TABLE stock_budget_detail ADD `stock_budget_inv` double(11,0) NULL
ALTER TABLE stock_budget_detail ADD `stock_budget_use` double(11,0) NULL
ALTER TABLE stock_budget_detail ADD `stock_budget_remain` double(11,0) NULL
ALTER TABLE stock_budget_detail ADD `stock_budget_price` double(11,0) NULL
ALTER TABLE stock_budget_detail ADD `budget_id` int NULL
ALTER TABLE stock_budget_detail ADD `stock_budget_detail_id` int NOT NULL
ALTER TABLE stock_borrow_status_remark ADD `stock_borrow_status_remark_name` varchar(50) NULL
ALTER TABLE stock_borrow_return_list ADD `stock_borrow_return_id` int NULL
ALTER TABLE stock_borrow_return_list ADD `package_qty` int NULL
ALTER TABLE stock_borrow_return_list ADD `item_qty` int NULL
ALTER TABLE stock_borrow_return_list ADD `stock_item_unit_id` int NULL
ALTER TABLE stock_borrow_return_list ADD `item_list_id` int NULL
ALTER TABLE stock_borrow_return_list ADD `stock_borrow_return_list_id` int NULL
ALTER TABLE stock_borrow_return_item ADD `remain_qty` int NULL
ALTER TABLE stock_borrow_return_item ADD `item_qty` int NULL
ALTER TABLE stock_borrow_return_item ADD `return_package_qty` int NULL
ALTER TABLE stock_borrow_return_item ADD `stock_item_unit_id` int NULL
ALTER TABLE stock_borrow_return_item ADD `item_id` int NULL
ALTER TABLE stock_borrow_return_item ADD `stock_borrow_return_item_id` int NULL
ALTER TABLE stock_borrow_return ADD `transaction_datetime` datetime NULL
ALTER TABLE stock_borrow_return ADD `item_count` int NULL
ALTER TABLE stock_borrow_return ADD `stock_borrow_id` int NULL
ALTER TABLE stock_borrow_return ADD `stock_user_id` int NULL
ALTER TABLE stock_borrow_return ADD `stock_borrow_return_date` date NULL
ALTER TABLE stock_borrow_return ADD `supplier_id` int NULL
ALTER TABLE stock_borrow_return ADD `stock_borrow_return_no` varchar(40) NULL
ALTER TABLE stock_borrow_return ADD `warehouse_id` int NULL
ALTER TABLE stock_borrow_item ADD `return_qty` int NULL
ALTER TABLE stock_borrow ADD `stock_borrow_status_remark_id` int NULL
ALTER TABLE stock_borrow ADD `borrow_remark` varchar(255) NULL
ALTER TABLE stock_bestow_return_list ADD `package_qty` int NULL
ALTER TABLE stock_bestow_return_list ADD `item_qty` int NULL
ALTER TABLE stock_bestow_return_list ADD `stock_item_unit_id` int NULL
ALTER TABLE stock_bestow_return_list ADD `item_list_id` int NULL
ALTER TABLE stock_bestow_return_list ADD `stock_bestow_return_id` int NULL
ALTER TABLE stock_bestow_return_list ADD `stock_bestow_return_item_id` int NULL
ALTER TABLE stock_bestow_return_item ADD `stock_bestow_item_id` int NULL
ALTER TABLE stock_bestow_return_item ADD `bestow_item_status` char(1) NULL
ALTER TABLE stock_bestow_return_item ADD `stock_bestow_lotno` varchar(50) NULL
ALTER TABLE stock_bestow_return_item ADD `stock_bestow_expire` date NULL
ALTER TABLE stock_bestow_return_item ADD `remain_qty` int NULL
ALTER TABLE stock_bestow_return_item ADD `item_qty` int NULL
ALTER TABLE stock_bestow_return_item ADD `return_package_qty` int NULL
ALTER TABLE stock_bestow_return_item ADD `stock_item_unit_id` int NULL
ALTER TABLE stock_bestow_return_item ADD `item_id` int NULL
ALTER TABLE stock_bestow_return_item ADD `stock_bestow_return_item_id` int NOT NULL
ALTER TABLE stock_bestow_return ADD `stock_bestow_return_date` date NULL
ALTER TABLE stock_bestow_return ADD `transaction_datetime` datetime NULL
ALTER TABLE stock_bestow_return ADD `item_count` int NULL
ALTER TABLE stock_bestow_return ADD `stock_user_id` int NULL
ALTER TABLE stock_bestow_return ADD `stock_bestow_id` int NULL
ALTER TABLE stock_bestow_return ADD `stock_bestow_return_no` varchar(50) NULL
ALTER TABLE stock_bestow_return ADD `supplier_id` int NULL
ALTER TABLE stock_bestow_return ADD `warehouse_id` int NULL
ALTER TABLE stock_bestow_list ADD `stock_bestow_id` int NULL
ALTER TABLE stock_bestow_list ADD `transaction_datetime` datetime NULL
ALTER TABLE stock_bestow_list ADD `item_qty` int NULL
ALTER TABLE stock_bestow_list ADD `stock_pack_qty` int NULL
ALTER TABLE stock_bestow_list ADD `item_list_id` int NULL
ALTER TABLE stock_bestow_list ADD `stock_bestow_item_id` int NULL
ALTER TABLE stock_bestow_item ADD `item_list_id` int NULL
ALTER TABLE stock_bestow_item ADD `stock_warehouse_qty` int NULL
ALTER TABLE stock_bestow_item ADD `return_qty` int NULL
ALTER TABLE stock_bestow_item ADD `hos_guid` varchar(38) NULL
ALTER TABLE stock_bestow_item ADD `stock_package_qty` int NULL
ALTER TABLE stock_bestow_item ADD `stock_item_unit_id` int NULL
ALTER TABLE stock_bestow_item ADD `bestow_item_expire` date NULL
ALTER TABLE stock_bestow_item ADD `bestow_item_lotno` varchar(50) NULL
ALTER TABLE stock_bestow_item ADD `bestow_total_price` float NOT NULL
ALTER TABLE stock_bestow_item ADD `bestow_item_unit` int NULL
ALTER TABLE stock_bestow_item ADD `bestow_unit_price` float NULL
ALTER TABLE stock_bestow_item ADD `bestow_item_status` char(1) NULL
ALTER TABLE stock_bestow_item ADD `bestow_item_qty` int NULL
ALTER TABLE stock_bestow_item ADD `item_id` int NULL
ALTER TABLE stock_bestow_item ADD `stock_bestow_id` int NULL
ALTER TABLE stock_bestow ADD `stock_user_id` int NULL
ALTER TABLE stock_bestow ADD `bestow_count` int NULL
ALTER TABLE stock_bestow ADD `hos_guid` varchar(255) NULL
ALTER TABLE stock_bestow ADD `stock_borrow_no` varchar(100) NULL
ALTER TABLE stock_bestow ADD `stock_bestow_status` varchar(1) NULL
ALTER TABLE stock_bestow ADD `Cancel_reason` varchar(100) NULL
ALTER TABLE stock_bestow ADD `Cancel_confirm` char(1) NULL
ALTER TABLE stock_bestow ADD `return_complete` char(1) NULL
ALTER TABLE stock_bestow ADD `warehouse_id` int NULL
ALTER TABLE stock_bestow ADD `stock_bestow_date` date NULL
ALTER TABLE stock_bestow ADD `supplier_id` int NULL
ALTER TABLE stock_bestow ADD `stock_bestow_no` varchar(255) NULL
ALTER TABLE stock_adj_item_list ADD `stock_item_unit_id` int NULL
ALTER TABLE stock_adj_item_list ADD `after_amount` int NULL
ALTER TABLE stock_adj_item_list ADD `before_amount` int NULL
ALTER TABLE stock_adj_item_list ADD `trancation_date` datetime NULL
ALTER TABLE stock_adj_item_list ADD `user_id` int NULL
ALTER TABLE stock_adj_item_list ADD `item_list_id` int NULL
ALTER TABLE opdscreen ADD `spo2` double(15,3) NULL
CREATE TABLE stock_trancation_itemdata ( `stock_trancation_id` int NOT NULL )
CREATE TABLE stock_test ( `stock_committee_group_id` int NULL )
CREATE TABLE stock_subcard ( `stock_substockcard_id` int NOT NULL )
CREATE TABLE stock_project_plan ( `project_plan_id` int NOT NULL )
CREATE TABLE stock_project ( `project_id` varchar(20) NOT NULL )
CREATE TABLE stock_masterunit ( `stock_masterunit_id` int NULL )
CREATE TABLE stock_committee_detail ( `stock_committee_Detail_id` int NOT NULL )
CREATE TABLE stock_co_po_detail ( `stock_co_po_detail_id` int NULL )
CREATE TABLE stock_check_warehouse_head ( `stock_check_warehouse_head_id` int NULL )
CREATE TABLE stock_check_warehouse_detail ( `stock_check_warehouse_detail_id` int NULL )
CREATE TABLE stock_budget_list ( `stock_budget_list_id` int NOT NULL )
CREATE TABLE stock_budget_detail ( `stock_budget_year` varchar(20) NOT NULL )
CREATE TABLE stock_borrow_status_remark ( `stock_borrow_status_remark_id` int NOT NULL )
CREATE TABLE stock_borrow_return_list ( `stock_borrow_return_item_id` int NULL )
CREATE TABLE stock_borrow_return_item ( `stock_borrow_return_id` int NOT NULL )
CREATE TABLE stock_borrow_return ( `stock_borrow_return_id` int NULL )
CREATE TABLE stock_bestow_return_list ( `stock_bestow_return_list_id` int NULL )
CREATE TABLE stock_bestow_return_item ( `stock_bestow_return_id` int NULL )
CREATE TABLE stock_bestow_return ( `stock_bestow_return_id` int NULL )
CREATE TABLE stock_bestow_list ( `stock_bestow_list_id` int NULL )
CREATE TABLE stock_bestow_item ( `stock_bestow_item_id` int NOT NULL )
CREATE TABLE stock_bestow ( `stock_bestow_id` int NOT NULL )
CREATE TABLE stock_adj_item_list ( `stock_adj_item_list_id` int NOT NULL )
Checking structure phase 1