Structure Table 'Personnel'
Array
(
[0] => Array
(
[Field] => id
[Type] => int
[Null] => NO
[Key] => PRI
[Default] =>
[Extra] => auto_increment
)
[1] => Array
(
[Field] => matricule
[Type] => varchar(20)
[Null] => NO
[Key] => UNI
[Default] =>
[Extra] =>
)
[2] => Array
(
[Field] => prenom
[Type] => varchar(100)
[Null] => NO
[Key] =>
[Default] =>
[Extra] =>
)
[3] => Array
(
[Field] => nom
[Type] => varchar(100)
[Null] => NO
[Key] =>
[Default] =>
[Extra] =>
)
[4] => Array
(
[Field] => corps
[Type] => varchar(100)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[5] => Array
(
[Field] => date_naissance
[Type] => date
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[6] => Array
(
[Field] => sexe
[Type] => enum('M','F')
[Null] => NO
[Key] =>
[Default] =>
[Extra] =>
)
[7] => Array
(
[Field] => specialite
[Type] => varchar(100)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[8] => Array
(
[Field] => fonction
[Type] => varchar(100)
[Null] => YES
[Key] => MUL
[Default] =>
[Extra] =>
)
[9] => Array
(
[Field] => etablissement_id
[Type] => int
[Null] => YES
[Key] => MUL
[Default] =>
[Extra] =>
)
[10] => Array
(
[Field] => systeme
[Type] => varchar(50)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[11] => Array
(
[Field] => ief
[Type] => varchar(50)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[12] => Array
(
[Field] => created_at
[Type] => timestamp
[Null] => YES
[Key] =>
[Default] => CURRENT_TIMESTAMP
[Extra] => DEFAULT_GENERATED
)
[13] => Array
(
[Field] => updated_at
[Type] => timestamp
[Null] => YES
[Key] =>
[Default] => CURRENT_TIMESTAMP
[Extra] => DEFAULT_GENERATED on update CURRENT_TIMESTAMP
)
)