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