CREATE TABLE Acte (
  idActe INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  Acte_idCategorieActe INTEGER UNSIGNED NOT NULL,
  Acte_idTVA TINYINT UNSIGNED NOT NULL,
  Acte_Nom CHAR(30) NULL,
  Acte_PrixHT DECIMAL(10,3) NOT NULL,
  Acte_Affichage BOOL NULL,
  PRIMARY KEY(idActe)
);

CREATE TABLE Aliment (
  idAliment TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
  Aliment_Nom CHAR(30) NULL,
  Aliment_TypePrescription CHAR(30) NULL,
  Aliment_InfoComposition TEXT NULL,
  PRIMARY KEY(idAliment)
);

CREATE TABLE Analyse (
  idAnalyse INTEGER UNSIGNED NOT NULL,
  Analyse_idTypeAnalyse TINYINT UNSIGNED NOT NULL,
  Analyse_idConsultation INTEGER UNSIGNED NOT NULL,
  Analyse_Date DATE NULL,
  Analyse_Nom CHAR(45) NULL,
  Analyse_Resultat TEXT NULL,
  Analyse_LienFichierExterne CHAR(45) NULL,
  PRIMARY KEY(idAnalyse)
);

CREATE TABLE Animal (
  idAnimal INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  Animal_idClient MEDIUMINT UNSIGNED NULL,
  Animal_Nom CHAR(20) NULL,
  Animal_IdRace TINYINT UNSIGNED NULL,
  Animal_idRaceCroise TINYINT UNSIGNED NULL,
  Animal_DateDeNaissance DATE NULL,
  Animal_Sexe CHAR(3) NULL,
  Animal_IdRobe TINYINT UNSIGNED NULL,
  Animal_Tatouage CHAR(10) NULL,
  Animal_Puce CHAR(15) NULL,
  AnimalNoSIRE CHAR(9) NULL,
  Animal_DCD BOOL NULL,
  Animal_DateDCD DATE NULL,
  Animal_Incineration BOOL NULL,
  Animal_Perdu BOOL NULL,
  Animal_LOF BOOL NULL,
  Animal_Saillie BOOL NULL,
  Animal_Assure BOOL NULL,
  Animal_idAliment TINYINT UNSIGNED NULL,
  Animal_Note TEXT NULL,
  Animal_Poids CHAR(5) NULL,
  Animal_LienPhoto CHAR(40) NULL,
  PRIMARY KEY(idAnimal)
);

CREATE TABLE Banque (
  idBanque TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
  Banque_Nom CHAR(45) NULL,
  Banque_FormatCheque CHAR(45) NULL,
  PRIMARY KEY(idBanque)
);

CREATE TABLE Categorie (
  idCategorie TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
  Categorie_Nom CHAR(30) NULL,
  PRIMARY KEY(idCategorie)
);

CREATE TABLE CategorieActe (
  idCategorieActe INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  CategorieActe_Nom CHAR(30) NULL,
  PRIMARY KEY(idCategorieActe)
);

CREATE TABLE CERFA_Rage (
  idCERFA_Rage INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  CERFA_Rage_No CHAR(45) NULL,
  CERFA_Rage_Date DATE NULL,
  CERFA_Rage_idClient MEDIUMINT UNSIGNED NULL,
  CERFA_Rage_idAnimal INTEGER UNSIGNED NULL,
  CERFA_Rage_Primo BOOL NULL,
  CERFA_Rage_LotVaccin CHAR(10) NULL,
  CERFA_Rage_idLabo MEDIUMINT UNSIGNED NULL,
  CERFA_Rage_idVeto TINYINT UNSIGNED NULL,
  PRIMARY KEY(idCERFA_Rage)
);

CREATE TABLE Certificat (
  idCertificat INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  Certificat_Date DATE NULL,
  Certificat_Type CHAR NULL,
  Certificat_idVeto TINYINT UNSIGNED NULL,
  Certificat_idClient MEDIUMINT UNSIGNED NULL,
  Certificat_idAnimal INTEGER UNSIGNED NULL,
  Certificat_Nom TEXT NULL,
  PRIMARY KEY(idCertificat)
);

CREATE TABLE Civilite (
  idCivilite TINYINT UNSIGNED NOT NULL,
  Civilite_Nom CHAR(10) NULL,
  Civilite_NomLong CHAR(45) NULL,
  PRIMARY KEY(idCivilite)
);

CREATE TABLE Client (
  idClient MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
  Client_Nom CHAR(45) NULL,
  Client_IdCivilite TINYINT UNSIGNED NULL,
  Client_Prenom CHAR(45) NULL,
  Client_Rue CHAR(45) NULL,
  Client_Rue2 CHAR(45) NULL,
  Client_IdVille MEDIUMINT UNSIGNED NULL,
  Client_TelephoneDomicile CHAR(14) NULL,
  Client_TelephoneTravail CHAR(14) NULL,
  Client_Fax CHAR(14) NULL,
  Client_Portable CHAR(14) NULL,
  Client_Portable2 CHAR(14) NULL,
  Client_Mail CHAR(45) NULL,
  Client_Mail2 CHAR(45) NULL,
  Client_Note TINYTEXT NULL,
  Client_IdBanque TINYINT UNSIGNED NULL,
  Client_idCompteBanque MEDIUMINT UNSIGNED NULL,
  Client_TypeRappel CHAR NULL,
  Client_Profession CHAR(45) NULL,
  Client_Alerte CHAR(40) NULL,
  Client_idVetoReferant TINYINT UNSIGNED NULL,
  Client_idClientReferant INTEGER UNSIGNED NULL,
  PRIMARY KEY(idClient)
);

CREATE TABLE Commande (
  idCommande INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  Commande_idVeterinaire TINYINT UNSIGNED NULL,
  Commande_Date DATE NULL,
  Commande_PrixAchatTotal DECIMAL(10,3) NULL,
  Commande_envoye BOOL NULL,
  PRIMARY KEY(idCommande)
);

CREATE TABLE CompteBanque (
  idCompteBanque MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
  CompteBanque_idBanque TINYINT UNSIGNED NOT NULL,
  CompteBanque_CodeBanque CHAR(6) NULL,
  CompteBanque_CodeGuichet CHAR(6) NULL,
  CompteBanque_NoCompte CHAR(15) NULL,
  CompteBanque_CleRIB CHAR(5) NULL,
  CompteBanque_BIC CHAR(10) NULL,
  CompteBanque_Rue INTEGER UNSIGNED NULL,
  CompteBanque_idVille MEDIUMINT UNSIGNED NULL,
  CompteBanque_idPersonne INTEGER UNSIGNED NULL,
  PRIMARY KEY(idCompteBanque)
);

CREATE TABLE Consultation (
  idConsultation INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  Consultation_idAnimal INTEGER UNSIGNED NULL,
  Consultation_idClient MEDIUMINT UNSIGNED NULL,
  Consultation_Motif TINYTEXT NULL,
  Consultation_Date DATE NULL,
  Consultation_IdVeterinaire INTEGER UNSIGNED NULL,
  Consultation_Commemoratifs TEXT NULL,
  Consultation_ExamenClinique TEXT NULL,
  Consultation_Resume CHAR(40) NULL,
  Consultation_Poids CHAR(5) NULL,
  PRIMARY KEY(idConsultation)
);

CREATE TABLE DelegueLabo (
  idDelegueLabo MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
  DelegueLabo_Nom CHAR(45) NULL,
  DelegueLabo_idLabo MEDIUMINT UNSIGNED NULL,
  DelegueLabo_Telephone CHAR(14) NULL,
  DelegueLabo_TelephonePortable CHAR(14) NULL,
  DelegueLabo_Email CHAR(45) NULL,
  DelegueLabo_Fax CHAR(14) NULL,
  DelegueLabo_Note TEXT NULL,
  DelegueLabo_Adresse INTEGER UNSIGNED NULL,
  DelegueLabo_idVille MEDIUMINT UNSIGNED NULL,
  PRIMARY KEY(idDelegueLabo)
);

CREATE TABLE DetailAnalyseBiochimie (
  idDetailAnalyseBiochimie INTEGER UNSIGNED NOT NULL,
  DetailAnalyseBiochimie_idTypeAnalyse INTEGER UNSIGNED NULL,
  DetailAnalyseBiochimie_Albumine CHAR(6) NULL,
  DetailAnalyseBiochimie_Ammoniaque CHAR(6) NULL,
  DetailAnalyseBiochimie_Amylase CHAR(6) NULL,
  DetailAnalyseBiochimie_Bilirubine CHAR(6) NULL,
  DetailAnalyseBiochimie_Calcium CHAR(6) NULL,
  DetailAnalyseBiochimie_Cholesterol CHAR(6) NULL,
  DetailAnalyseBiochimie_CPK CHAR(6) NULL,
  DetailAnalyseBiochimie_Creatinine CHAR(6) NULL,
  DetailAnalyseBiochimie_GGT CHAR(6) NULL,
  DetailAnalyseBiochimie_Glucose CHAR(6) NULL,
  DetailAnalyseBiochimie_LDH CHAR(6) NULL,
  DetailAnalyseBiochimie_Lipase CHAR(6) NULL,
  DetailAnalyseBiochimie_Magnesium CHAR(6) NULL,
  DetailAnalyseBiochimie_Phosphore CHAR(6) NULL,
  DetailAnalyseBiochimie_PAL CHAR(6) NULL,
  DetailAnalyseBiochimie_Potassium CHAR(6) NULL,
  DetailAnalyseBiochimie_PT CHAR(6) NULL,
  DetailAnalyseBiochimie_SGOT CHAR(6) NULL,
  DetailAnalyseBiochimie_SGPT CHAR(6) NULL,
  DetailAnalyseBiochimie_Sodium CHAR(6) NULL,
  PRIMARY KEY(idDetailAnalyseBiochimie)
);

CREATE TABLE DetailAnalyseNFS (
  idDetailAnalyseNFS INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  DetailAnalyseNFS_idTypeAnalyse INTEGER UNSIGNED NULL,
  DetailAnalyseNFS_GR CHAR(10) NULL,
  DetailAnalyseNFS_Hb CHAR(5) NULL,
  DetailAnalyseNFS_Ht CHAR(5) NULL,
  DetailAnalyseNFS_VGM CHAR(5) NULL,
  DetailAnalyseNFS_TCMH CHAR(5) NULL,
  DetailAnalyseNFS_GB CHAR(10) NULL,
  DetailAnalyseNFS_pPNN CHAR(5) NULL,
  DetailAnalyseNFS_PNN CHAR(10) NULL,
  DetailAnalyseNFS_pEOS CHAR(5) NULL,
  DetailAnalyseNFS_EOS CHAR(10) NULL,
  DetailAnalyseNFS_pBAS CHAR(5) NULL,
  DetailAnalyseNFS_pLYM CHAR(5) NULL,
  DetailAnalyseNFS_LYM CHAR(10) NULL,
  DetailAnalyseNFS_RET CHAR(10) NULL,
  DetailAnalyseNFS_PLA CHAR(10) NULL,
  PRIMARY KEY(idDetailAnalyseNFS)
);

CREATE TABLE DetailAnalyseUrine (
  idDetailAnalyseUrine INTEGER UNSIGNED NOT NULL,
  DetailAnalyseUrine_pH CHAR(3) NULL,
  DetailAnalyseUrine_Cristaux CHAR(20) NULL,
  DetailAnalyseUrine_GR CHAR(10) NULL,
  DetailAnalyseUrine_GB CHAR(10) NULL,
  DetailAnalyseUrine_Aspect CHAR(20) NULL,
  DetailAnalyseUrine_Resultat TEXT NULL,
  PRIMARY KEY(idDetailAnalyseUrine)
);

CREATE TABLE DetailCommande (
  idDetailCommande INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  DetailCommande_idCommande INTEGER UNSIGNED NULL,
  DetailCommande_idProduit INTEGER UNSIGNED NULL,
  DetailCommande_PrixAchat INTEGER UNSIGNED NULL,
  DetailCommande_Quantite CHAR NULL,
  PRIMARY KEY(idDetailCommande)
);

CREATE TABLE Espece (
  idEspece TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
  Espece_Nom CHAR(30) NULL,
  PRIMARY KEY(idEspece)
);

CREATE TABLE Facture (
  idFacture INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  Facture_idConsultationOuHospitalisation INTEGER UNSIGNED NOT NULL,
  Facture_idClient MEDIUMINT UNSIGNED NOT NULL,
  Facture_idAnimal INTEGER UNSIGNED NOT NULL,
  Facture_Devis BOOL NULL,
  Facture_Date DATE NULL,
  Facture_Numero CHAR(20) NULL,
  Facture_SommeHT1 DECIMAL(10,3) NULL,
  Facture_TauxTVA1 TINYINT UNSIGNED NULL,
  Facture_TVA1 DECIMAL(10,3) NULL,
  Facture_SommeHT2 DECIMAL(10,3) NULL,
  Facture_TauxTVA2 TINYINT UNSIGNED NULL,
  Facture_TVA2 DECIMAL(10,3) NULL,
  Facture_SommeHT3 DECIMAL(10,3) NULL,
  Facture_TauxTVA3 TINYINT UNSIGNED NULL,
  Facture_TVA3 DECIMAL(10,3) NULL,
  Facture_FichierExterne CHAR(20) NULL,
  PRIMARY KEY(idFacture)
);

CREATE TABLE Fournisseur (
  idFournisseur MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
  Fournisseur_idFournisseur MEDIUMINT UNSIGNED NOT NULL,
  Fournisseur_Nom CHAR(30) NULL,
  Fournisseur_Web CHAR(50) NULL,
  Fournisseur_Tel CHAR(15) NULL,
  Fournisseur_Fax CHAR(15) NULL,
  Fournisseur_TypeEnvoieCommande CHAR NULL,
  Fournisseur_Adresse CHAR(45) NULL,
  Fournisseur_idVille MEDIUMINT UNSIGNED NULL,
  Fournisseur_idDelegue MEDIUMINT UNSIGNED NULL,
  PRIMARY KEY(idFournisseur)
);

CREATE TABLE Incineration (
  idIncineration INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  Incineration_DateEnlevement DATE NULL,
  Incineration_idCompagnie MEDIUMINT UNSIGNED NULL,
  Incineration_Type CHAR NULL,
  Incineration_idAnimal INTEGER UNSIGNED NULL,
  Incineration_idClient MEDIUMINT UNSIGNED NULL,
  PRIMARY KEY(idIncineration)
);

CREATE TABLE JourHospitalisation (
  idJourHospitalisation INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  JourHospitalisation_Date INTEGER UNSIGNED NULL,
  JourHospitalisation_idAnimal INTEGER UNSIGNED NULL,
  JourHospitalisation_idClient INTEGER UNSIGNED NULL,
  JourHospitalisation_Motif TINYTEXT NULL,
  JourHospitalisation_Rapport TEXT NULL,
  JourHospitalisation_idVeterinaire TINYINT UNSIGNED NULL,
  JourHospitalisation_AFacturer BOOL NULL,
  PRIMARY KEY(idJourHospitalisation)
);

CREATE TABLE lien_Analyse_MotClef (
  Analyse_idAnalyse INTEGER UNSIGNED NOT NULL,
  MotClef_idMotClef TINYINT UNSIGNED NOT NULL,
  PRIMARY KEY(Analyse_idAnalyse, MotClef_idMotClef)
);

CREATE TABLE lien_Consultation_MotClef (
  Consultation_idConsultation INTEGER UNSIGNED NOT NULL,
  MotClef_idMotClef TINYINT UNSIGNED NOT NULL,
  PRIMARY KEY(Consultation_idConsultation, MotClef_idMotClef),
  INDEX Consultation_has_MotClef_FKIndex1(Consultation_idConsultation),
  INDEX Consultation_has_MotClef_FKIndex2(MotClef_idMotClef)
);

CREATE TABLE LigneOrdonnance (
  idLigneOrdonnance BIGINT NOT NULL AUTO_INCREMENT,
  LigneOrdonnance_idOrdonnance INTEGER UNSIGNED NOT NULL,
  LigneOrdonnance_NoLigne INTEGER UNSIGNED NULL,
  LigneOrdonnance_Posologie TEXT NULL,
  LigneOrdonnance_NbRenouvellement CHAR NULL,
  PRIMARY KEY(idLigneOrdonnance)
);

CREATE TABLE ModeReglement (
  idModeReglement TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
  ModeReglement_Nom CHAR(10) NULL,
  PRIMARY KEY(idModeReglement)
);

CREATE TABLE MotClef (
  idMotClef TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
  MotClef_Nom CHAR(10) NULL,
  PRIMARY KEY(idMotClef)
);

CREATE TABLE Ordonnance (
  idOrdonnance INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  Ordonnance_idAnimal INTEGER UNSIGNED NOT NULL,
  Ordonnance_idConsultation INTEGER UNSIGNED NOT NULL,
  Ordonnance_idClient MEDIUMINT UNSIGNED NULL,
  Ordonnance_Date DATE NULL,
  Ordonnance_Securise BOOL NULL,
  Ordonnance_Info TEXT NULL,
  Ordonnance_LienExterne CHAR(20) NULL,
  PRIMARY KEY(idOrdonnance)
);

CREATE TABLE Passeport (
  idPasseport INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  Passeport_No CHAR(20) NULL,
  Passeport_idAnimal INTEGER UNSIGNED NULL,
  Passeport_idClient MEDIUMINT UNSIGNED NULL,
  Passeport_DateDelivrance DATE NULL,
  Passeport_Etat CHAR NULL DEFAULT 'S',
  Passeport_DateRetrait DATE NULL,
  Passeport_idVeterinaire TINYINT UNSIGNED NULL,
  PRIMARY KEY(idPasseport)
);

CREATE TABLE Pays (
  idPays SMALLINT UNSIGNED NOT NULL,
  Pays_Nom CHAR(45) NULL,
  PRIMARY KEY(idPays)
);

CREATE TABLE Produit (
  idProduit INTEGER UNSIGNED NOT NULL,
  Produit_Nom CHAR(30) NULL,
  Produit_Classe CHAR NULL,
  Produit_idSousSousCategorie TINYINT UNSIGNED NOT NULL,
  Produit_idCategorie TINYINT UNSIGNED NOT NULL,
  Produit_idSousCategorie TINYINT UNSIGNED NOT NULL,
  Produit_NomComplet CHAR(40) NULL,
  Produit_CodeCIP CHAR(10) NULL,
  Produit_CodeFournisseur CHAR(10) NULL,
  Produit_NouveauPrixAchatHT DECIMAL(10,3) NULL,
  Produit_PrixAchatHT DECIMAL(10,3) NULL,
  Produit_Marge CHAR(3) NULL,
  Produit_idTVA TINYINT UNSIGNED NOT NULL,
  ProduitTauxMarque CHAR(3) NULL,
  Produit_Prefere BOOL NULL,
  Produit_Affichage BOOL NULL,
  Produit_idFournisseur MEDIUMINT UNSIGNED NULL,
  Produit_Stock SMALLINT UNSIGNED NULL,
  Produit_StockMin SMALLINT UNSIGNED NULL,
  Produit_QuantiteACommander SMALLINT UNSIGNED NULL,
  Produit_StockAncienPrixAchatHT DECIMAL(10,3) NULL,
  Produit_StockAncien SMALLINT UNSIGNED NULL,
  Produit_PrixAchatStockValide BOOL NULL,
  PRIMARY KEY(idProduit)
);

CREATE TABLE Race (
  idRace TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
  Race_idEspece TINYINT UNSIGNED NOT NULL,
  Race_Nom CHAR(30) NULL,
  Race_PoidsAdulteMaleMin CHAR(5) NULL,
  Race_PoidsAdulteMaleMax CHAR(5) NULL,
  Race_PoidsAdulteFemelleMin CHAR(5) NULL,
  Race_PoidsAdulteFemelleMax CHAR(5) NULL,
  PRIMARY KEY(idRace)
);

CREATE TABLE Recette (
  idRecette INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  Recette_idFacture INTEGER UNSIGNED NOT NULL,
  Recette_idModeReglement TINYINT UNSIGNED NOT NULL,
  Recette_Date DATE NULL,
  Recette_SommeReglee DECIMAL(10,3) NULL,
  PRIMARY KEY(idRecette)
);

CREATE TABLE RegistreStupefiant (
  idRegistreStupefiant INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  RegistreStupefiant_Date DATE NULL,
  RegistreStupefiant_idProduit INTEGER UNSIGNED NULL,
  RegistreStupefiant_Stock TINYINT UNSIGNED NULL,
  RegistreStupefiant_idAnimal INTEGER UNSIGNED NULL,
  RegistreStupefiant_idClient MEDIUMINT UNSIGNED NULL,
  RegistreStupefiant_QuantiteDelivree TINYINT NULL,
  PRIMARY KEY(idRegistreStupefiant)
);

CREATE TABLE RelanceVaccins (
  idRelanceVaccins INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  RelanceVaccins_idAnimal INTEGER UNSIGNED NOT NULL,
  RelanceVaccin_idTypeVaccin TINYINT UNSIGNED NOT NULL,
  RelanceVaccins_Date INTEGER UNSIGNED NULL,
  RelanceVaccins_idTypeVaccin INTEGER UNSIGNED NULL,
  RelanceVaccins_Envoye BOOL NULL,
  RelanceVaccins_DateEnvoi DATE NULL,
  RelanceVaccins_idClient MEDIUMINT UNSIGNED NULL,
  PRIMARY KEY(idRelanceVaccins, RelanceVaccins_idAnimal)
);

CREATE TABLE RendezVous (
  idRendezVous INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  RendezVous_Annee CHAR(2) NULL,
  RendezVous_Mois CHAR(2) NULL,
  RendezVous_Jour CHAR(2) NULL,
  RendezVous_Heure TIME NULL,
  RendezVous_Arrive TIME NULL,
  RendezVous_idClient MEDIUMINT UNSIGNED NULL,
  RendezVous_idAnimal INTEGER UNSIGNED NULL,
  RendezVous_Motif CHAR NULL,
  RendezVous_MotifTexte CHAR(20) NULL,
  RendezVous_Accident CHAR NULL,
  PRIMARY KEY(idRendezVous)
);

CREATE TABLE Robe (
  idRobe TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
  Robe_Nom CHAR(20) NULL,
  PRIMARY KEY(idRobe)
);

CREATE TABLE SousCategorie (
  idSousCategorie TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
  SousCategorie_Nom CHAR(30) NULL,
  PRIMARY KEY(idSousCategorie)
);

CREATE TABLE SousSousCategorie (
  idSousSousCategorie TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
  SousSousCategorie_Nom CHAR(30) NULL,
  PRIMARY KEY(idSousSousCategorie)
);

CREATE TABLE TVA (
  idTVA TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
  TVA_Taux INTEGER UNSIGNED NULL,
  PRIMARY KEY(idTVA)
);

CREATE TABLE TypeAnalyse (
  idTypeAnalyse TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
  TypeAnalyse_Nom CHAR(20) NULL,
  PRIMARY KEY(idTypeAnalyse)
);

CREATE TABLE TypeVaccin (
  idTypeVaccin TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
  TypeVaccin_Nom CHAR(40) NULL,
  TypeVaccin_LienLettreVaccin CHAR(40) NULL,
  TypeVaccin_NomCourt CHAR(10) NULL,
  TypeVaccin_DelaiRappelEnMois CHAR NULL,
  PRIMARY KEY(idTypeVaccin)
);

CREATE TABLE UnActe (
  idUnActe BIGINT NOT NULL AUTO_INCREMENT,
  UnActe_Heure TIME NULL,
  UnActe_idActe INTEGER UNSIGNED NOT NULL,
  UnActe_EnHospitalisation BOOL NULL,
  UnActe_idConsultationOuHospitalisation INTEGER UNSIGNED NULL,
  UnActe_idFacture INTEGER UNSIGNED NOT NULL,
  UnActe_idTVA TINYINT UNSIGNED NOT NULL,
  UnActe_PrixHT DECIMAL(10,3) NULL,
  UnActe_Quantite TINYINT UNSIGNED NULL,
  UnActe_AFacturer BOOL NULL,
  UnActe_QuantiteInjectee CHAR(6) NULL,
  UnActe_idVeterinaire TINYINT UNSIGNED NULL,
  PRIMARY KEY(idUnActe)
);

CREATE TABLE UnMedicament (
  idUnMedicament BIGINT NOT NULL AUTO_INCREMENT,
  UnMedicament_idLigneOrdonnance BIGINT NOT NULL,
  UnMedicament_idFacture INTEGER UNSIGNED NOT NULL,
  UnMedicament_idTVA TINYINT UNSIGNED NOT NULL,
  UnMedicament_idProduit INTEGER UNSIGNED NOT NULL,
  UnMedicament_PrixVenteHT DECIMAL(10,3) NULL,
  UnMedicament_QuantiteDelivree CHAR NULL,
  UnMedicament_EnHospitalisation BOOL NULL,
  UnMedicament_idConsultationOuHospitalisation INTEGER UNSIGNED NULL,
  UnMedicament_AFacturer BOOL NULL,
  UnMedicament_Heure TIME NULL,
  UnMedicament_idVeterinaire TINYINT UNSIGNED NULL,
  PRIMARY KEY(idUnMedicament, UnMedicament_idLigneOrdonnance)
);

CREATE TABLE Veterinaire (
  idVeterinaire TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
  Veterinaire_idCompteBanque MEDIUMINT UNSIGNED NOT NULL,
  Veterinaire_Nom CHAR(45) NULL,
  Veterinaire_NoOrdre CHAR(20) NULL,
  VeterinaireNoTVA CHAR(20) NULL,
  Veterinaire_Fonction CHAR(20) NULL,
  Veterinaire_idCivilite TINYINT UNSIGNED NULL,
  PRIMARY KEY(idVeterinaire)
);

CREATE TABLE Ville (
  idVille MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
  Ville_Nom CHAR(45) NULL,
  Ville_CodePostal CHAR(6) NULL,
  Ville_IdPays SMALLINT UNSIGNED NULL,
  PRIMARY KEY(idVille)
);