synq temp

Tables (10)

ai_chat_message

  • id — uuid — Primary key — NOT NULL
  • meeting_id — uuid — Foreign key → meeting.id — NOT NULL
  • linked_segment_id — uuid — Foreign key → transcript_segment.id
  • question — text — NOT NULL
  • answer — text
  • source_chunk_ids — jsonb
  • suggested_questions — jsonb
  • status — text — NOT NULL
  • created_at — timestamptz — NOT NULL

ai_hint

  • id — uuid — Primary key — NOT NULL
  • meeting_id — uuid — Foreign key → meeting.id — NOT NULL
  • transcript_segment_id — uuid — Foreign key → transcript_segment.id — NOT NULL
  • meaning_text — text
  • impact_text — text
  • team_question_text — text
  • source_chunk_ids — jsonb
  • status — text — NOT NULL
  • created_at — timestamptz — NOT NULL

app_user

  • id — uuid — Primary key — NOT NULL
  • name — text — NOT NULL
  • created_at — timestamptz — NOT NULL

document_chunk

  • id — uuid — Primary key — NOT NULL
  • material_id — uuid — Foreign key → reference_material.id — NOT NULL
  • chunk_index — int — NOT NULL
  • content — text — NOT NULL
  • token_count — int — NOT NULL
  • embedding — vector(768)
  • embedding_model — text — NOT NULL
  • metadata — jsonb
  • created_at — timestamptz — NOT NULL

meeting

  • id — uuid — Primary key — NOT NULL
  • project_id — uuid — Foreign key → project.id — NOT NULL
  • owner_member_id — uuid — Foreign key → project_member.id — NOT NULL
  • title — text — NOT NULL
  • status — text — NOT NULL
  • end_reason — text
  • scheduled_at — timestamptz
  • started_at — timestamptz
  • ended_at — timestamptz
  • last_transcript_at — timestamptz
  • created_at — timestamptz — NOT NULL

meeting_transcript_chunk

  • id — uuid — Primary key — NOT NULL
  • meeting_id — uuid — Foreign key → meeting.id — NOT NULL
  • chunk_index — int — NOT NULL
  • content — text — NOT NULL
  • token_count — int — NOT NULL
  • embedding — vector(768)
  • embedding_model — text — NOT NULL
  • source_type — text — NOT NULL
  • created_at — timestamptz — NOT NULL

project

  • id — uuid — Primary key — NOT NULL
  • name — text — NOT NULL
  • created_at — timestamptz — NOT NULL

project_member

  • id — uuid — Primary key — NOT NULL
  • project_id — uuid — Foreign key → project.id — NOT NULL
  • user_id — uuid — Foreign key → app_user.id — NOT NULL
  • role — text — NOT NULL
  • joined_at — timestamptz — NOT NULL

reference_material

  • id — uuid — Primary key — NOT NULL
  • project_id — uuid — Foreign key → project.id — NOT NULL
  • registered_by — uuid — Foreign key → project_member.id — NOT NULL
  • type — text — NOT NULL
  • source_url — text
  • file_key — text
  • original_name — text — NOT NULL
  • mime_type — text
  • status — text — NOT NULL
  • fail_reason — text
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz

transcript_segment

  • id — uuid — Primary key — NOT NULL
  • meeting_id — uuid — Foreign key → meeting.id — NOT NULL
  • sequence_index — int — NOT NULL
  • content — text — NOT NULL
  • start_offset_ms — int — NOT NULL
  • end_offset_ms — int — NOT NULL
  • created_at — timestamptz — NOT NULL