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