Jealth_ERD

Tables (5)

eat_food_list (섭취한음식)

  • eat_food_no (섭취음식일련번호) — NUMBER — Primary key — NOT NULL
  • id (아이디) — VARCHAR2 — Foreign key → user_info.user_id — NOT NULL
  • eat_food_name (섭취음식이름) — VARCHAR2
  • eat_food_count (섭취횟수) — NUMBER
  • eat_food_Kcal (섭취음식열량) — VARCHAR2
  • eat_food_protein (섭취음식단백질) — VARCHAR2
  • eat_food_fat (섭취음식지방) — VARCHAR2
  • eat_food_carbo (섭취음식탄수화물) — VARCHAR2
  • eat_food_meal_time (섭취시간) — VARCHAR2
  • eat_food_meal_date (섭취날짜) — NUMBER

food_list (음식목록)

  • food_no (음식일련번호) — NUMBER — Primary key — NOT NULL
  • food_name (음식이름) — VARCHAR2
  • food_Kcal (음식열량) — NUMBER
  • food_protein (음식단백실) — NUMBER
  • food_fat (음식지방) — NUMBER
  • food_carbo (음식탄수화물) — NUMBER
  • food_company (제조회사) — VARCHAR2
  • food_category1 (음식카테고리1) — VARCHAR2
  • food_category2 (음식카테고리2) — VARCHAR2
  • food_add_user (음식생성유저) — VARCHAR2
  • food_add_date (음식생성일) — NUMBER

user_info (회원정보)

  • user_id (아이디) — VARCHAR2 — Primary key — NOT NULL
  • user_pw (비밀번호) — VARCHAR2
  • nickname (닉네임) — VARCHAR2
  • user_sex (성별) — VARCHAR2
  • user_age (연령대) — NUMBER
  • birthday (생년월일) — NUMBER
  • weight (몸무게) — NUMBER
  • stature (키) — NUMBER
  • squat_pr (스쿼트_pr) — NUMBER
  • Deadlift_pr (데드리프트_pr) — NUMBER
  • benchpress_pr (벤치프레스_pr) — NUMBER
  • user_create_date (유저가입일) — NUMBER

workout_list (운동목록)

  • workout_no (운동일련번호) — NUMBER — Primary key — NOT NULL
  • user_id (아이디) — VARCHAR2 — Foreign key → user_info.user_id — NOT NULL
  • workout_name (운동명) — VARCHAR2
  • muscle_part (근육부위) — VARCHAR2
  • workout_create_date (운동추가일) — VARCHAR2

workout_recode (운동횟수기록)

  • user_id (아이디2) — VARCHAR2 — Foreign key → workout_list.user_id — NOT NULL
  • workout_no (운동일련번호) — NUMBER — Foreign key → workout_list.workout_no — NOT NULL
  • workout_round_no (운동세트번호) — NUMBER
  • workout_count (운동횟수) — NUMBER
  • workout_weight (운동무게) — NUMBER
  • workout_date (운동날짜) — VARCHAR2