hafit
Tables (13)
Card (카드)
- cardId (카드PK) — Int — Primary key — NOT NULL
- cardName (카드이름) — String
- cardType (카드타입) — enum
- cardRare (카드레어도) — enum
- cardCondition (획득조건) — String
CardCollect (모은 카드들)
- cardCollectId (모은카드PK) — Int — Primary key — NOT NULL
- profileId (프로필PK) — Int — Foreign key → Profile.profileId — NOT NULL
- userId (사용자PK) — Int — Foreign key → Profile.userId — NOT NULL
- cardId (카드PK) — Int — Foreign key → Card.cardId — NOT NULL
- profileImageId (프로필이미지 PK) — int — Foreign key → Profile.profileImageId — NOT NULL
- profileTitleId (프로필칭호 PK) — Int — Foreign key → Profile.profileTitleId — NOT NULL
- cardCollectDate (카드 획득 날짜) — Date
Exercise (운동)
- exerciseId (운동PK) — Int — Primary key — NOT NULL
- Field
Food (음식)
- foodId (음식PK) — Int — Primary key — NOT NULL
- foodName (음식명) — String
- foodCalories (음식칼로리) — Int
- crabs (탄수화물) — int
- fat (지방) — int
- protein (단백질) — int
- detail (전체영양성분) — json
Friend (친구)
- friendId (친구PK) — Int — Primary key — NOT NULL
- userId (사용자PK) — Int — Foreign key → User.userId — NOT NULL
- friendStatus (친구상태) — enum
- createdAt (보낸날짜) — DateTime
- Field
Meal (식단)
- mealId (식단PK) — Int — Primary key — NOT NULL
- profileId (프로필PK) — Int — Foreign key → Profile.profileId — NOT NULL
- userId (사용자PK) — Int — Foreign key → Profile.userId — NOT NULL
- profileImageId (프로필이미지 PK) — int — Foreign key → Profile.profileImageId — NOT NULL
- profileTitleId (프로필칭호 PK) — Int — Foreign key → Profile.profileTitleId — NOT NULL
- mealType (식사종류) — enum
- mealDate (식사시간) — DateTIme
MealItem (식단기록)
- mealItemId (식단기록PK) — Int — Primary key — NOT NULL
- foodId (음식PK) — Int — Foreign key → Food.foodId — NOT NULL
- mealId (식단PK) — Int — Foreign key → Meal.mealId — NOT NULL
- profileId (프로필PK) — Int — Foreign key → Meal.profileId — NOT NULL
- userId (사용자PK) — Int — Foreign key → Meal.userId — NOT NULL
- profileImageId (프로필이미지 PK) — int — Foreign key → Meal.profileImageId — NOT NULL
- profileTitleId (프로필칭호 PK) — Int — Foreign key → Meal.profileTitleId — NOT NULL
- quantity (1회섭취량) — Int
Physical (신체스펙)
- physicalId (신체스펙PK) — Int — Primary key — NOT NULL
- planId (플랜PK) — Int — Foreign key → Plan.planId — NOT NULL
- profileId (프로필PK) — Int — Foreign key → Profile.profileId — NOT NULL
- userId (사용자PK) — Int — Foreign key → Profile.userId — NOT NULL
- profileImageId (프로필이미지 PK) — int — Foreign key → Profile.profileImageId — NOT NULL
- profileTitleId (프로필칭호 PK) — Int — Foreign key → Profile.profileTitleId — NOT NULL
- height (키) — Decimal(5,2)
- weight (몸무게) — Decimal(5,2)
- targetWeight (목표몸무게) — Decimal(5,2)
- goalType (운동목표) — enum — 다이어트, 근력 향상, 퍼포먼스 향상, 체중 유지
- Field
Plan (플랜)
- planId (플랜PK) — Int — Primary key — NOT NULL
- planName (플랜명) — enum — 다이어트, 근력 향상, 퍼포먼스 향상, 체중 유지
- Field
Profile (프로필)
- profileId (프로필PK) — Int — Primary key — NOT NULL
- profileImageId (프로필이미지 FK) — int — Foreign key → ProfileImage.profileImageId — NOT NULL
- userId (사용자FK) — Int — Foreign key → User.userId — NOT NULL
- profileTitleId (프로필칭호 FK) — Int — Foreign key → ProfileTitle.profileTitleId — NOT NULL
- userCode (유저코드) — String
- userName (닉네임) — String
- gender (성별) — enum
- birth (생일) — date
- public (공개 비공개) — enum
ProfileImage (프로필 이미지)
- profileImageId (프로필이미지 PK) — int — Primary key — NOT NULL
- profileImageName (프로필 이름) — String
- profileImageUrl (프로필이미지URL) — String
ProfileTitle (프로필 칭호)
- profileTitleId (프로필칭호 PK) — Int — Primary key — NOT NULL
- profileTitleName (프로필칭호명) — String
- profileTitleExplane (프로필칭호설명) — String
- profileTitleGetDate (프로필칭호획득날짜) — Date
User (사용자)
- userId (사용자PK) — Int — Primary key — NOT NULL
- loginType (로그인 타입) — enum — google, 애플, 자사 로그인
- email (이메일) — String — 남성, 여성
- password (비밀번호) — String
- lastestLogint (마지막로그인 기록) — DateTime