synq._v2

Tables (22)

ai_chat_message

  • id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meeting.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • linked_segment_id — BIGINT
  • client_request_id — UUID — NOT NULL
  • question — TEXT — NOT NULL
  • answer — TEXT
  • status — VARCHAR(20) — NOT NULL
  • source_refs — JSONB — NOT NULL
  • suggested_questions — JSONB — NOT NULL
  • error_code — VARCHAR(50)
  • error_message — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

ai_segment_hint

  • id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meeting.id — NOT NULL
  • segment_id — BIGINT — Foreign key → transcript_segment.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • meaning — TEXT — NOT NULL
  • my_impact — TEXT — NOT NULL
  • team_question — TEXT — NOT NULL
  • source — VARCHAR(10) — NOT NULL
  • importance — INTEGER
  • trigger_reason — TEXT
  • topic — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

ai_summary_job

  • id — UUID — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meeting.id — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • retry_count — INTEGER — NOT NULL
  • model_name — VARCHAR(100)
  • prompt_version — VARCHAR(50) — NOT NULL
  • error_message — TEXT
  • failed_personal_summary_count — INTEGER — NOT NULL
  • started_at — TIMESTAMPTZ
  • completed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

document_chunk

  • id — BIGSERIAL — Primary key — NOT NULL
  • reference_material_id — BIGINT — Foreign key → reference_material.id — NOT NULL
  • project_id — BIGINT — NOT NULL
  • chunk_index — INT — NOT NULL
  • content — TEXT — NOT NULL
  • embedding — vector(768) — NOT NULL
  • embedding_model — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

meeting

  • id — BIGSERIAL — Primary key — NOT NULL
  • project_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • started_at — TIMESTAMP
  • ended_at — TIMESTAMP
  • title_auto_generated — BOOLEAN — NOT NULL
  • paused_at — TIMESTAMP
  • last_resumed_at — TIMESTAMP — NOT NULL
  • active_seconds_snapshot — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

meeting_live_context

  • id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meeting.id — NOT NULL
  • rolling_summary — TEXT — NOT NULL
  • current_topic — TEXT
  • decisions — JSONB — NOT NULL
  • action_items — JSONB — NOT NULL
  • open_questions — JSONB — NOT NULL
  • last_segment_id — BIGINT — NOT NULL
  • last_sequence_index — INTEGER — NOT NULL
  • version — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

meeting_participant

  • id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meeting.id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • role — VARCHAR(10) — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL
  • left_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

meeting_recording_segment

  • id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meeting.id — NOT NULL
  • storage_key — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

meeting_summary

  • id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meeting.id — NOT NULL
  • job_id — UUID — Foreign key → ai_summary_job.id — NOT NULL
  • version — INTEGER — NOT NULL
  • overall_summary — TEXT — NOT NULL
  • key_topics — JSONB — NOT NULL
  • decisions — JSONB — NOT NULL
  • action_items — JSONB — NOT NULL
  • open_questions — JSONB — NOT NULL
  • one_line_summary — TEXT
  • discussion_sections — JSONB
  • tentative_directions — JSONB
  • confirmation_items — JSONB
  • generated_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

meeting_transcript_chunk

  • id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meeting.id — NOT NULL
  • project_id — BIGINT — NOT NULL
  • chunk_index — INT — NOT NULL
  • content — TEXT — NOT NULL
  • embedding — vector(768) — NOT NULL
  • embedding_model — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

meeting_transcript_index_status

  • meeting_id — BIGINT — Foreign key → meeting.id — NOT NULL
  • project_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • failure_reason — TEXT
  • chunk_count — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

personal_summary

  • id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meeting.id — NOT NULL
  • job_id — UUID — Foreign key → ai_summary_job.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • version — INTEGER — NOT NULL
  • role — VARCHAR(100)
  • personal_summary — TEXT — NOT NULL
  • key_points — JSONB — NOT NULL
  • my_action_items — JSONB — NOT NULL
  • follow_up_questions — JSONB — NOT NULL
  • generated_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

project

  • id — BIGSERIAL — Primary key — NOT NULL
  • owner_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(30) — NOT NULL
  • description — VARCHAR(500)
  • invite_token — VARCHAR(36)
  • invite_token_expires_at — TIMESTAMP
  • deleted_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

project_join_request

  • id — BIGSERIAL — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → project.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • setting_source — VARCHAR(20) — NOT NULL
  • role — VARCHAR(30) — NOT NULL
  • detail_role — VARCHAR(30)
  • requested_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

project_join_request_perspectives

  • id — BIGSERIAL — Primary key — NOT NULL
  • join_request_id — BIGINT — Foreign key → project_join_request.id — NOT NULL
  • perspective — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

project_member

  • id — BIGSERIAL — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → project.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • role — VARCHAR(10) — NOT NULL
  • use_default — BOOLEAN — NOT NULL
  • role_category — VARCHAR(30)
  • detail_role — VARCHAR(30)
  • joined_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

project_member_perspectives

  • id — BIGSERIAL — Primary key — NOT NULL
  • project_member_id — BIGINT — Foreign key → project_member.id — NOT NULL
  • perspective — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

reference_material

  • id — BIGSERIAL — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → project.id — NOT NULL
  • uploader_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • type — VARCHAR(10) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • url — VARCHAR(2000)
  • storage_key — VARCHAR(512)
  • file_size — BIGINT
  • file_extension — VARCHAR(10)
  • status — VARCHAR(20) — NOT NULL
  • deleted_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

role_profile_perspectives

  • id — BIGSERIAL — Primary key — NOT NULL
  • role_profile_id — BIGINT — Foreign key → role_profiles.id — NOT NULL
  • perspective — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

role_profiles

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • role — VARCHAR(30) — NOT NULL
  • detail_role — VARCHAR(30)
  • is_default — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

transcript_segment

  • id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meeting.id — NOT NULL
  • sequence_index — INTEGER — NOT NULL
  • start_ms — INTEGER — NOT NULL
  • end_ms — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • speaker_label — VARCHAR(50)
  • is_modified — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • user_id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • email — VARCHAR(255)
  • password_hash — VARCHAR(255)
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • profile_image_key — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL