v1.0

Tables (19)

Action Signals (action_signal)

  • Action Signal ID (id) — TEXT — Primary key — NOT NULL
  • Contact ID (contact_id) — TEXT — Foreign key → Contacts.Contact ID — NOT NULL
  • Action type (type) — ENUM — NOT NULL

Clerk Organization (clerk_org)

  • Organization ID (org_id) — TEXT — Primary key — NOT NULL

Clerk User (clerk_user)

  • User ID (user_id) — TEXT — Primary key — NOT NULL

Comparisons (comparison)

  • Comparison ID (id) — TEXT — Primary key — NOT NULL
  • Organization ID (org_id) — TEXT — Foreign key → Clerk Organization.Organization ID — NOT NULL
  • Competitor name (name) — TEXT — NOT NULL
  • Content (content) — TEXT — NOT NULL

Contacts (contact)

  • Contact ID (id) — TEXT — Primary key — NOT NULL
  • Is archived (archived) — BOOL — NOT NULL
  • Is new (new) — BOOL — NOT NULL
  • Email (email) — TEXT — NOT NULL
  • Full name (name) — TEXT — NOT NULL
  • Role (role) — ENUM — NOT NULL

Customer Logos (customer_logo)

  • Customer Logo ID (id) — TEXT — Primary key — NOT NULL
  • Organization ID (org_id) — TEXT — Foreign key → Clerk Organization.Organization ID — NOT NULL
  • Name (name) — TEXT — NOT NULL
  • Logo filename (image) — TEXT — NOT NULL

Customer Stories (customer_story)

  • Customer Story ID (id) — TEXT — Primary key — NOT NULL
  • Organization ID (org_id) — TEXT — Foreign key → Clerk Organization.Organization ID — NOT NULL
  • Name (name) — TEXT — NOT NULL
  • Logo filename (image) — TEXT — NOT NULL
  • Content (content) — TEXT

Organization Settings (org_settings)

  • Organization ID (org_id) — TEXT — Foreign key → Clerk Organization.Organization ID — NOT NULL
  • Product Settings (product) — JSONB — NOT NULL
  • Prospect Settings (prospect) — JSONB — NOT NULL
  • Sigma Settings (sigma) — JSONB — NOT NULL
  • Kanban Settings (kanban) — JSONB — NOT NULL

Page Signals (page_signal)

  • Page Signal ID (id) — TEXT — Primary key — NOT NULL
  • Contact ID (contact_id) — TEXT — Foreign key → Contacts.Contact ID — NOT NULL
  • Page path (path) — TEXT — NOT NULL
  • Opened at (opened_at) — TIMESTAMP — NOT NULL

Prospect Contacts (prospect_contact)

  • Propsect ID (prospect_id) — TEXT — Foreign key → Prospects.Propsect ID — NOT NULL
  • Contact ID (contact_id) — TEXT — Foreign key → Contacts.Contact ID — NOT NULL

Prospect Share Links (prospect_link)

  • Propsect ID (prospect_id) — TEXT — Foreign key → Prospects.Propsect ID — NOT NULL
  • Share link ID (share_link_id) — TEXT — Foreign key → Share Links.Share link ID — NOT NULL

Prospects (prospect)

  • Propsect ID (id) — TEXT — Primary key — NOT NULL
  • Creator ID (user_id) — TEXT — Foreign key → Clerk User.User ID — NOT NULL
  • Organization ID (org_id) — TEXT — Foreign key → Clerk Organization.Organization ID — NOT NULL
  • Is archived (archived) — BOOL — NOT NULL
  • Settings (settings) — JSONB — NOT NULL
  • Brand (brand) — JSONB — NOT NULL

Recordings (recording)

  • Recording ID (id) — TEXT — Primary key — NOT NULL
  • Organization ID (org_id) — TEXT — Foreign key → Clerk Organization.Organization ID — NOT NULL
  • Video (video) — TEXT — NOT NULL

Share Links (share_link)

  • Share link ID (id) — TEXT — Primary key — NOT NULL
  • Reciever's Contact ID (receiver_id) — TEXT — Foreign key → Contacts.Contact ID
  • Sender's Contact ID (sender_id) — TEXT — Foreign key → Contacts.Contact ID
  • Is preview (preview) — BOOL — NOT NULL

Showcases (showcase)

  • Showcase ID (id) — TEXT — Primary key — NOT NULL
  • Logo filename (image) — TEXT — NOT NULL
  • Title (title) — TEXT — NOT NULL
  • Description (description) — TEXT — NOT NULL
  • URL (url) — TEXT — NOT NULL
  • Instance type (type) — ENUM — NOT NULL

Sigma Contacts (sigma_contact)

  • Sigma ID (sigma_id) — TEXT — Foreign key → Sigmas.Sigma ID — NOT NULL
  • Contact ID (contact_id) — TEXT — Foreign key → Contacts.Contact ID — NOT NULL

Sigma Recordings (sigma_recording)

  • Sigma ID (sigma_id) — TEXT — Foreign key → Sigmas.Sigma ID — NOT NULL
  • Recording ID (recording_id) — TEXT — Foreign key → Recordings.Recording ID — NOT NULL

Sigma Share Links (sigma_link)

  • Sigma ID (sigma_id) — TEXT — Foreign key → Sigmas.Sigma ID — NOT NULL
  • Share link ID (share_link_id) — TEXT — Foreign key → Share Links.Share link ID — NOT NULL

Sigmas (sigma)

  • Sigma ID (id) — TEXT — Primary key — NOT NULL
  • Creator ID (user_id) — TEXT — Foreign key → Clerk User.User ID — NOT NULL
  • Organization ID (org_id) — TEXT — Foreign key → Clerk Organization.Organization ID — NOT NULL
  • Status (status) — ENUM — NOT NULL
  • Settings (settings) — JSONB — NOT NULL
  • Brand (brand) — JSONB — NOT NULL
  • Summary (summary) — TEXT
  • Summary created at (summarized_at) — TIMESTAMP