linkfit_with_gemini
Tables (4)
exercise_programs (프로그램)
- id — int8 — Primary key — NOT NULL
- category_id — int8
- created_at — timestamptz(6) — NOT NULL
- created_user_id — int8 — NOT NULL
- description — text
- level — varchar(20)
- like_count — int4 — NOT NULL
- program_name — varchar(100) — NOT NULL
- program_type — varchar(20) — NOT NULL
- status — varchar(20) — NOT NULL
- updated_at — timestamptz(6) — NOT NULL
- use_count — int4 — NOT NULL
- INTERMEDIATE::character — varying
- ADVANCED::character — varying)::text)))
- SHARED::character — varying
- POPULAR::character — varying)::text)))
- PUBLISHED::character — varying
- ARCHIVED::character — varying)::text)))
exercises (운동종목)
- id — bigserial — Primary key — NOT NULL
- user_id (user_id2) — int8 — Foreign key → users.user_id — NOT NULL
- name — varchar(150) — NOT NULL
- category — varchar(100) — NOT NULL
- body_part — varchar(100) — NOT NULL
- equipment — varchar(50)
- description — varchar(2000)
- created_at — timestamp — NOT NULL
- name_en — varchar(150)
- image_path — varchar(500)
plans (플랜)
- id — int8 — Primary key — NOT NULL
- program_id — int8 — Foreign key → exercise_programs.id — NOT NULL
- user_id (user_id2) — int8 — Foreign key → users.user_id — NOT NULL
- created_at — timestamptz(6) — NOT NULL
- day_order — int4
- title — varchar(50) — NOT NULL
- week_number — int4
- week_day — int4
- last_completed_at — timestamptz(6)
- description — text
users
- user_id — int8 — Primary key — NOT NULL
- account_locked_until — timestamptz(6)
- birth_date — date
- country_code — varchar(10) — NOT NULL
- created_at — timestamptz(6) — NOT NULL
- email — varchar(120) — NOT NULL
- exercise_level — varchar(10) — NOT NULL
- gender — varchar(10)
- height — numeric(5, 2) — NOT NULL
- last_login_at — timestamptz(6)
- last_login_ip — varchar(64)
- login_attempt_count — int4 — NOT NULL
- modified_at — timestamptz(6) — NOT NULL
- name — varchar(100)
- phone — varchar(30) — NOT NULL
- phone_verified — bool — NOT NULL
- profile_image — varchar(255)
- status — varchar(20) — NOT NULL
- user_type — varchar(20) — NOT NULL
- weight — numeric(6, 2) — NOT NULL
- social_id — varchar(255)
- social_provider — varchar(20)
- MIDDLE::character — varying
- HIGH::character — varying)::text)))
- FEMALE::character — varying)::text)))
- INACTIVE::character — varying
- SUSPENDED::character — varying)::text)))