Readme.txt

1. Filename: Installation_Instructions_MariaDB.pdf
2. Filename: NPI_MARIA_DUMP.sql (Database)
3. Filename: Database_Diagram.png (Database ERD)
4. Filename: NPI_ERD_CREATION_SCRIPT.sql (NPI database script to create an ERD)
6. Filename: EULA.txt (The EULA)


Tables:
Address_Type
Country_Code
Entity_Type
Identifier_Type
DimDate
National_Downloadable_File_ProviderGroups
National_Downloadable_File_ProviderHospital_Affiliations
Practitioner_EndPoint
Practitioner_Contact
Practitioner_Identifier
OtherName_Type
Practitioner_Taxonomy
Practitioner_Address
Practitioner_Telephone
Practitioner_Taxonomy_Group
Telephone_Type
List_State
BASIC_Output
sysdiagrams
Taxonomy
Taxonomy_Group_Type
Provider_Name_Type
Practitioner_Othername
Practitioner
Zip

Views:
vw_All_Addresses_Phones
vw_Practitioner_Pecos
vw_Practitioner_Identifications
vw_Practitioner_Taxonomies
vw_Practitioner_Taxonomy_Groups

Procedures:
pSearch_By_NPI_Individual_Details
pSearch_By_NPI_Organization_Details
pSearch_Individual_By_Name_State
pSearch_Organization_By_OrgName_State
pSelect_Addresses_By_NPI
pSelect_Detailed_Record_By_NPI
pSelect_High_Detailed_Record_By_NPI
pSelect_Identifiers_By_NPI
pSelect_Json_By_NPI
pSelect_PracticeOfficialContact_By_NPI
pSelect_Record_Counts
pSelect_State_Licenses_By_NPI
pSelect_Taxonomies_By_NPI
pSelect_Telephones_By_NPI