fmeca

Tables (12)

Bomcode (Untitled2)

  • _id (Key) — ObjectId — Primary key — NOT NULL
  • bomCode (Field) — String
  • name (Field2) — String
  • engName (Field3) — String

CasualtyCritically (Untitled8)

  • casualtyCritically (Key) — Primary key — NOT NULL
  • frequency (Field) — String
  • severity (Field2) — String
  • riskLevel (Field3) — String

Fmeca (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • bom_id (Key2) — ObjectId — Foreign key → Bomcode._id — NOT NULL
  • unitFr (Field) — double
  • fleetFr (Field2) — double
  • basisRef (Field3) — String
  • operationMode (Field4) — String
  • trainStructure (Key22) — Foreign key → TrainStructure.trainStructure — NOT NULL — 물리적 연관 X
  • functionList (Key4) — Foreign key → FunctionList.functionList — NOT NULL

FrCause (Untitled11)

  • frCauseId (Key) — Long — Primary key — NOT NULL
  • frCause (Field) — String

FrCauseList (Untitled10)

  • frCauseList (Key) — Primary key — NOT NULL
  • frCauseId (Key2) — Long — Foreign key → FrCause.frCauseId — NOT NULL
  • local (Field) — String
  • subSystem (Field2) — String
  • system (Field3) — String
  • frDetectionMethodList (Key3) — Foreign key → FrDetectionMethodList.frDetectionMethodList — NOT NULL — 물리적 연관 X

FrDetectionMethodList (Untitled12)

  • frDetectionMethodList (Key) — Primary key — NOT NULL
  • id (Field) — Long
  • frDetectionMethod (Field2) — String

FrMode (Untitled6)

  • frModeId (Key) — Long — Primary key — NOT NULL
  • frMode (Field) — String

FrModeList (Untitled5)

  • frModeList (Key) — Primary key — NOT NULL
  • frModeId (Key2) — Long — Foreign key → FrMode.frModeId — NOT NULL
  • occurrenceRatio (Field) — double
  • incidenceRate (Field2) — double
  • local (Field3) — String
  • subSystem (Field4) — String
  • system (Field5) — String
  • isServiceFr (Field6) — boolean
  • serviceFrRate (Field7) — double
  • Field8
  • serviceCritically (Key3) — Foreign key → ServiceCritically.serviceCritically — NOT NULL — 물리적 연관 X
  • casualtyCritically (Key4) — Foreign key → CasualtyCritically.casualtyCritically — NOT NULL — 물리적 연관 X
  • stabilityImpact (Field9) — Stirng
  • mitigationMeasureList (Key5) — Foreign key → MitigationMeasureList.mitigationMeasureList — NOT NULL — 물리적 연관 X
  • frCauseList (Key6) — Foreign key → FrCauseList.frCauseList — NOT NULL — 물리적 연관 X

FunctionList (Untitled4)

  • functionList (Key) — Primary key — NOT NULL
  • function (Field) — String
  • frModeList (Key2) — Foreign key → FrModeList.frModeList — NOT NULL — 물리적 연관 X

MitigationMeasureList (Untitled9)

  • mitigationMeasureList (Key) — Primary key — NOT NULL
  • id (Field) — Long
  • mitigationMeasure (Field2) — String

ServiceCritically (Untitled7)

  • serviceCritically (Key) — Primary key — NOT NULL
  • frequency (Field) — String
  • severity (Field2) — String
  • riskLevel (Field3) — String

TrainStructure (Untitled3)

  • trainStructure (Key2) — Primary key — NOT NULL
  • id (Field3) — Long
  • name (Field) — String
  • value (Field2) — int