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