gunyoil

Tables (12)

diet_meallog

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users_user.id — NOT NULL
  • date — DATE — NOT NULL
  • meal_type — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • calories — INTEGER — NOT NULL
  • protein — NUMERIC(6,1) — NOT NULL
  • carbs — NUMERIC(6,1) — NOT NULL
  • fat — NUMERIC(6,1) — NOT NULL
  • memo — VARCHAR(200) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

diet_proteinlog

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users_user.id — NOT NULL
  • date — DATE — NOT NULL
  • amount — NUMERIC(6,1) — NOT NULL
  • log_type — VARCHAR(20) — NOT NULL
  • note — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

diet_schoolmealselectionlog

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users_user.id — NOT NULL
  • date — DATE — NOT NULL
  • meal_type — VARCHAR(20) — NOT NULL
  • menu_name — VARCHAR(100) — NOT NULL
  • selection — VARCHAR(20) — NOT NULL
  • estimated_protein_grams — NUMERIC(6,1) — NOT NULL
  • final_protein_grams — NUMERIC(6,1) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

exercises_exercise

  • id — BIGSERIAL
  • code — VARCHAR(100)
  • name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • target_muscle — VARCHAR(50) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

routines_routine

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users_user.id — NOT NULL
  • day_of_week — INTEGER — NOT NULL

routines_routinedetail

  • id — BIGSERIAL
  • routine_id — BIGINT — Foreign key → routines_routine.id — NOT NULL
  • exercise_id — BIGINT — Foreign key → exercises_exercise.id — NOT NULL
  • target_weight — DOUBLE — NOT NULL
  • target_reps — INTEGER — NOT NULL
  • target_sets — INTEGER — NOT NULL
  • order — INTEGER — NOT NULL

users_announcement

  • id — BIGSERIAL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • is_selected_for_users — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

users_inquiry

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users_user.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • reply_email — VARCHAR(254)
  • content — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

users_user

  • id — BIGSERIAL
  • email — VARCHAR(254) — NOT NULL
  • password — VARCHAR(128) — NOT NULL
  • last_login — TIMESTAMPTZ
  • is_superuser — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • is_staff — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • gender — VARCHAR(1)
  • height — DOUBLE
  • weight — DOUBLE
  • goal — VARCHAR(100)
  • onboarding_completed — BOOLEAN — NOT NULL

users_userpushtoken

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users_user.id — NOT NULL
  • token — TEXT — NOT NULL
  • device_type — VARCHAR(20) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

workouts_dailylog

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users_user.id — NOT NULL
  • date — DATE — NOT NULL
  • is_completed — BOOLEAN — NOT NULL

workouts_workoutset

  • id — BIGSERIAL
  • daily_log_id — BIGINT — Foreign key → workouts_dailylog.id — NOT NULL
  • exercise_id — BIGINT — Foreign key → exercises_exercise.id — NOT NULL
  • set_number — INTEGER — NOT NULL
  • weight — DOUBLE — NOT NULL
  • reps — INTEGER — NOT NULL
  • is_completed — BOOLEAN — NOT NULL