BDD gestion personnel

Personnel:
======
Nom_du_champ       type                 valeur          options
id                              int                                        auto_increment, clé primaire
nom                         varchar(100)
prenom                    varchar(100)
status                      int 
date_arrivee           datetime
date_depart            datetime

salaire:
=====
id_personnel           int
date                        date
montant                  double
commentaire           varchar(200)

tranche_horaire:
==========
id                            int                                         auto_increment, clé primaire
montant                 double

tarification_produit:
============
id_personnel          int
id_produit              int
heure                     time
id_tranche_horaire      int

produit:
=====
id                           int                                          auto_increment, clé primaire
intitule                   varchar(100)
commentaire         varchar(200)

CREATE DATABASE `gestion_personnel` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

 CREATE TABLE `gestion_personnel`.`personnel` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`prenom` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`nom` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`status` INT NOT NULL ,
`date_arrivee` DATE NOT NULL ,
`date_depart` DATE NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci ;

 CREATE TABLE `gestion_personnel`.`salaire` (
`id_personnel` INT NOT NULL ,
`date` DATE NOT NULL ,
`montant` DOUBLE NOT NULL ,
`commentaire` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

 CREATE TABLE `gestion_personnel`.`tranche_horaire` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`montant` DOUBLE NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci ;

 CREATE TABLE `gestion_personnel`.`tarification_produit` (
`id_personnel` INT NOT NULL ,
`id_produit` INT NOT NULL ,
`heure` TIME NOT NULL ,
`id_tranche_horaire` INT NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

 CREATE TABLE `gestion_personnel`.`produit` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`intitule` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`commentaire` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;