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