白丝美女被狂躁免费视频网站,500av导航大全精品,yw.193.cnc爆乳尤物未满,97se亚洲综合色区,аⅴ天堂中文在线网官网

Pharmacy database structure component

專利號
US10867704B2
公開日期
2020-12-15
申請人
MediSite Inc.(US MI West Bloomfield)
發(fā)明人
Edward J. Eng
IPC分類
G06Q10/00; G16H50/30; G16H40/20; G16H20/10
技術(shù)領(lǐng)域
pharmacy,drug,database,computer,prescriber,retail,data,requester,pharmacist,component
地域: MI MI West Bloomfield

摘要

A data structure embodied on a computer-readable medium having a database schema for accessing and managing pharmacy transactions data in a structured query language (SQL) database. The database schema includes a session data schema representing a relational data table for capturing a plurality of sessions for accessing and managing the SQL database and a pharmacy prescription drug transaction results schema representing parameters for relating prescription drug transaction results with requesters, prescribers and the prescription drug. The session data schema and the pharmacy prescription drug transaction results schema used by a pharmacy business logic application to access and manage the pharmacy drug transaction results in the SQL database.

說明書

Referring back to FIG. 1, a prescription drug transaction access and monitoring computer system 24 is depicted. As depicted in FIG. 1, computer system 24 is contained within a cloud computing environment. Computer system 24 includes a server 26, database 28, firewall 30, switch 31 and computer software residing on the server 26. Firewall 30 ensures that computer system 24 is Health Insurance Portability and Accountability Act (HIPAA) compliant. Data transmitted from and received by computer system 24 pass through firewall 30 using a key service, such as, SSL POS version 1.2, to encrypt the data. Switch 31 permits load balancing of incoming network connections from external network 22. Server 26 can be placed in multiple locations for load balancing and fail over network redundancy. Server 26 is configured to access database 28 over internal communication network 32. Server 26 and firewall 30 are configured to transmit and receive data from the other over internal communication network 32. Computer system 24 is configured to transmit and receive data over external network 22 from retail pharmacy transaction computer systems 12a, 12b and 12c. This configuration permits server 26 to collect, query and report controlled prescription drug transaction data from retail pharmacy transaction computer systems 12a, 12b and 12c. However, pharmacy transaction computer systems 12a, 12b and 12c are not configured and cannot communicate with each other to share data relating to prescription drug transactions. Client computers 18a, 18b1-3 and 18c1-5 are each configured to provide a secure access point to the computer software residing on server 26 such that each is configured to display pharmacy transaction information through a user interface and receive information input by the user, typically a pharmacist. Accordingly, the software residing on server 26 can be accessed as Software as a Service (“SaaS”). This user interface may be executed locally on each of the user computers 18a, 18b1-3 and 18c1-5 and/or remotely by the server 26.

權(quán)利要求

1
微信群二維碼
意見反饋