Base de données gmao

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)