CREATE TABLE DimPharmacie(
    id_pharmacie VARCHAR(15) PRIMARY KEY,
    ville VARCHAR(15),
    region VARCHAR(20)
)Engine=innodb;

CREATE TABLE DimDate(
    id_date DATE PRIMARY KEY,
    jour INT,
    mois INT,
    annee INT 
)Engine=innodb;

CREATE TABLE DimMedicament(
    id_medicament VARCHAR(15) PRIMARY KEY,
    categorie VARCHAR(15),
    nom VARCHAR(15)
)Engine=innodb;