forma

Tables (17)

ADS (Untitled2)

  • id — bigint — Primary key — NOT NULL
  • title — varchar
  • image_url — varchar
  • target_url — varchar
  • budget — numeric
  • status — varchar
  • created_at — timestamptz

AD_LINKS (Untitled9)

  • id — bigint — Primary key — NOT NULL
  • video_id — bigint — Foreign key → VIDEOS.id — NOT NULL
  • ad_id — bigint — Foreign key → ADS.id — NOT NULL
  • placement_type — varchar
  • exposed_at — timestamptz
  • created_at — timestamptz

AD_STATS_DAILY (Untitled3)

  • id — bigint — Primary key — NOT NULL
  • ad_id — bigint — Foreign key → ADS.id — NOT NULL
  • stat_date — date
  • impressions — bigint
  • clicks — bigiint
  • created_at — timestamptz

ANALYSIS_HISTORY (Untitled14)

  • id — bigint — Primary key — NOT NULL
  • videio_id (video_id) — bigint — Foreign key → VIDEOS.id — NOT NULL
  • status — varchar
  • round_number — int
  • started_at — timestamptz
  • completed_at — timestamptz
  • created_at — timestamptz

FEEDBACKS (Untitled16)

  • id — bigint — Primary key — NOT NULL
  • video_id — bigint — Foreign key → VIDEOS.id — NOT NULL
  • frame_id — bigint — Foreign key → FRAMES.id — NOT NULL
  • source_type — varchar
  • comment — varchar
  • score — float
  • created_at — timestamptz

FEEDBACK_COMMENTS (Untitled11)

  • id — bigint — Primary key — NOT NULL
  • feedback_id — bigint — Foreign key → FEEDBACKS.id — NOT NULL
  • user_id — bigint — Foreign key → USERS.id — NOT NULL
  • parent_comment_id — bigint
  • body — varchar
  • created_at — timestamptz
  • Field

FRAMES (Untitled15)

  • id — bigint — Primary key — NOT NULL
  • analysis_history_id — bigint — Foreign key → ANALYSIS_HISTORY.id — NOT NULL
  • frame_index — int
  • Field (timestamp_sec) — float
  • keypoints — jsonb
  • created_at — timestamptz

PAYMENT_LOGS (Untitled7)

  • id — bigint — Primary key — NOT NULL
  • subscription_id — bigint — Foreign key → SUBSCRIPTIONS.id — NOT NULL
  • amount_cents — bigint
  • currency — varchar
  • pg_transaction_id — varchar
  • status — varchar
  • paid_at — timestamptz
  • created_at — timestamptz

PRACTICES (Untitled8)

  • id — int — Primary key — NOT NULL
  • sport_id — int — Foreign key → SPORTS.id — NOT NULL
  • title — varchar
  • description — varchar
  • guide_json — jsonb
  • is_active — bool
  • created_at — timestamptz

SPORTS (Untitled6)

  • id — int — Primary key — NOT NULL
  • name — varchar
  • description — varchar
  • is_active — bool
  • created_at — timestamptz

SUBSCRIPTIONS (Untitled5)

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → USERS.id — NOT NULL
  • subscription_plan_id — int — Foreign key → SUBSCRIPTION_PLANS.id — NOT NULL
  • status — varchar
  • started_at — timestampttz
  • ended_at — timestamptz
  • created_at — timestamptz

SUBSCRIPTION_PLANS (Untitled10)

  • id — int — Primary key — NOT NULL
  • plan_code — varchar
  • name — varchar
  • price_cents — int
  • biling_period — varchar
  • features_json — jsonb
  • is_active — bool
  • created_at — timestamptz

USERS (사용자 정보)

  • id — bigint — Primary key — NOT NULL
  • password_hash — varchar
  • email — varchar
  • login_id — varchar
  • name — varchar
  • birthdate — date
  • gender — varchar
  • role — varchar
  • created_at — timestamptz
  • updated_at — timestamptz

USERS_AD (Untitled)

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → USERS.id — NOT NULL
  • ad_id — bigint — Foreign key → ADS.id — NOT NULL
  • contract_status — varchar
  • allocated_budget — numeric
  • started_at — timestamptz
  • ended_at — timestamptz
  • created_at — timestamptz

USER_SKILLS (Untitled4)

  • id — int — Primary key — NOT NULL
  • user_id — bigint — Foreign key → USERS.id — NOT NULL
  • practice_id — int — Foreign key → PRACTICES.id — NOT NULL
  • ai-level — smallint
  • coach_level — smallint
  • assessed_at — timestamptz
  • created_at — timestamptz

VIDEOS (Untitled12)

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → USERS.id — NOT NULL
  • sport_id — int — Foreign key → SPORTS.id — NOT NULL
  • title — varchar
  • video_url — varchar
  • duration_sec — int
  • visibility — varchar
  • created_at — timestamptz

VIDEO_PRACTICE_MATCH (Untitled13)

  • id — int — Primary key — NOT NULL
  • video_id — bigint — Foreign key → VIDEOS.id — NOT NULL
  • practice_id — int — Foreign key → PRACTICES.id — NOT NULL
  • match_score — float
  • created_at — timestamptz