Pharmacy NameRetail Pharmacy SegmentType Of Pharmacy
| Business Data Model Data Model |
| Description | An organization that is a provider of medicines and/or medical devices. A pharmacy may be within a healthcare facility such as a hospital or it may be a stand alone facility such as a retail pharmacy providing medications to the public. |
| Attributes | |
| Pharmacy Name |
|
| Retail Pharmacy Segment |
|
| Type Of Pharmacy |
|
| Relationship | |
 Pharmacy_Pharmacy Network_FK |
|
| Generalization | |
 Provider Generalization |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Pharmacy Name
| Description | The name of the pharmacy. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Retail Pharmacy Segment
| Description | Indicates whether a retail pharmacy is independent or part of a retail pharmacy company or other organization. For example: Chain drug store Food store Independent Mass merchandiser |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Type Of Pharmacy
| Description | Indicates whether the pharmacy dispenses drugs in a retail location, via the mail, or within a provider facility such as a hospital. For example: Hospital Retail |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Pharmacy_Pharmacy Network_FK
| Is Identifying Relationship | false |
| Child Table | Pharmacy |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Pharmacy Network |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Generalization Details |
Provider Generalization
| Supertype | Provider |
| Subtype | Pharmacy |
| Transform As | TABLE |
| Business Data Model Data Model |