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