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