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