HMC_ERD

Tables (7)

VehicleConfig (Main_table)

  • id — PK — Primary key — NOT NULL
  • platform (Field) — varchar(25)
  • front_susp (Field2) — varchar(25)
  • rear_susp (Field3) — varchar(25)
  • body (Field4) — varchar(25)
  • pt (Field5) — varchar(25)
  • a_radial (Field6) — float
  • a_axial (Field7) — float
  • top_axial (Field8) — float
  • g_void (Field9) — float
  • g_bridge (Field10) — float
  • g_axial (Field11) — float
  • spring (Field12) — float
  • damper (Field13) — float
  • dura_1 (Field14) — float
  • dura_2 (Field15) — float
  • update_time (Field17) — timestamp

Vehicle_domain (Untitled4)

  • domain_type (Key) — VARCHAR(25) — Primary key — NOT NULL — 복합 PK
  • domain_value (Key2) — VARCHAR(25) — Primary key — NOT NULL — 복합 PK

etl_log (Untitled5)

  • id — PK — Primary key — NOT NULL
  • raw_db_row (Field) — int
  • train_db_row (Field2) — nt
  • file_backup_row (Field3) — int
  • upload_time (Field4) — timestamp

model (Untitled2)

  • model_version (Key) — varchar(25) — Primary key — NOT NULL
  • create_time (Field) — timestamp
  • Field2

model_performence (Untitled)

  • model_version (Key) — varchar(25) — Foreign key → model.model_version — NOT NULL
  • model_type (Field2) — VARCHAR(25)
  • model_performence (Field3) — float

train VehicleConfig (CopyOfMain_table)

  • id — PK — Primary key — NOT NULL
  • platform (Field) — varchar(25)
  • front_susp (Field2) — varchar(25)
  • rear_susp (Field3) — varchar(25)
  • body (Field4) — varchar(25)
  • pt (Field5) — varchar(25)
  • a_radial (Field6) — float
  • a_axial (Field7) — float
  • top_axial (Field8) — float
  • g_void (Field9) — float
  • g_bridge (Field10) — float
  • g_axial (Field11) — float
  • spring (Field12) — float
  • damper (Field13) — float
  • dura_1 (Field14) — float
  • dura_2 (Field15) — float
  • update_time (Field17) — timestamp

visual (Untitled3)

  • id (Key) — PK — Primary key — NOT NULL
  • value_type (Field) — VARCHAR(25)
  • dura_1 (Field2) — float
  • dura_2 (Field3) — float
  • rh_1 (Field4) — float
  • rh_2 (Field5) — float
  • rh_3 (Field6) — float
  • nvh_1 (Field7) — float
  • nvh_2 (Field8) — float
  • create_time (Field9) — timestamp
  • user (Field10) — VARCHAR(10)