260821

Tables (17)

ai_reports

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • user_id — bigint — NOT NULL
  • status — varchar(30) — NOT NULL
  • title — varchar(200)
  • video_object_key — varchar(512) — NOT NULL
  • content — TEXT — NOT NULL

card_branches

  • id — bigint — Primary key — NOT NULL
  • card_id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • next_card_id — bigint
  • updated_at — timestamp(6) — NOT NULL

card_media

  • id — bigint — Primary key — NOT NULL
  • sort_order — integer — NOT NULL
  • card_id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • media_type — varchar(20) — NOT NULL
  • url — varchar(512) — NOT NULL

cards

  • id — bigint — Primary key — NOT NULL
  • sort_order — integer — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • lesson_id — bigint — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • title — varchar(200) — NOT NULL
  • instruction — TEXT — NOT NULL

curriculums

  • id — bigint — Primary key — NOT NULL
  • sort_order — integer — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • topic_id — bigint — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • title — varchar(200) — NOT NULL
  • thumbnail_url — varchar(512) — NOT NULL
  • description — TEXT — NOT NULL

dog_personalities

  • dog_id — bigint — NOT NULL
  • personality — varchar(30) — NOT NULL

dogs

  • id — bigint — Primary key — NOT NULL
  • birth_date — date
  • weight_kg — numeric(5,2) — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • user_id — bigint — NOT NULL
  • sex — varchar(10) — NOT NULL
  • status — varchar(20) — NOT NULL
  • breed — varchar(30) — NOT NULL
  • name — varchar(50) — NOT NULL
  • profile_image_url — varchar(512) — NOT NULL
  • expectation — TEXT — NOT NULL

lesson_completion_logs

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • dog_id — bigint — NOT NULL
  • lesson_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL

lessons

  • id — bigint — Primary key — NOT NULL
  • estimated_minutes — integer — NOT NULL
  • sort_order — integer — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • curriculum_id — bigint — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • title — varchar(200) — NOT NULL

local_accounts

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • user_id — bigint — NOT NULL
  • email — varchar(255) — NOT NULL
  • password_hash — varchar(255) — NOT NULL

social_accounts

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • user_id — bigint — NOT NULL
  • provider — varchar(20) — NOT NULL
  • email — varchar(255)
  • provider_id — varchar(255) — NOT NULL

topics

  • id — bigint — Primary key — NOT NULL
  • sort_order — integer — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • training_category_id — bigint — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • title — varchar(100) — NOT NULL
  • icon_url — varchar(512) — NOT NULL
  • description — TEXT — NOT NULL
  • detail — TEXT — NOT NULL

training_categories

  • id — bigint — Primary key — NOT NULL
  • sort_order — integer — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • title — varchar(100) — NOT NULL
  • icon_url — varchar(512) — NOT NULL
  • description — TEXT — NOT NULL

user_lesson_progress

  • id — bigint — Primary key — NOT NULL
  • completed_count — integer — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • lesson_id — bigint — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • user_id — bigint — NOT NULL

user_profiles

  • user_id — bigint — Primary key — NOT NULL
  • birth_date — date
  • is_completed_tooltip — boolean — NOT NULL
  • mbti — varchar(4) — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • gender — varchar(10) — NOT NULL
  • nickname — varchar(50) — NOT NULL
  • profile_image_url — varchar(512) — NOT NULL
  • prior_training_topic_ids — bigint — NOT NULL
  • training_goal_topic_ids — bigint — NOT NULL

user_selected_topic

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • topic_id — bigint — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • user_id — bigint — NOT NULL

users

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • updated_at — timestamp(6) — NOT NULL
  • role — varchar(20) — NOT NULL
  • status — varchar(20) — NOT NULL