exbody-design

Tables (41)

AdminOptionBiztype

  • Id — INTEGER — Primary key — NOT NULL
  • Designer_Description — TEXT
  • Name — TEXT
  • Client_Name — INTEGER
  • Client_Birth — INTEGER
  • Client_Phone — INTEGER
  • Client_Gender — INTEGER
  • Client_Age — INTEGER
  • Client_Height — INTEGER
  • Client_Weight — INTEGER
  • Client_Num — INTEGER
  • Client_Manager — INTEGER
  • Client_Department — INTEGER
  • Client_Department_Second_1 — INTEGER
  • Client_Department_Second_2 — INTEGER
  • Client_Department_Second_3 — INTEGER
  • Client_Num_Second_1 — INTEGER
  • Client_Pain_Survey — INTEGER
  • Client_Email — INTEGER
  • Client_Select_Option_M_1 — INTEGER
  • Client_Select_Option_M_1_Sub — TEXT
  • Login_BG_Img — TEXT
  • Excel_Member_Import — INTEGER
  • Excel_Member_Export — INTEGER
  • Excel_Analysis_Export — INTEGER
  • Excel_ROM_Export — INTEGER
  • Setting_SurveyExportAsExcel — INTEGER

AdminOptionModeltype

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Name — TEXT
  • Default_Selected — TEXT
  • MetaGym_Selected — TEXT
  • Sort_Number — INTEGER

AnalysisExpertReport

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Title — TEXT
  • Sort — INTEGER
  • Legend_Stress — TEXT
  • Legend_Prescription — TEXT
  • Common_Text — TEXT
  • Content_Name — TEXT
  • Abbreviation — TEXT
  • Content_Image — TEXT
  • Content_Description_1_Title — TEXT
  • Content_Description_1 — TEXT
  • Content_Description_2_Title — TEXT
  • Content_Description_2 — TEXT
  • Content_Description_3_Title — TEXT
  • Content_Description_3 — TEXT

CityList

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Country_Name — TEXT
  • Country_Key — INTEGER
  • City_Name — TEXT
  • City_Key — INTEGER

ComparisonCommand

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Name_String_Key — TEXT
  • Show — INTEGER
  • Category — INTEGER
  • Format — INTEGER
  • Inspection — TEXT — Foreign key → InspectionTotalList.Id

DescriptItem

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Name_String_Key — TEXT
  • Character_Show — INTEGER
  • Character_Type — INTEGER
  • Character_Ani_Type — INTEGER
  • Character_Control — INTEGER
  • Muscle_Button_Show — INTEGER
  • Muscle_Blue — TEXT
  • Muscle_Red — TEXT
  • Descript_Pop_Show — INTEGER
  • Abbreviation — TEXT
  • Pop_Title_String_Key — TEXT
  • Pop_Symptom_String_Key — TEXT
  • Pop_Description_String_Key — TEXT
  • Pop_Description_Pro_String_Key — TEXT
  • Exercise_Movie — TEXT — Foreign key → ExerciseMovie.Id

DivisionData

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Name — TEXT
  • Sort_Number — INTEGER
  • App_Name — TEXT

Etc

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Value — TEXT

ExerciseMovie

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Folder_Name — TEXT
  • Movie_File — TEXT
  • Name — TEXT
  • Body_Part — INTEGER
  • Time_Value — INTEGER
  • Movie_Url — TEXT
  • Image — TEXT
  • Difficulty_String — TEXT
  • Time_String — TEXT
  • Tools_String — TEXT
  • ExerciseArea_String — TEXT
  • Image_Url — TEXT

GoalfitCommand

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Exercise_Abbreviation — TEXT
  • Category — INTEGER
  • Name_String_Key — TEXT
  • Main_Image_Atlas — TEXT
  • IMG — TEXT
  • Description_String_Key — TEXT
  • Shoot_Type — INTEGER
  • Guide_Animation_Key — TEXT
  • Guide_Animation — TEXT
  • Exercise_Count — INTEGER
  • Recording_Ready_MSG — TEXT
  • Recording_Counting_MSG — TEXT
  • View_Type — INTEGER
  • View_Joints_Show — INTEGER
  • View_Type_Text — TEXT
  • Report_Animation — TEXT
  • Muscle_Orange_Name — TEXT
  • Muscle_Red_Name — TEXT
  • Line_Mode_Direction — TEXT
  • Line_Mode_Joints — TEXT
  • Report_Skeleton_String_Key — TEXT
  • Report_Graph1_String_Key — TEXT
  • Report_Graph2_String_Key — TEXT
  • Report_Graph3_String_Key — TEXT
  • Line_Mode_Joint — TEXT
  • Line_Mode_Joint_Line — TEXT
  • Total_ID — TEXT — Foreign key → InspectionTotalList.Id
  • Descript — TEXT — Foreign key → GoalfitDescript.Id

GoalfitConditions

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Check_Rotation_Type — TEXT
  • Check_Joint_Type — TEXT
  • Check_Joint — TEXT
  • Graph_Count — INTEGER
  • Graph_Type — TEXT
  • Graph_Abbreviation — TEXT
  • Target_Joint_Angle — TEXT
  • Target_Joint_Result — TEXT
  • Angle_Type — TEXT
  • Base_Angle — TEXT
  • Default_Angle — TEXT
  • BaseLine_Time — TEXT
  • Result_Rule — TEXT
  • Operator — TEXT
  • Int_Value — TEXT
  • Result_Bool — TEXT
  • Color_Joints — TEXT
  • Result_Color — TEXT
  • Recieve_Condition — TEXT
  • Line_Angle_Location — TEXT
  • Option_Camera_Rotate — INTEGER
  • Exercise_Abbreviation — TEXT — Foreign key → InspectionTotalList.Id

GoalfitDescript

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Results — TEXT
  • Symptomps_Key — TEXT
  • ArraySelection — INTEGER
  • Skeleton_Muscle_Group — TEXT
  • Muscle_Red — TEXT
  • Muscle_Orange — TEXT
  • Abbreviation — TEXT
  • Results_String_Key — TEXT

GoalfitInspectionAngle

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • AngleJoint — TEXT
  • NearbyJoint — TEXT
  • Clockwise — TEXT
  • Scale — TEXT
  • Value_Coordinate — TEXT
  • Scene — TEXT
  • Total_ID — TEXT — Foreign key → InspectionTotalList.Id

GoalfitResultsConditions

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Exercise_Joint — INTEGER
  • Directions — INTEGER
  • Results — INTEGER
  • Operator — INTEGER
  • Absolute — INTEGER
  • Receive_Bool — INTEGER
  • Int_Value — INTEGER
  • Result_Bool — INTEGER
  • Result_Level — INTEGER
  • Recieve_Condition — INTEGER
  • Exercise_Abbreviation — TEXT

GoalfitSymptoms

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Name_String_Key — TEXT
  • Image — TEXT
  • Report_String_Key — TEXT

InspectionFilmingJoint

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Show_Joint — TEXT
  • Show_Joint_Line — TEXT
  • Joint_Line_Length — TEXT
  • Joint_Line_Direction — TEXT
  • LineMode_Joint — TEXT
  • LineMode_JointLine — TEXT
  • LineMode_Thickness — TEXT
  • Id_In_Table — INTEGER — Foreign key → InspectionItem.Id

InspectionItem

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Division — INTEGER
  • Name_String_Key — TEXT
  • Description_String_Key — TEXT
  • Main_Image_Atlas — TEXT
  • Main_Image — TEXT
  • Guide_Image_Atlas — TEXT
  • Guide_Image — TEXT
  • Guide_msg — TEXT
  • Shoot_Type — INTEGER
  • Descript_Button_Show — INTEGER
  • Condition_Table_Name — TEXT
  • Performance_Table_Name — TEXT
  • Performance_Id — TEXT
  • Report_Muscle_Img — TEXT
  • Condition_Id — TEXT — Foreign key → RomConditions.Id
  • Descript_Item_1 — TEXT — Foreign key → DescriptItem.Id
  • Descript_Item_2 — TEXT — Foreign key → DescriptItem.Id
  • Descript_Item_3 — TEXT — Foreign key → DescriptItem.Id
  • Descript_Item_4 — TEXT — Foreign key → DescriptItem.Id
  • Descript_Item_5 — TEXT — Foreign key → DescriptItem.Id

InspectionTotalList

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Table_Name — TEXT
  • Visibility — INTEGER
  • Sort_Number — INTEGER
  • Id_In_Table — INTEGER — Foreign key → InspectionItem.Id
  • Division — INTEGER — Foreign key → DivisionData.Id

JointAbb

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • ANALYSIS_F — TEXT
  • ANALYSIS_S — TEXT
  • ANALYSIS_B — TEXT
  • ROM_F — TEXT
  • ROM_S — TEXT
  • ROM_B — TEXT

MovementRecommended

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Name_String_Key — TEXT
  • Description_String_Key — TEXT

MovementSquatDescript

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Name — TEXT
  • Manual_Button_Bool — INTEGER
  • Results_Int_Value — INTEGER
  • GoalfitDescript_ArraySelection — INTEGER
  • Inspection_ID — INTEGER — Foreign key → InspectionTotalList.Id
  • GoalfitResultsConditions_Id — INTEGER — Foreign key → GoalfitResultsConditions.Id

MovementSquatReport

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Exercise_Abbreviation — TEXT
  • SubPage_String — TEXT
  • Muscle_Orange_Name — TEXT
  • Muscle_Red_Name — TEXT
  • Graph_Type — TEXT
  • Graph_Label_String — TEXT
  • Graph_Name_String — TEXT
  • Graph — TEXT
  • Symptomps_Title — TEXT
  • Symptomps_Id — TEXT
  • MovementRecommend_Title — TEXT
  • Details_Muscle_String — TEXT
  • Details_Muscle_Result_String — TEXT
  • Details_Muscle_Image — TEXT
  • Details_Muscle_Red_Title — TEXT
  • Details_Muscle_Red_String — TEXT
  • Details_Muscle_Blue_Title — TEXT
  • Details_Muscle_Blue_String — TEXT
  • Details_Muscle_Normal_String — TEXT
  • Details_Statement_Image_Name — TEXT
  • Details_Symptom_Image — TEXT
  • Details_Symptom_Title — TEXT
  • Details_Symptom_Result — TEXT
  • Details_Symptom_Description — TEXT
  • MovementRecommend_Id — TEXT — Foreign key → MovementRecommended.Id

MuscleDetail

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Muscle — TEXT
  • Name — TEXT
  • Maya_Outliner_Name — TEXT

OptionToolDefault

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Option_Value — TEXT

PostureConditions

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • View_Type — INTEGER
  • Type — INTEGER
  • Axis — INTEGER
  • Base_Joint — TEXT
  • Target_Joint — TEXT
  • Value_Type — INTEGER
  • Option_Camera_Rotate — INTEGER

PosturePerformance

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Character_View_Type — INTEGER
  • Line_1 — TEXT
  • Line_Color_1 — TEXT
  • Expansion_1 — INTEGER
  • Line_2 — TEXT
  • Line_Color_2 — TEXT
  • Expansion_2 — INTEGER
  • Line_3 — TEXT
  • Line_Color_3 — TEXT
  • Expansion_3 — INTEGER
  • Line_4 — TEXT
  • Line_Color_4 — TEXT
  • Expansion_4 — INTEGER
  • Line_5 — TEXT
  • Line_Color_5 — TEXT
  • Expansion_5 — INTEGER
  • Line_6 — TEXT
  • Line_Color_6 — TEXT
  • Expansion_6 — INTEGER
  • Line_7 — TEXT
  • Line_Color_7 — TEXT
  • Expansion_7 — INTEGER
  • Line_8 — TEXT
  • Line_Color_8 — TEXT
  • Expansion_8 — INTEGER
  • Line_9 — TEXT
  • Line_Color_9 — TEXT
  • Expansion_9 — INTEGER
  • Line_10 — TEXT
  • Line_Color_10 — TEXT
  • Expansion_10 — INTEGER
  • Base_Joint — TEXT

PresetDefault

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Default_Preset_Id — TEXT
  • Division — INTEGER — Foreign key → DivisionData.Id

ROMItems

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Joint — INTEGER
  • InspectionItem_Id — TEXT — Foreign key → InspectionItem.Id

ReferenceCommand

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Category_Name — TEXT
  • Typical_Symptom_Title — TEXT
  • Typical_Symptom — TEXT
  • Relavent_Symptom_Title — TEXT
  • Relavent_Symptom_Category — TEXT
  • Relavent_Symptom — TEXT
  • Division — INTEGER — Foreign key → DivisionData.Id

ReferenceSymptoms

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Symptom_Name — TEXT
  • Description — TEXT
  • Label — TEXT
  • Image — TEXT

ReportBalance

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Description_String — TEXT

ReportCategory

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Division_Id — TEXT
  • Category_String — TEXT
  • Report_Id — TEXT — Foreign key → ReportList.Id

ReportCriteria

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Inspection — INTEGER
  • Criteria_Operator — TEXT
  • Criteria — TEXT
  • Description_String — TEXT
  • Results_String — TEXT

ReportImage

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Details_Symptom_Image — TEXT
  • String — TEXT

ReportList

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Category_String — TEXT
  • Inspection_Id — TEXT — Foreign key → InspectionTotalList.Id

ReportMuscle

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Condition_String — TEXT
  • Muscle_String — TEXT
  • Blue_Back_Img — TEXT
  • Blue_Front_Img — TEXT
  • Red_Back_Img — TEXT
  • Red_Front_Img — TEXT
  • Abbreviation — TEXT — Foreign key → InspectionTotalList.Id

ReportStatement

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Description_String — TEXT
  • Image — TEXT
  • Abbreviation — TEXT — Foreign key → InspectionTotalList.Id

RomConditions

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • View_Type — INTEGER
  • Axis — INTEGER
  • Axis_Ref — INTEGER
  • Joint_Static — INTEGER
  • Joint_1 — TEXT
  • Joint_2 — TEXT
  • Joint_3 — TEXT
  • Direction_Type — INTEGER
  • Normal_Start_Angle — INTEGER
  • Normal_Angle — TEXT
  • Angle_Type — INTEGER
  • Anime_Side — INTEGER
  • Option_Camera_Rotate — INTEGER
  • Normal_Direction — INTEGER
  • ROM_BodyPose — INTEGER

ServerErrCode

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Code_Num — INTEGER
  • String_Key — TEXT

Sound

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT

StringTable

  • Id — INTEGER — Primary key
  • Designer_Description — TEXT
  • Korean — TEXT
  • English — TEXT
  • Chinese — TEXT
  • Japanese — TEXT
  • Sub_Key — INTEGER — Foreign key → AdminOptionBiztype.Id — NOT NULL