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