ff

Tables (9)

generation_logs

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • prospect_id — UUID — NOT NULL
  • step_number — INT
  • step_type — VARCHAR(100)
  • model_name — VARCHAR(100) — gemini-3.0-pro
  • input_tokens — INT
  • output_tokens — INT
  • created_at — TIMESTAMPTZ — NOT NULL

plans

  • id — UUID — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • monthly_quota — INT — NOT NULL
  • price_krw — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

prospects

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • contact_name — VARCHAR(255)
  • contact_email — VARCHAR(255) — NOT NULL
  • url — VARCHAR(500) — NOT NULL
  • memo — TEXT
  • vision_data — JSONB — Vision
  • crm_status — VARCHAR(50) — NOT NULL — CRM
  • visit_count — INT — NOT NULL — 리포트
  • last_viewed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

report_events

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • prospect_id — UUID — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL — view(접속)
  • metadata — JSONB — {"scroll_depth":
  • created_at — TIMESTAMPTZ — NOT NULL

sequences

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • prospect_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • sequence_type — VARCHAR(100) — NOT NULL — 9_steps
  • total_steps — INT — NOT NULL
  • current_step — INT — NOT NULL
  • status — VARCHAR(50) — NOT NULL — draft(작성중)
  • custom_context — TEXT — 마케터
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

step

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • sequence_id — UUID — NOT NULL
  • step_number — INT — NOT NULL
  • step_type — VARCHAR(100)
  • email_subject — VARCHAR(255)
  • email_body — TEXT
  • status — VARCHAR(50) — NOT NULL — pending(미발송)
  • sent_at — TIMESTAMPTZ
  • is_core_step — BOOLEAN — NOT NULL — 1
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

step_templates

  • id — UUID — Primary key — NOT NULL
  • step_number — INT — NOT NULL
  • step_name — VARCHAR(100) — NOT NULL
  • subject_template — TEXT — NOT NULL
  • body_template — TEXT — NOT NULL
  • description — TEXT
  • variables — JSONB — AI가
  • created_at — TIMESTAMPTZ — NOT NULL

user_plans

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • plan_id — UUID — NOT NULL
  • is_current — BOOLEAN — NOT NULL
  • started_at — TIMESTAMPTZ — NOT NULL
  • ended_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

users

  • id — UUID — Primary key — NOT NULL
  • clerk_id — TEXT — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL