Method for realizing drug dismounting based on POS cash register in pharmacy
A drug and pharmacy technology, applied in the field of Web pharmacy system platform, can solve the problems of wasting drugs, difficult maintenance, inconvenient sales of drugs, etc., and achieve the effect of simplifying the process of manual dismantling, rapid sales, and saving time
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment Construction
[0016] Such as figure 1 Shown, the present invention adopts following steps:
[0017] Step 1. Create the zero-disassembly master sheet and detail table, drug table, and inventory batch table. The master table is used to store information such as the date, quantity, and audit status of the zero-disassembly; for example:
[0018] / / 1. Main table
[0019] CREATE TABLE `split_order` (
[0020] `id` varchar(50) NOT NULL,
[0021] `splitNo` varchar(50) DEFAULT NULL,
[0022] `splitUser` varchar(30) DEFAULT NULL,
[0023] `splitType` int(11) DEFAULT NULL,
[0024] `splitDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
[0025] `auditState` int(11) DEFAULT NULL,
[0026] `auditor` varchar(30) DEFAULT NULL,
[0027] `auditorId` varchar(50) DEFAULT NULL,
[0028] ...
[0029] PRIMARY KEY (`productSplitId`)
[0030] ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[0031] / / 2, schedule
[0032] CREATE TABLE `split_order_detail` (
[0033] `id` varchar(50) N...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com