Upload
rawdha-mabrouki
View
27
Download
0
Embed Size (px)
Citation preview
Gestion de Maintenance Assistée Par
Ordinateur
Schéma de la base de données
AssetTable
AssetId (IE1,AK1)dataAreaId (FK,IE1,AK1,IE5,IE4,IE3,IE2)Partition (FK,IE1,AK1,IE5,IE4,IE3,IE2)
AssetGroup (AK1)AssetSourceType_CN (O) (IE5)AssetId (O) (FK,IE1)NameAlias (O) (IE2)RecId (AK2)WorkerContactName (O) (IE3)WorkerResponsible (O) (IE4)
GmaoDemandeT
dataAreaId (FK)AssetId (FK)NumDT Partition (FK)
RecId (AK1)
GmaoOrdreT
RecId
dataAreaId (FK,AK1)NumDT (O) (FK,AK1)Equipement (O) (AK1)NumOT (AK1)Partition (O) (FK,AK1)AssetId (O) (FK)
GmaoCorrectif
RecId (FK)
GmaoIntervention
RecId
dataAreaId (AK1)RecId (O) (FK,AK1)NumIntervention (AK1)Partition (O) (AK1)
GmaoLineIntervention
RecId
dataAreaId (FK)RecId (O) (FK)NumPieceDetach (O) (FK)Partition (O) (FK)AssetId (O) (FK)
GmaoPreventif
RecId (FK)
GMAOSystematic
RecId (FK)
GmaoPredictive
RecId (FK)
GMAOConditionnel
RecId (FK)
GmaoAmeliorative
RecId (FK)
GmaoCaracAssetTable
RecId
AssetId (O) (FK,AK1)dataAreaId (FK,AK1)Partition (O) (FK,AK1)
GmaoEtape
RecId
RecId (FK)
GmaoMecanique
RecId (FK)
GmaoLubrification
RecId (FK)
GmaoOutil
dataAreaId NumOutil Partition
RecId (AK1)
GmaoOutillage
AssetId (FK)dataAreaId (FK,FK)NumOutil (FK)Partition (FK,FK)
RecId (AK1)
GmaoPieceDetach
dataAreaId (FK)AssetId (FK)NumPieceDetach Partition (FK)
RecId (AK1)
GmaoContrat
RecId (FK)RecId (AK1)