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