link
Tables (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 — NOT NULL
- price_krw — integer — NOT NULL
- 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
- dwell_seconds — integer
- scroll_depth — integer
- interacted — boolean — NOT NULL
- created_at — timestamptz — 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 — NOT NULL
- 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
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
users
- Key — Primary key — NOT NULL
- id — uuid
- clerk_id — text — NOT NULL
- email — text — NOT NULL
- name — text
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL