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)