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