白丝美女被狂躁免费视频网站,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.

說明書

Non-limiting examples of general classes of pharmacy transaction information 100 housed in databases include pharmacy identification information 102, pharmacist identification information 104, customer information 106, prescriber information 108, and prescription drug information 110, as shown in FIG. 2. While these general classes of pharmacy information 100 may be housed in each of the databases, they are stored in different formats and data structures. Accordingly, the pharmacy transaction information 100 of all databases is not interoperable to make real-time prescription fulfillment decisions and is non-usable by unrelated pharmacies.

The pharmacy identification information 102 may include, without limitation, a transaction number, a merchant code, a pharmacy location number, a location category code, longitude of location, latitude of location, address of location, zip code of location, carrier code of the location and/or hot spot score for the location.

The pharmacist identification information 104 may include, without limitation, a pharmacist's first name, a pharmacist's last name, a pharmacist's national license number, a pharmacy employee number, a logon date, a logon time in, and a logon time out. The log date and time relate to when the pharmacist logs on and logs off of the retail pharmacy transaction computer systems 12a, 12b and 12c.

權(quán)利要求

1
微信群二維碼
意見反饋