motioncore
Tables (33)
TB_ACCESS_HIST
- ACCESS_ID — int(11) — Primary key — NOT NULL
- USER_ID — int(11) — NOT NULL
- USER_NAME — varchar(20) — NOT NULL
- ACCESS_TYPE — varchar(30) — NOT NULL
- ACCESS_TIME — datetime — NOT NULL
- ACCESS_IP — varchar(40) — NOT NULL
TB_ACTION_MST
- ACTION_ID — varchar(50) — Primary key — NOT NULL
- ACTION_NAME — varchar(50) — NOT NULL
- ACTION_DESC — varchar(100) — NOT NULL
- ACTION_PARAM — varchar(100) — NOT NULL
- LAST_CHANGED_DATE — datetime — NOT NULL
- LAST_CHANGED_USER_ID — int(11) — NOT NULL
- ENABLE — varchar(1) — NOT NULL
TB_CENTER_CHART_MAP
- center_id — varchar(24) — Primary key — NOT NULL
- chart_id — varchar(40) — Primary key — NOT NULL
- last_changed_date — datetime — NOT NULL
- last_changed_user_id — int(11) — NOT NULL
- enable — varchar(1) — NOT NULL
TB_CENTER_MST
- CENTER_ID — varchar(24) — Primary key — NOT NULL
- CENTER_NAME — varchar(100) — NOT NULL
- CENTER_CLASS_CODE — varchar(1) — NOT NULL
- ADDRESS — varchar(180) — NOT NULL
- ADDRESS_DETAIL — varchar(40)
- latitude — varchar(20)
- longitude — varchar(20)
- BUSINESS_NO — varchar(20)
- MANAGER_NAME — varchar(20) — NOT NULL
- TEL_NO — varchar(20) — NOT NULL
- EMAIL — varchar(40) — NOT NULL
- LAST_CHANGED_DATE — datetime — NOT NULL
- LAST_CHANGED_USER_ID — int(11) — NOT NULL
- ENABLE — varchar(1) — NOT NULL
- options — varchar(100)
TB_CENTER_REPORT_MAP
- CENTER_ID — varchar(24) — Primary key — NOT NULL
- REPORT_ID — varchar(40) — Primary key — NOT NULL
- LAST_CHANGED_DATE — datetime — NOT NULL
- LAST_CHANGED_USER_ID — int(11) — NOT NULL
- ENABLE — varchar(1) — NOT NULL
TB_CHART_MST
- chart_id — varchar(40) — Primary key — NOT NULL
- chart_url — varchar(100) — NOT NULL
- chart_title — varchar(40) — NOT NULL
- chart_desc — varchar(100) — NOT NULL
- chart_color — varchar(10)
- inspect_type — varchar(20) — NOT NULL
- last_changed_date — datetime — NOT NULL
- last_changed_user_id — int(11) — NOT NULL
- enable — varchar(1) — NOT NULL
TB_CM_CODE_MST
- CLASS_CODE — varchar(40) — Primary key — NOT NULL
- CODE — varchar(40) — Primary key — NOT NULL
- CLASS_NAME — varchar(50) — NOT NULL
- PARENTS_CODE — varchar(40)
- CODE_NAME — varchar(50) — NOT NULL
- CODE_DESC — varchar(100)
- SORT_ORDER — int(11)
- ATTRIBUTE1 — varchar(30)
- ATTRIBUTE2 — varchar(30)
- ATTRIBUTE3 — varchar(30)
- ATTRIBUTE4 — varchar(30)
- ATTRIBUTE5 — varchar(30)
- ATTRIBUTE6 — varchar(30)
- ATTRIBUTE7 — varchar(30)
- ATTRIBUTE8 — varchar(30)
- ATTRIBUTE9 — varchar(30)
- ATTRIBUTE10 — varchar(30)
- LAST_CHANGED_DATE — datetime — NOT NULL
- LAST_CHANGED_USER_ID — int(11) — NOT NULL
- ENABLE — varchar(1) — NOT NULL
TB_DAQ_HIST
- SUBJECT_ID — int(11) — Primary key — NOT NULL
- MEASURE_COUNT — int(11) — Primary key — NOT NULL
- SENSOR_LOCATION — int(11) — Primary key — NOT NULL
- SEQUENCE — int(11) — Primary key — NOT NULL
- TRANSACTION_SERIAL_NO — varchar(40) — Primary key — NOT NULL
- INSPECTOR_ID — int(11) — Primary key — NOT NULL
- TRANSACTION_CODE — varchar(1) — NOT NULL
- TRANSACTION_DATE — datetime — NOT NULL
- TRANSACTION_USER_ID — int(11) — NOT NULL
- ACCELERATION_X — int(11) — NOT NULL
- ACCELERATION_Y — int(11) — NOT NULL
- ACCELERATION_Z — int(11) — NOT NULL
- GYRO_X — int(11) — NOT NULL
- GYRO_Y — int(11) — NOT NULL
- GYRO_Z — int(11) — NOT NULL
TB_DAQ_INFO
- SUBJECT_ID — int(11) — Primary key — NOT NULL
- MEASURE_COUNT — int(11) — Primary key — NOT NULL
- SENSOR_LOCATION — int(11) — Primary key — NOT NULL
- SEQUENCE — int(11) — Primary key — NOT NULL
- INSPECTOR_ID — int(11) — Primary key — NOT NULL
- ACCELERATION_X — decimal(10,4) — NOT NULL
- ACCELERATION_Y — decimal(10,4) — NOT NULL
- ACCELERATION_Z — decimal(10,4) — NOT NULL
- GYRO_X — decimal(10,4) — NOT NULL
- GYRO_Y — decimal(10,4) — NOT NULL
- GYRO_Z — decimal(10,4) — NOT NULL
- LAST_TRANSACTION_SERIAL_NO — varchar(40) — NOT NULL
- LAST_TRANSACTION_CODE — varchar(1) — NOT NULL
- LAST_TRANSACTION_DATE — datetime — NOT NULL
- LAST_TRANSACTION_USER_ID — int(11) — NOT NULL
TB_EXCEPTION_CODE_MST
- EXCEPTION_CODE — varchar(50) — Primary key — NOT NULL
- EXCEPTION_CAUSE_LOCATION — varchar(20) — NOT NULL
- EXCEPTION_LEVEL — varchar(10) — NOT NULL
- EXCEPTION_DESC — varchar(100) — NOT NULL
- EXCEPTION_MESSAGE — varchar(100) — NOT NULL
- LAST_CHANGED_DATE — datetime — NOT NULL
- LAST_CHANGED_USER_ID — int(11) — NOT NULL
- ENABLE — varchar(1) — NOT NULL
TB_EXCEPTION_HIST
- EXCEPTION_ID — int(11) — Primary key — NOT NULL
- EXCEPTION_CODE — varchar(50) — NOT NULL
- EXCEPTION_CAUSE_LOCATION — varchar(20) — NOT NULL
- EXCEPTION_LEVEL — varchar(10) — NOT NULL
- STACK_TRACE — text — NOT NULL
- ACCESS_IP — varchar(50) — NOT NULL
- CAUSE_TIME — datetime — NOT NULL
- CAUSE_USER_ID — int(11) — NOT NULL
TB_GAIT_CYCLE_INFO
- SUBJECT_ID — int(11) — Primary key — NOT NULL
- INSPECTOR_ID — int(11) — Primary key — NOT NULL
- MEASURE_COUNT — int(11) — Primary key — NOT NULL
- LEFT_Cycle — int(10)
- RIGHT_Cycle — int(10)
- LEFT_Ax — text
- LEFT_Ay — text
- LEFT_Az — text
- LEFT_Gx — text
- LEFT_Gy — text
- LEFT_Gz — text
- RIGHT_Ax — text
- RIGHT_Ay — text
- RIGHT_Az — text
- RIGHT_Gx — text
- RIGHT_Gy — text
- RIGHT_Gz — text
- LAST_TRANSACTION_SERIAL_NO — varchar(40)
- LAST_TRANSACTION_CODE — varchar(1)
- LAST_TRANSACTION_DATE — datetime
- LAST_TRANSACTION_USER_ID — int(11)
TB_INSPECTOR_MST
- USER_ID — int(11) — Primary key — NOT NULL
- CENTER_ID — varchar(24) — NOT NULL
- DEPARTMENT_ID — varchar(20) — NOT NULL
- EMAIL — varchar(40)
- LAST_CHANGED_DATE — datetime — NOT NULL
- LAST_CHANGED_USER_ID — int(11) — NOT NULL
TB_INSPECTOR_SUBJECT_MAP
- INSPECTOR_ID — int(11) — Primary key — NOT NULL
- SUBJECT_ID — int(11) — Primary key — NOT NULL
- LAST_CHANGED_DATE — datetime — NOT NULL
- LAST_CHANGED_USER_ID — int(11) — NOT NULL
- ENABLE — varchar(1) — NOT NULL
TB_MEASURE_HIST
- SUBJECT_ID — int(11) — Primary key — NOT NULL
- MEASURE_COUNT — int(11) — Primary key — NOT NULL
- TRANSACTION_SERIAL_NO — varchar(40) — Primary key — NOT NULL
- INSPECTOR_ID — int(11) — Primary key — NOT NULL
- ANAL_STATUS_CODE — varchar(2) — NOT NULL
- STAT_STATUS_CODE — varchar(2)
- ANAL_VERSION — varchar(6)
- TRANSACTION_CODE — varchar(1) — NOT NULL
- TRANSACTION_DATE — datetime — NOT NULL
- TRANSACTION_USER_ID — int(11) — NOT NULL
- MEASURE_TYPE — varchar(2) — NOT NULL
- GORT_TYPE — varchar(1) — NOT NULL
- WALKING_SPEED — decimal(4,2)
- WALKING_DISTANCE — decimal(4,2)
- MEASURE_TIME — int(11) — NOT NULL
TB_MEASURE_INFO
- SUBJECT_ID — int(11) — Primary key — NOT NULL
- INSPECTOR_ID — int(11) — Primary key — NOT NULL
- MEASURE_COUNT — int(11) — Primary key — NOT NULL
- ANAL_STATUS_CODE — varchar(2) — NOT NULL
- STAT_STATUS_CODE — varchar(2)
- ANAL_VERSION — varchar(6)
- MEASURE_TYPE — varchar(5) — NOT NULL
- PRODUCT_NAME — varchar(30)
- GORT_TYPE — varchar(1) — NOT NULL
- INSPECT_TYPE — varchar(10)
- PREFERRED_SPEED — decimal(4,2)
- WALKING_SPEED — decimal(4,2)
- WALKING_DISTANCE — decimal(4,2)
- SNF — varchar(1)
- SNF_PACK_NUM — int(11) — NOT NULL
- REPORT_SETS — varchar(1) — NOT NULL
- CHART_CODE — varchar(3)
- MEASURE_TIME — int(11) — NOT NULL
- LAST_TRANSACTION_SERIAL_NO — varchar(40) — NOT NULL
- LAST_TRANSACTION_CODE — varchar(1) — NOT NULL
- LAST_TRANSACTION_DATE — datetime — NOT NULL
- LAST_TRANSACTION_USER_ID — int(11) — NOT NULL
TB_MEASURE_INFO_TEST
- id — int(11) — Primary key — NOT NULL
- code — int(11) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime
TB_MOCO_MEASURE_HIST
- MEASURE_ID — int(11) — NOT NULL
- SUBJECT_ID — int(11) — NOT NULL
- INSPECTOR_ID — int(11) — NOT NULL
- MEASURE_COUNT — int(11) — NOT NULL
- SUBJECT_GENDER — varchar(1) — NOT NULL
- SUBJECT_HEIGHT — decimal(4,1) — NOT NULL
- SUBJECT_WEIGHT — decimal(4,1) — NOT NULL
- MEASURE_TYPE — varchar(10)
- INSPECT_TYPE — varchar(10) — NOT NULL
- VIEW_DIRECTION — varchar(10)
- VIEW_PITCH_ANGLE — int(3) — NOT NULL
- VIEW_YAW_ANGLE — int(3) — NOT NULL
- LINKS_LENGTH — longtext — NOT NULL
- DIST_Z — longtext
- LAST_TRANSACTION_DATE — datetime — NOT NULL
- LAST_TRANSACTION_USER_ID — int(11) — NOT NULL
TB_MOCO_MEASURE_INFO
- MEASURE_ID — int(20) — NOT NULL
- ANAL_VERSION — varchar(6)
- PROC_PEAK_TIME — longtext
- PROC_PEAK — longtext
- STEP_LENGTH — decimal(8,4)
- GAIT_VELOCITY — decimal(8,4)
- SAG_HIP_LEFT — longtext
- SAG_KNEE_LEFT — longtext
- SAG_ANKLE_LEFT — longtext
- SAG_HIP_RIGHT — longtext
- SAG_KNEE_RIGHT — longtext
- SAG_ANKLE_RIGHT — longtext
- SAG_SHOULDER_LEFT — longtext
- SAG_ELBOW_LEFT — longtext
- SAG_SHOULDER_RIGHT — longtext
- SAG_ELBOW_RIGHT — longtext
- SAG_TORSO — longtext
- SAG_HEAD — longtext
- COR_HIP_LEFT — longtext
- COR_ANKLE_LEFT — longtext
- COR_HIP_RIGHT — longtext
- COR_ANKLE_RIGHT — longtext
- COR_SHOULDER_LEFT — longtext
- COR_SHOULDER_RIGHT — longtext
- COR_TORSO — longtext
- TRAN_HIP_LEFT — longtext
- TRAN_HIP_RIGHT — longtext
- TRAN_TORSO — longtext
- TRAN_HEAD — longtext
- EST_FOOT_DIST_X — longtext
- LAST_TRANSACTION_DATE — datetime — NOT NULL
- LAST_TRANSACTION_USER_ID — int(11) — NOT NULL
TB_OPERATION_HIST
- OPERATION_ID — int(11) — Primary key — NOT NULL
- USER_ID — int(11) — NOT NULL
- USER_NAME — varchar(20) — NOT NULL
- OPERATION_NAME — varchar(30) — NOT NULL
- OPERATION_TIME — datetime — NOT NULL
- OPERATION_RESULT — varchar(15) — NOT NULL
TB_PRODUCT_MST
- PRODUCT_ID — int(11) — Primary key — NOT NULL
- PRODUCT_TYPE — varchar(20) — NOT NULL
- CENTER_ID — varchar(48) — NOT NULL
- PRODUCT_NAME — varchar(30) — NOT NULL
- PRODUCT_DESC — varchar(40) — NOT NULL
- MEASURE_TYPE — varchar(5) — NOT NULL
- CREATED_DATE — date — NOT NULL
- LAST_CHANGED_DATE — datetime — NOT NULL
- LAST_CHANGED_USER_ID — int(11) — NOT NULL
- ENABLE — varchar(1) — NOT NULL
TB_REPORT_MST
- REPORT_ID — varchar(40) — Primary key — NOT NULL
- REPORT_URL — varchar(100) — NOT NULL
- REPORT_TITLE — varchar(40) — NOT NULL
- REPORT_DESC — varchar(100) — NOT NULL
- REPORT_COLOR — varchar(10)
- INSPECT_TYPE — varchar(10) — NOT NULL
- MEASURE_TYPE — varchar(20) — NOT NULL
- REPORT_SETS — varchar(1) — NOT NULL
- LAST_CHANGED_DATE — datetime — NOT NULL
- LAST_CHANGED_USER_ID — int(11) — NOT NULL
- ENABLE — varchar(1) — NOT NULL
TB_ROLE_ACTION_MAP
- ROLE_ID — varchar(50) — Primary key — NOT NULL
- ACTION_ID — varchar(50) — Primary key — NOT NULL
- LAST_CHANGED_DATE — datetime — NOT NULL
- LAST_CHANGED_USER_ID — int(11) — NOT NULL
- ENABLE — varchar(1) — NOT NULL
TB_ROLE_MST
- ROLE_ID — varchar(20) — Primary key — NOT NULL
- ROLE_NAME — varchar(20) — NOT NULL
- ROLE_DESC — varchar(30) — NOT NULL
- ROLE_URL_PREFIX — varchar(20) — NOT NULL
- LAST_CHANGED_DATE — datetime — NOT NULL
- LAST_CHANGED_USER_ID — int(11) — NOT NULL
- ENABLE — varchar(1) — NOT NULL
TB_SENSOR_MST
- SENSOR_ADDRESS — varchar(20) — Primary key — NOT NULL
- PRODUCT_ID — int(11) — NOT NULL
- SENSOR_DESC — varchar(20) — NOT NULL
- SENSOR_LOCATION — int(11) — NOT NULL
- LAST_CHANGED_DATE — datetime — NOT NULL
- LAST_CHANGED_USER_ID — int(11) — NOT NULL
TB_SUBJECT_MST
- USER_ID — int(11) — Primary key — NOT NULL
- SHOES_SIZE — int(11) — NOT NULL
- SEX — varchar(1) — NOT NULL
- BIRTH_DATE — date — NOT NULL
- HEIGHT — decimal(4,1) — NOT NULL
- WEIGHT — decimal(4,1) — NOT NULL
- TEAM — varchar(20)
- EVENT — varchar(20)
- ETC_COMMENT — varchar(200)
- LAST_CHANGED_DATE — datetime — NOT NULL
- LAST_CHANGED_USER_ID — int(11) — NOT NULL
TB_UNIQUE_CONDITION
- Unique — Condition`
- 건강_L95 — double
- 건강_AVG — double
- 건강_U95 — double
- 보통_L95 — double
- 보통_AVG — double
- 보통_U95 — double
- 심각_L95 — double
- 심각_AVG — double
- 심각_U95 — double
- PD_L95 — double
- PD_AVG — double
- PD_U95 — double
TB_USER_AUTH_MST
- USER_ID — bigint(20) — Primary key — NOT NULL
- AUTH_TYPE — varchar(20) — NOT NULL
- ID — varchar(24)
- PASSWORD — varchar(128)
- AUTH_TOKEN — varchar(200)
- LAST_CHANGED_DATE — datetime — NOT NULL
- LAST_CHANGED_USER_ID — int(11) — NOT NULL
TB_USER_MST
- USER_ID — bigint(20) — Primary key — NOT NULL
- ROLE_ID — varchar(20) — Foreign key → TB_ROLE_MST.ROLE_ID — NOT NULL
- USER_NAME — varchar(20) — NOT NULL
- MOBILE_NO — varchar(20) — NOT NULL
- id_number — varchar(20) — NOT NULL
- birth_date — varbinary(255) — NOT NULL
- agree — varchar(1) — NOT NULL
- created_at — datetime — NOT NULL
- LAST_CHANGED_DATE — datetime — NOT NULL
- LAST_CHANGED_USER_ID — bigint(20) — NOT NULL
- ENABLE — varchar(1) — NOT NULL
report_irp
- subject_id — int(11) — Primary key — NOT NULL
- inspector_id — int(11) — Primary key — NOT NULL
- measure_count — int(11) — Primary key — NOT NULL
- IR_LAnkle_chronic_avg — decimal(4,1)
- IR_RAnkle_chronic_avg — decimal(4,1)
- IR_LAnkle_acute_avg — decimal(4,1)
- IR_RAnkle_acute_avg — decimal(4,1)
- IR_LKnee_chronic_avg — decimal(4,1)
- IR_RKnee_chronic_avg — decimal(4,1)
- IR_LKnee_acute_avg — decimal(4,1)
- IR_RKnee_acute_avg — decimal(4,1)
- IR_LHip_chronic_avg — decimal(4,1)
- IR_RHip_chronic_avg — decimal(4,1)
- IR_LHip_acute_avg — decimal(4,1)
- IR_RHip_acute_avg — decimal(4,1)
- total_acute_avg — decimal(4,1)
- BODY_MUSCLE_SCORE_avg — decimal(4,1)
- BODY_JOINT_SCORE_avg — decimal(4,1)
- BODY_NEURO_SCORE_avg — decimal(4,1)
- speed_avg — decimal(3,1)
- normalized_stride_length_avg — decimal(4,2)
- gait_asymmetry_avg — decimal(5,2)
- cadence_avg — int(3)
- phase_coordination_index_avg — decimal(6,2)
- time_of_toe_off_left_avg — decimal(5,2)
- time_of_toe_off_right_avg — decimal(5,2)
- LAST_TRANSACTION_DATE — datetime
report_ref
- subject_id — int(11) — Primary key — NOT NULL
- inspector_id — int(11) — Primary key — NOT NULL
- measure_count — int(11) — Primary key — NOT NULL
- bmi_grade — int(11)
- cardiovascular_grade_readjust — decimal(8,1)
- flex_grade_readjust — decimal(8,1)
- muscle_strength_grade_readjust — decimal(8,1)
- muscular_grade_readjust — decimal(8,1)
- power_grade_readjust — decimal(8,1)
- MCFitIndex_BrainL_readjust — int(11)
- MCFitIndex_DiscL_readjust — int(11)
- last_transaction_date — datetime
- MEASURE_COUNT — FOREIGN
- MEASURE_COUNT) — ON
report_rtb
- subject_id — int(11) — Primary key — NOT NULL
- inspector_id — int(11) — Primary key — NOT NULL
- measure_count — int(11) — Primary key — NOT NULL
- r_score_avg — decimal(3,1)
- t_score_avg — decimal(3,1)
- b_score_avg — decimal(3,1)
- pd_index_avg — decimal(3,1)
- LAST_TRANSACTION_DATE — datetime
report_tug
- subject_id — int(11) — Primary key — NOT NULL
- inspector_id — int(11) — Primary key — NOT NULL
- measure_count — int(11) — Primary key — NOT NULL
- cadence_avg — int(3)
- speed_avg — decimal(4,2)
- LAST_TRANSACTION_DATE — datetime