Forum Discussion

hamzaallali's avatar
hamzaallali
New Member
3 years ago

Maintenance services analysis

So I Have Some Data Of A Company And It's As Follows, I Hava 6 Tables :
gestion_services (igserv, idserv, type_service)
`gestion_maintenance` (
`id_maintenance` int(11) NOT NULL AUTO_INCREMENT,
`date_d` datetime NOT NULL,
`prix_maintenance` float NOT NULL,
`taxe_maintenance` float NOT NULL,
`imei_v` varchar(16) NOT NULL,
`user_id` int(11) NOT NULL,
`nom_v` varchar(50) NOT NULL,
)

`gestion_vidange` (
`id_vidange` int(11) NOT NULL AUTO_INCREMENT,
`date_d` datetime NOT NULL,
`km_s_vid` float NOT NULL,
`km_e_vid` float NOT NULL,
`prix_vidange` float NOT NULL,
`taxe_vidange` float NOT NULL,
`imei_v` varchar(16) NOT NULL,
`user_id` int(11) NOT NULL,
`nom_v` varchar(50) NOT NULL,
)

`gestion_vignette` (
`id_vignette` int(11) NOT NULL AUTO_INCREMENT,
`date_d` datetime NOT NULL,
`date_f` datetime NOT NULL,
`prix_vignette` float NOT NULL,
`taxe_vignette` float NOT NULL,
`imei_v` varchar(16) NOT NULL,
`user_id` int(11) NOT NULL,
`nom_V` varchar(50) NOT NULL,
)

`gestion_visite` (
`id_visite` int(11) NOT NULL AUTO_INCREMENT,
`date_d` datetime NOT NULL,
`date_F` datetime NOT NULL,
`prix_visite` float NOT NULL,
`taxe_visite` float NOT NULL,
`imei_v` varchar(16) NOT NULL,
`user_id` int(11) NOT NULL,
`nom_V` varchar(50) NOT NULL,
)

`gestion_assurance` (
`id_assurance` int(11) NOT NULL AUTO_INCREMENT,
`date_d` datetime NOT NULL,
`date_f` datetime NOT NULL,
`prix_assurance` float NOT NULL,
`taxe_assurance` float NOT NULL,
`user_id` int(11) NOT NULL,
`nom_V` varchar(50) NOT NULL,
`imei_v` varchar(16) NOT NULL,
)

This Is How The Tables are Shaped, What I Want Is To Do SOme Visuals So I Can Get Some organized infos on the services done on a vehicle. I don't know what to do because i'm still a beginner on this. i asked chatGPT but it always miss understands the data and says some general stuff.

1 Reply