STAR.T

Tables (9)

Calendar (Untitled4)

  • calendar_id (Key) — int — Primary key — NOT NULL
  • date (Field2) — date
  • title (Field3) — char
  • user_id (Key2) — int — Foreign key → User.user_id — NOT NULL

CalendarRoutine (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • status (Field3) — char
  • calendar_id (Key2) — int — Foreign key → Calendar.calendar_id — NOT NULL
  • routine_id (Key3) — int — Foreign key → Routine.routine_id — NOT NULL

Celebrity (Untitled7)

  • celeb_id (Key) — int — Primary key — NOT NULL
  • name (Field) — char
  • profession (Field2)

CelebrityRoutine (Untitled8)

  • id (Key) — int — Primary key — NOT NULL
  • routine_id (Key2) — int — Foreign key → Routine.routine_id — NOT NULL
  • celeb_id (Key3) — int — Foreign key → Celebrity.celeb_id — NOT NULL

Challenge (Untitled3)

  • challenge_id (Key) — int — Primary key — NOT NULL
  • title (Field) — char
  • content (Field2) — text
  • start_date (Field5) — date
  • end_date (Field6) — date
  • status (Field7)
  • user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
  • routine_id (Key3) — int — Foreign key → Routine.routine_id — NOT NULL

ChallengeRoutines (Untitled9)

  • id (Key) — int — Primary key — NOT NULL
  • Field
  • challenge_id (Key2) — int — Foreign key → Challenge.challenge_id — NOT NULL
  • routine_id (Key3) — int — Foreign key → Routine.routine_id — NOT NULL

Rank (Untitled6)

  • rank_id (Key) — int — Primary key — NOT NULL
  • score (Field3) — int
  • user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
  • routine_id (Key3) — int — Foreign key → Routine.routine_id — NOT NULL

Routine (Untitled2)

  • routine_id (Key) — int — Primary key — NOT NULL
  • title (Field) — char
  • content (Field2) — text
  • category (Field3) — char
  • celeb_id (Key2) — int — Foreign key → Celebrity.celeb_id — NOT NULL

User (Untitled)

  • user_id (Key) — int — Primary key — NOT NULL
  • username (Field) — char
  • password (Field2) — char
  • email (Field3) — char
  • social_login_type (Field4) — char
  • sub_status (Field5) — boolean
  • sub_expiry_date (Field6) — date