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