pharmacies

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