energyboostlab

테이블 (34)

account_emailaddress

  • id — int(11) — 기본 키 — NOT NULL
  • email — varchar(254) — NOT NULL
  • verified — tinyint(1) — NOT NULL
  • primary — tinyint(1) — NOT NULL
  • user_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL

account_emailconfirmation

  • id — int(11) — 기본 키 — NOT NULL
  • created — datetime(6) — NOT NULL
  • sent — datetime(6)
  • key — varchar(64) — NOT NULL
  • email_address_id — int(11) — 외래 키 → account_emailaddress.id — NOT NULL

auth_group

  • id — int(11) — 기본 키 — NOT NULL
  • name — varchar(150) — NOT NULL

auth_group_permissions

  • id — bigint(20) — 기본 키 — NOT NULL
  • group_id — int(11) — 외래 키 → auth_group.id — NOT NULL
  • permission_id — int(11) — 외래 키 → auth_permission.id — NOT NULL

auth_permission

  • id — int(11) — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • content_type_id — int(11) — NOT NULL
  • codename — varchar(100) — NOT NULL

authtoken_token

  • key — varchar(40) — 기본 키 — NOT NULL
  • created — datetime(6) — NOT NULL
  • user_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL

body_bodyanalysis(신체분석정보) (body_bodyanalysis)

  • id — bigint(20) — 기본 키 — NOT NULL
  • update_date — datetime(6) — NOT NULL
  • create_date — datetime(6) — NOT NULL
  • total_score — int(11)
  • body_type — varchar(50)
  • weight_evaluation — varchar(50)
  • fat_evaluation — varchar(50)
  • fat_rate_analysis_upper_horizontal — varchar(50)
  • fat_rate_analysis_lower_horizontal — varchar(50)
  • fat_rate_analysis_vertical — varchar(50)
  • recode_date — datetime(6)
  • body_detail_id — bigint(20) — 외래 키 → body_bodydetail(체성분).id — NOT NULL
  • body_info_id — bigint(20) — 외래 키 → body_bodyinfo(신체기본정보).id — NOT NULL
  • user_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL

body_bodydetail(체성분) (body_bodydetail)

  • id — bigint(20) — 기본 키 — NOT NULL
  • update_date — datetime(6) — NOT NULL
  • create_date — datetime(6) — NOT NULL
  • total_body_water — double
  • protein — double
  • minerals — double
  • body_fat_mass — double
  • weight — double
  • skeletal_muscle_mass — double
  • body_mass_index — double
  • percent_body_fat — double
  • muscle_top_left — double
  • muscle_top_right — double
  • muscle_center — double
  • muscle_bottom_left — double
  • muscle_bottom_right — double
  • fat_top_left — double
  • fat_top_right — double
  • fat_center — double
  • fat_bottom_left — double
  • fat_bottom_right — double
  • waist_hip_ratio — double
  • visceral_fat_level — double
  • basal_metabolic_rate — double
  • recode_date — datetime(6)
  • body_info_id — bigint(20) — 외래 키 → body_bodyinfo(신체기본정보).id — NOT NULL
  • user_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL

body_bodygoal(신체목표) (body_bodygoal)

  • id — bigint(20) — 기본 키 — NOT NULL
  • update_date — datetime(6) — NOT NULL
  • create_date — datetime(6) — NOT NULL
  • name — varchar(50)
  • status — tinyint(1)
  • target_weight — double
  • target_body_fat_mass — double
  • target_skeletal_muscle_mass — double
  • target_start_date — datetime(6)
  • target_finish_date — datetime(6)
  • user_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL

body_bodyinfo(신체기본정보) (body_bodyinfo)

  • id — bigint(20) — 기본 키 — NOT NULL
  • update_date — datetime(6) — NOT NULL
  • create_date — datetime(6) — NOT NULL
  • gender — varchar(50) — NOT NULL
  • height — double — NOT NULL
  • date_of_birth — date — NOT NULL
  • recode_date — datetime(6)
  • user_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL

users_user_user_permissions

  • id — bigint(20) — 기본 키 — NOT NULL
  • user_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL
  • permission_id — int(11) — 외래 키 → auth_permission.id — NOT NULL

사용자 (users_user)

  • id — bigint(20) — 기본 키 — NOT NULL
  • password — varchar(128) — NOT NULL
  • email — varchar(30) — NOT NULL
  • name — varchar(50) — NOT NULL
  • mobile — varchar(50) — NOT NULL
  • date_of_birth — date
  • gender — varchar(50)
  • is_active — tinyint(1) — NOT NULL
  • is_staff — tinyint(1) — NOT NULL
  • is_admin — tinyint(1) — NOT NULL
  • is_superuser — tinyint(1) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • last_login — datetime(6) — NOT NULL

사용자-그룹 (users_user_groups)

  • id — bigint(20) — 기본 키 — NOT NULL
  • user_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL
  • group_id — int(11) — 외래 키 → auth_group.id — NOT NULL

스포츠 (workout_sports)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • name — varchar(100) — NOT NULL
  • category — varchar(100)
  • user_id — bigint(20) — 외래 키 → 사용자.id

식단기록 (nutrition_foodactivity)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • activity_type — varchar(50) — NOT NULL
  • memo — varchar(50)
  • category — varchar(50)
  • serving_size — double
  • calorie — double
  • status — tinyint(1)
  • start_date — datetime(6)
  • finish_date — datetime(6)
  • course_type — varchar(50) — NOT NULL
  • total_carbohydrate — double
  • protein — double
  • total_fat — double
  • total_vitamin — double
  • dietary_fiber — double
  • sugar — double
  • sodium — double
  • saturated_fatty_acids — double
  • trans_fatty_acid — double
  • vitamin_a — double
  • vitamin_b6 — double
  • vitamin_b12 — double
  • vitamin_c — double
  • vitamin_d — double
  • vitamin_e — double
  • vitamin_k — double
  • minerals — double
  • calcium — double
  • iron — double
  • phosphorus — double
  • potassium — double
  • retinol — double
  • cholesterol — double
  • folate — double
  • magnesium — double
  • zinc — double
  • selenium — double
  • user_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL

식단기록-음식 (nutrition_foodactivityfood)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • food_id — bigint(20) — 외래 키 → 음식.id — NOT NULL
  • food_activity_id — bigint(20) — 외래 키 → 식단기록.id — NOT NULL

식단기록-음식코스 (nutrition_foodactivityfoodcourse)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • food_activity_id — bigint(20) — 외래 키 → 식단기록.id — NOT NULL
  • food_course_id — bigint(20) — 외래 키 → 음식코스.id — NOT NULL

식단기록-재료 (nutrition_foodactivityingredient)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • food_activity_id — bigint(20) — 외래 키 → 식단기록.id — NOT NULL
  • ingredient_id — bigint(20) — 외래 키 → 재료.id — NOT NULL

식단목표 (nutrition_foodgoal)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • name — varchar(50)
  • status — tinyint(1)
  • target_calorie — double
  • total_carbohydrate — double
  • target_sugar — double
  • target_protein — double
  • target_total_fat — double
  • target_start_date — datetime(6)
  • target_finish_date — datetime(6)
  • user_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL

식품측정단위 (nutrition_foodservings)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • unit — varchar(50)
  • weight — double
  • user_id — bigint(20) — 외래 키 → 사용자.id

운동 (workout_workout)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • name — varchar(100) — NOT NULL
  • category — varchar(100)
  • metrics_type — double
  • sports_id — bigint(20) — 외래 키 → 스포츠.id — NOT NULL
  • user_id — bigint(20) — 외래 키 → 사용자.id
  • display_name — varchar(100) — NOT NULL

운동목표 (workout_workoutgoal)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • name — varchar(50)
  • status — tinyint(1)
  • target_calorie — double
  • target_weight — double
  • target_distance — double
  • target_start_date — datetime(6)
  • target_finish_date — datetime(6)
  • user_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL

운동코스 (workout_workoutcourse)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • category — varchar(100)
  • name — varchar(100) — NOT NULL
  • start_date — datetime(6)
  • finish_date — datetime(6)
  • manager_id — bigint(20) — 외래 키 → 사용자.id

운동코스-사용자 (workout_workoutcourseuser)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • user_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL
  • workout_course_id — bigint(20) — 외래 키 → 운동코스.id — NOT NULL

운동코스-운동 (workout_workoutcourseworkout)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • workout_id — bigint(20) — 외래 키 → 운동.id — NOT NULL
  • workout_course_id — bigint(20) — 외래 키 → 운동코스.id — NOT NULL

운동활동 (workout_workoutactivity)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • category — varchar(50)
  • total_calorie — int(11)
  • status — tinyint(1)
  • start_date — datetime(6)
  • finish_date — datetime(6)
  • memo — varchar(50)
  • duration — bigint(20)
  • user_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL
  • workout_id — bigint(20) — 외래 키 → 운동.id — NOT NULL
  • workout_courses_id — bigint(20) — 외래 키 → 운동코스.id

운동활동상세 (workout_workoutactivitydetail)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • metrics_type — varchar(50)
  • set — int(11)
  • times — int(11)
  • weight — double
  • distance — double
  • user_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL
  • workout_activity_id — bigint(20) — 외래 키 → 운동활동.id — NOT NULL

음식 (nutrition_food)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • name — varchar(50) — NOT NULL
  • code — varchar(50) — NOT NULL
  • category — varchar(50)
  • calorie — double
  • total_carbohydrate — double
  • dietary_fiber — double
  • sugar — double
  • protein — double
  • total_fat — double
  • saturated_fatty_acids — double
  • trans_fatty_acid — double
  • total_vitamin — double
  • vitamin_a — double
  • vitamin_b6 — double
  • vitamin_b12 — double
  • vitamin_c — double
  • vitamin_d — double
  • vitamin_e — double
  • vitamin_k — double
  • minerals — double
  • calcium — double
  • iron — double
  • phosphorus — double
  • potassium — double
  • sodium — double
  • retinol — double
  • cholesterol — double
  • folate — double
  • magnesium — double
  • zinc — double
  • selenium — double
  • food_servings_id — bigint(20) — 외래 키 → 식품측정단위.id
  • user_id — bigint(20) — 외래 키 → 사용자.id

음식-재료 (nutrition_foodingredient)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • food_id — bigint(20) — 외래 키 → 음식.id — NOT NULL
  • ingredient_id — bigint(20) — 외래 키 → 재료.id — NOT NULL

음식코스 (nutrition_foodcourse)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • name — varchar(50) — NOT NULL
  • category — varchar(50)
  • serving_size — double
  • calorie — double
  • total_carbohydrate — double
  • dietary_fiber — double
  • sugar — double
  • protein — double
  • total_fat — double
  • saturated_fatty_acids — double
  • trans_fatty_acid — double
  • total_vitamin — double
  • vitamin_a — double
  • vitamin_b6 — double
  • vitamin_b12 — double
  • vitamin_c — double
  • vitamin_d — double
  • vitamin_e — double
  • vitamin_k — double
  • minerals — double
  • calcium — double
  • iron — double
  • phosphorus — double
  • potassium — double
  • sodium — double
  • retinol — double
  • cholesterol — double
  • folate — double
  • magnesium — double
  • zinc — double
  • selenium — double
  • food_servings_id — bigint(20) — 외래 키 → 식품측정단위.id
  • user_id — bigint(20) — 외래 키 → 사용자.id

음식코스-음식 (nutrition_foodcoursefood)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • food_id — bigint(20) — 외래 키 → 음식.id — NOT NULL
  • food_course_id — bigint(20) — 외래 키 → 음식코스.id — NOT NULL

음식코스-재료 (nutrition_foodcourseingredient)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • food_course_id — bigint(20) — 외래 키 → 음식코스.id — NOT NULL
  • ingredient_id — bigint(20) — 외래 키 → 재료.id — NOT NULL

재료 (nutrition_ingredient)

  • id — bigint(20) — 기본 키 — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • name — varchar(50) — NOT NULL
  • category — varchar(50)
  • calorie — double
  • total_carbohydrate — double
  • dietary_fiber — double
  • sugar — double
  • protein — double
  • total_fat — double
  • saturated_fatty_acids — double
  • trans_fatty_acid — double
  • total_vitamin — double
  • vitamin_a — double
  • vitamin_b6 — double
  • vitamin_b12 — double
  • vitamin_c — double
  • vitamin_d — double
  • vitamin_e — double
  • vitamin_k — double
  • minerals — double
  • calcium — double
  • iron — double
  • phosphorus — double
  • potassium — double
  • sodium — double
  • retinol — double
  • cholesterol — double
  • folate — double
  • magnesium — double
  • zinc — double
  • selenium — double
  • food_servings_id — bigint(20) — 외래 키 → 식품측정단위.id
  • user_id — bigint(20) — 외래 키 → 사용자.id

팔로우 (users_follow)

  • id — bigint(20) — 기본 키 — NOT NULL
  • update_date — datetime(6) — NOT NULL
  • create_date — datetime(6) — NOT NULL
  • is_aggrement — tinyint(1) — NOT NULL
  • followee_id — bigint(20) — 외래 키 → 사용자.id
  • follower_id — bigint(20) — 외래 키 → 사용자.id