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