schema.sql

SQL schemav

CREATE TABLE IF NOT EXISTS "drugs_list" (
        "NDC"   TEXT,
        "DrugName"      TEXT,
        "GenericName"   TEXT,
        "Strength"      INTEGER,
        "StrengthUOM"   TEXT,
        "DoseForm"      TEXT,
        "MONY"  TEXT,
        "GPI"   REAL,
        "PackageSize"   REAL,
        "RxOTCInd"      TEXT,
        "ProductName"   TEXT,
        "TpaRestrictionCode"    INTEGER,
        "RouteOfAdministration" TEXT,
        "MAINTDRUGCODE" TEXT
);