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)))