ourfit-1

Tables (12)

challenge (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • userId1 (Field)
  • userid2 (Field2)

challenge-history (CopyOfUntitled3)

  • id (Key) — Primary key — NOT NULL
  • Field

exercise (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • Field

notification (CopyOfUntitled4)

  • id (Key) — Primary key — NOT NULL
  • userId (Field)

profile (Untitled4)

  • Key — Primary key — NOT NULL
  • level (Field)
  • perferTime (Field2)
  • area (Field3)

relation-exercise-information (a)

  • userId-1 (Key) — Primary key — NOT NULL
  • userId-2 (Key2) — Primary key — NOT NULL
  • week_days (Bit)

relationship (CopyOfUntitled)

  • userId-1 (Key) — Primary key — NOT NULL
  • userId-2 (Key2) — Primary key — NOT NULL
  • status (Field)

user (Untitled)

  • id (Key) — Primary key — NOT NULL
  • Field

user session (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • userId (Field)
  • createdat (Field2)

user-kakao (Untitled2)

  • id (Key) — Primary key — NOT NULL

user-naver (CopyOfUntitled2)

  • id (Key) — Primary key — NOT NULL

user-prefer-exercise (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • exerciseId (Field2)
  • userId (Key2) — Foreign key → user.id — NOT NULL
  • exercise-id (Key3) — Foreign key → exercise.id — NOT NULL