수정본

테이블 (9)

generation_logs

  • id — uuid
  • user_id — uuid — NOT NULL
  • prospect_id — uuid
  • step_id — uuid
  • step_type — text
  • input_payload — jsonb — NOT NULL
  • output_insights — jsonb
  • output_email_subject — text
  • output_email_body — text
  • created_at — timestamptz — NOT NULL

plans

  • code — text
  • name — text — NOT NULL
  • description — text
  • monthly_quota — integer
  • price_krw — integer
  • is_active — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL

prospects

  • id — uuid
  • user_id — uuid — NOT NULL
  • name — text — NOT NULL
  • contact_name — text
  • contact_email — text
  • url — text — NOT NULL
  • memo — text
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

report_events

  • id — uuid
  • user_id — uuid — NOT NULL
  • report_id — uuid — NOT NULL
  • step_id — uuid — NOT NULL

reports

  • id — uuid
  • user_id — uuid — NOT NULL
  • step_id — uuid — NOT NULL
  • report_json — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

sequences

  • id — uuid
  • user_id — uuid — NOT NULL
  • prospect_id — uuid — NOT NULL
  • name — text
  • sequence_type — text — NOT NULL
  • total_steps — integer
  • current_step — integer
  • status — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

steps

  • id — uuid
  • user_id — uuid — NOT NULL
  • sequence_id — uuid — NOT NULL
  • step_number — integer — NOT NULL
  • step_type — text
  • email_subject — text
  • email_body — text
  • status — text — NOT NULL
  • recommended_send_at — timestamptz
  • sent_at — timestamptz
  • is_replied — boolean — NOT NULL
  • replied_at — timestamptz
  • has_clicked_report — boolean — NOT NULL
  • report_engagement_level — text — NOT NULL
  • last_report_view_seconds — integer
  • last_report_scroll_depth — integer
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

user_plans

  • id — uuid
  • user_id — uuid — NOT NULL
  • plan_code — text — NOT NULL
  • is_current — boolean — NOT NULL
  • started_at — timestamptz — NOT NULL
  • ended_at — timestamptz
  • note — text

users

  • id — uuid
  • clerk_id — text — NOT NULL
  • email — text — NOT NULL
  • name — text
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL