Refit

Tables (8)

Item (Untitled5)

  • Key — Primary key — NOT NULL
  • Field

character (Untitled4)

  • Key — Primary key — NOT NULL
  • exp (Field)
  • level (Field2)
  • Field3
  • Member Id (member_id) — int — Foreign key → member.Member Id — NOT NULL

exercise (Untitled3)

  • exercise Id (Key) — Primary key — NOT NULL
  • youtubeUrl (Field)
  • 운동설명 (Field2)
  • 제목 (Field3)
  • 썸네일 (Field4)
  • duration (Field5)
  • Field6
  • Routine Id (routine_id) — int — Foreign key → routines.Routine Id — NOT NULL

member (Untitled)

  • Member Id (member_id) — int — Primary key — NOT NULL
  • 나이 (age) — int
  • 몸무게 (weight) — int
  • 성별 (gender) — enum
  • 신장 (height) — double
  • 이름 (name) — string
  • 근력
  • 유연성
  • 심폐지구력 (Field)
  • 순발력 (Field2)
  • 평형성 (Field3)
  • 이메일 (Field4)
  • 패스워드 (Field5)
  • Field6

point (Untitled6)

  • Key — Primary key — NOT NULL

purchase (Untitled8)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Item.Key — NOT NULL
  • Member Id (member_id) — int — Foreign key → member.Member Id — NOT NULL

routine_access (Untitled7)

  • Key — Primary key — NOT NULL
  • Member Id (member_id) — int — Foreign key → member.Member Id — NOT NULL
  • Routine Id (routine_id) — int — Foreign key → routines.Routine Id — NOT NULL
  • isCompleted (Field)
  • Field2

routines (Untitled2)

  • Routine Id (routine_id) — int — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Member Id (member_id) — int — Foreign key → member.Member Id — NOT NULL