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