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