practice
테이블 (8)
email_drafts
- id — VARCHAR(36)
- user_id — VARCHAR(36) — NOT NULL
- prospect_id — VARCHAR(36)
- insight_id — VARCHAR(36)
- sequence_step — INTEGER
- subject_line_1 — VARCHAR(200)
- subject_line_2 — VARCHAR(200)
- subject_line_3 — VARCHAR(200)
- body_attention — TEXT
- body_interest — TEXT
- body_desire — TEXT
- body_action — TEXT
- body_evidence — TEXT
- full_body — TEXT
- email_type — VARCHAR(50)
- created_at — TIMESTAMP
insights
- id — VARCHAR(36)
- user_id — VARCHAR(36) — NOT NULL
- prospect_id — VARCHAR(36)
- target_url — VARCHAR(500) — NOT NULL
- campaign_goal — VARCHAR(100)
- positive_points — TEXT
- resistance_factors — TEXT
- customer_language — TEXT
- differentiation — TEXT
- campaign_opportunities — TEXT
- summary_5_7 — TEXT
- summary_3_sec — TEXT
- raw_data — TEXT
- created_at — TIMESTAMP
prospects
- ID (id) — UUID — 기본 키 — NOT NULL
- 사용자id (user_id) — UUID — 외래 키 → 사용자.ID — NOT NULL
- brand_name — VARCHAR(200) — NOT NULL
- contact_person — VARCHAR(100)
- contact_email — VARCHAR(255)
- website_url — VARCHAR(500)
- sequence_type — VARCHAR(20)
- current_step — INTEGER
- total_steps — INTEGER
- status — VARCHAR(20)
- notes — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
sent_emails
- id — VARCHAR(36)
- user_id — VARCHAR(36) — NOT NULL
- prospect_id — VARCHAR(36) — NOT NULL
- email_draft_id — VARCHAR(36)
- sequence_step — INTEGER — NOT NULL
- subject — VARCHAR(200) — NOT NULL
- body — TEXT — NOT NULL
- sent_at — TIMESTAMP — NOT NULL
- sent_method — VARCHAR(20)
- is_opened — BOOLEAN
- opened_at — TIMESTAMP
- is_replied — BOOLEAN
- replied_at — TIMESTAMP
- next_scheduled_at — TIMESTAMP
- notes — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
subscription_plans
- id — VARCHAR(36)
- name — VARCHAR(50) — NOT NULL
- display_name — VARCHAR(50) — NOT NULL
- price — INTEGER — NOT NULL
- monthly_credits — INTEGER — NOT NULL
- price_per_credit — INTEGER — NOT NULL
- features — TEXT
- is_active — BOOLEAN
- created_at — TIMESTAMP
usage_logs
- id — VARCHAR(36)
- user_id — VARCHAR(36) — NOT NULL
- subscription_id — VARCHAR(36) — NOT NULL
- action_type — VARCHAR(50) — NOT NULL
- credits_used — INTEGER
- related_insight_id — VARCHAR(36)
- related_email_id — VARCHAR(36)
- created_at — TIMESTAMP
사용자 (users)
- ID (id) — UUID — 기본 키 — NOT NULL
- 클럭아이디 (clerk_user_id) — text — NOT NULL
- 이메일 (email) — text — NOT NULL
- 이름 (name) — text — NOT NULL
- 회원가입날짜 (created_at) — timestamptz — NOT NULL
- 정보수정날짜 (updated_at) — timestamptz — NOT NULL
사용자 구독 (user_subscriptions)
- ID (id) — UUID — 기본 키 — NOT NULL
- user_id — VARCHAR(36) — NOT NULL
- plan_id — VARCHAR(36) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- credits_remaining — INTEGER — NOT NULL
- credits_total — INTEGER — NOT NULL
- current_period_start — TIMESTAMP — NOT NULL
- current_period_end — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP