fitmate

Tables (9)

DirectLessonRequest

  • id — TEXT — Primary key — NOT NULL
  • lessonRequestId — TEXT — NOT NULL
  • trainerId — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

FavoriteTrainer

  • id — TEXT — Primary key — NOT NULL
  • userId — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

LessonQuote

  • id — TEXT — Primary key — NOT NULL
  • trainerId — TEXT — NOT NULL
  • lessonRequestId — TEXT — NOT NULL
  • price — DOUBLE — NOT NULL
  • message — TEXT — NOT NULL
  • status — "QuoteStatus" — NOT NULL
  • rejectionReason — TEXT
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

LessonRequest

  • id — TEXT — Primary key — NOT NULL
  • userId — TEXT — NOT NULL
  • lessonType — "LessonType" — NOT NULL
  • lessonSubType — "LessonSubType"
  • startDate — TIMESTAMP(3) — NOT NULL
  • endDate — TIMESTAMP(3) — NOT NULL
  • lessonCount — INTEGER — NOT NULL
  • lessonTime — INTEGER — NOT NULL
  • quoteEndDate — TIMESTAMP(3) — NOT NULL
  • locationType — "LocationType" — NOT NULL
  • postcode — TEXT
  • roadAddress — TEXT
  • detailAddress — TEXT
  • status — "LessonRequestStatus" — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Notification

  • id — TEXT — Primary key — NOT NULL
  • userId — TEXT — NOT NULL
  • type — "NotificationType" — NOT NULL
  • message — TEXT — NOT NULL
  • isRead — BOOLEAN — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Profile

  • id — TEXT — Primary key — NOT NULL
  • userId — TEXT — NOT NULL
  • name — TEXT
  • profileImage — TEXT
  • gender — "Gender" — NOT NULL
  • lessonType — "LessonType"
  • region — "Region"
  • intro — TEXT
  • description — TEXT
  • experience — INTEGER
  • certification — TEXT
  • certificationValidated — BOOLEAN — NOT NULL
  • rating — DOUBLE
  • lessonCount — INTEGER
  • reviewCount — INTEGER
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Review

  • id — TEXT — Primary key — NOT NULL
  • userId — TEXT — NOT NULL
  • lessonQuoteId — TEXT — NOT NULL
  • rating — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

SocialAccount

  • id — TEXT — Primary key — NOT NULL
  • userId — TEXT — NOT NULL
  • provider — TEXT — NOT NULL
  • providerId — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

User

  • id — TEXT — Primary key — NOT NULL
  • email — TEXT — NOT NULL
  • nickname — TEXT — NOT NULL
  • password — TEXT — NOT NULL
  • phone — TEXT
  • refreshToken — TEXT
  • role — "Role" — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL