dd

Tables (23)

core_document_change_logs

  • change_id — BIGSERIAL — Primary key — NOT NULL
  • document_id — BIGINT — Foreign key → documents.document_id — NOT NULL
  • before_content — TEXT
  • after_content — TEXT — NOT NULL
  • based_on_meeting_id — BIGINT — Foreign key → meetings.meeting_id
  • status — change_status — NOT NULL
  • approved_by — BIGINT — Foreign key → users.user_id
  • approved_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

direct_messages

  • message_id — BIGSERIAL — Primary key — NOT NULL
  • sender_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • receiver_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content — TEXT — NOT NULL
  • sent_at — TIMESTAMPTZ — NOT NULL

document_embeddings

  • document_id — BIGINT — Foreign key → documents.document_id — NOT NULL
  • embedding — VECTOR(1536) — NOT NULL

documents

  • document_id — BIGSERIAL — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.project_id — NOT NULL
  • category — document_category — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • content — TEXT
  • author_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.meeting_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • search_vector — tsvector

meeting_availabilities

  • id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • start_time — TIMESTAMPTZ — NOT NULL
  • end_time — TIMESTAMPTZ — NOT NULL

meeting_chat_messages

  • message_id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
  • sender_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • receiver_id — BIGINT — Foreign key → users.user_id
  • content — TEXT — NOT NULL
  • type — chat_message_type — NOT NULL
  • mentioned_user_id — BIGINT — Foreign key → users.user_id
  • sent_at — TIMESTAMPTZ — NOT NULL

meeting_feedbacks

  • feedback_id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
  • mic_occupancy — JSONB
  • section_time_stats — JSONB
  • summary_text — TEXT
  • evaluation_score — NUMERIC(5,2)
  • created_at — TIMESTAMPTZ — NOT NULL

meeting_participants

  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • role — meeting_role — NOT NULL
  • status — invite_status — NOT NULL
  • invited_at — TIMESTAMPTZ — NOT NULL
  • joined_at — TIMESTAMPTZ

meeting_prep_references

  • id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
  • document_id — BIGINT — Foreign key → documents.document_id — NOT NULL

meeting_preps

  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
  • purpose — TEXT
  • decision_goal — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

meeting_sections

  • section_id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • sort_order — INT — NOT NULL
  • expected_duration_min — INT — NOT NULL
  • actual_duration_min — INT
  • assignee_user_id — BIGINT — Foreign key → users.user_id

meeting_transcripts

  • transcript_id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
  • section_id — BIGINT — Foreign key → meeting_sections.section_id
  • speaker_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content — TEXT — NOT NULL
  • spoken_at — TIMESTAMPTZ — NOT NULL

meetings

  • meeting_id — BIGSERIAL — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.project_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • status — meeting_status — NOT NULL
  • scheduled_at — TIMESTAMPTZ
  • created_by — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

project_interview_answers

  • answer_id — BIGSERIAL — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.project_id — NOT NULL
  • question_key — VARCHAR(50) — NOT NULL
  • question_text — TEXT — NOT NULL
  • answer_text — TEXT
  • sort_order — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

projects

  • project_id — BIGSERIAL — Primary key — NOT NULL
  • team_id — BIGINT — Foreign key → teams.team_id — NOT NULL
  • project_name — VARCHAR(150) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

section_summaries

  • section_id — BIGINT — Foreign key → meeting_sections.section_id — NOT NULL
  • summary_text — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

team_chat_messages

  • message_id — BIGSERIAL — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → projects.project_id — NOT NULL
  • sender_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content — TEXT — NOT NULL
  • sent_at — TIMESTAMPTZ — NOT NULL

team_members

  • team_id — BIGINT — Foreign key → teams.team_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • role — team_role — NOT NULL
  • joined_at — TIMESTAMPTZ — NOT NULL

teams

  • team_id — BIGSERIAL — Primary key — NOT NULL
  • team_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • profile_image_url — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — Foreign key → users.user_id — NOT NULL

users

  • user_id — BIGSERIAL — Primary key — NOT NULL
  • oauth_provider — VARCHAR(20) — NOT NULL
  • oauth_id — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL

vote_options

  • option_id — BIGSERIAL — Primary key — NOT NULL
  • vote_id — BIGINT — Foreign key → votes.vote_id — NOT NULL
  • option_text — VARCHAR(200) — NOT NULL

vote_responses

  • vote_id — BIGINT — Foreign key → votes.vote_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • option_id — BIGINT — Foreign key → vote_options.option_id — NOT NULL
  • responded_at — TIMESTAMPTZ — NOT NULL

votes

  • vote_id — BIGSERIAL — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
  • section_id — BIGINT — Foreign key → meeting_sections.section_id
  • title — VARCHAR(200) — NOT NULL
  • created_by — BIGINT — Foreign key → users.user_id — NOT NULL
  • status — vote_status — NOT NULL
  • time_limit_sec — INT
  • created_at — TIMESTAMPTZ — NOT NULL