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