pharmacies


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of pharmacies.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Contains records of pharmacies that a patient uses, or that providers interact with

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 0
patient_data.pharmacy_id Defined in XML R
prescriptions.pharmacy_id Defined in XML R
name VARCHAR 255 √ NULL
transmit_method INT 10 1
email VARCHAR 255 √ NULL
ncpdp INT 10 √ NULL
npi INT 10 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation