meetbowl.final

Tables (40)

admin_audit_logs

  • id — CHAR(36) — Primary key — NOT NULL
  • actor_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • target_id — CHAR(36)
  • created_at — DATETIME(6) — NOT NULL
  • occurred_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • action_area — VARCHAR(100) — NOT NULL
  • action_name — VARCHAR(100) — NOT NULL
  • actor_name — VARCHAR(100) — NOT NULL
  • ip_address — VARCHAR(100)
  • target_login_id — VARCHAR(100)
  • target_name — VARCHAR(100)
  • target_type — VARCHAR(100) — NOT NULL
  • user_agent — VARCHAR(500)
  • after_value — TEXT
  • before_value — TEXT
  • result — ENUM('FAILURE','SUCCESS') — NOT NULL

affiliates

  • id — CHAR(36) — Primary key — NOT NULL
  • sort_order — INTEGER
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • code — VARCHAR(50)
  • name — VARCHAR(100) — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL

building

  • id — CHAR(36) — Primary key — NOT NULL
  • site_id — CHAR(36) — Foreign key → site.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • name — VARCHAR(100) — NOT NULL

community_alias

  • id — CHAR(36) — Primary key — NOT NULL
  • user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • alias_no — INTEGER — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

community_comment

  • id — CHAR(36) — Primary key — NOT NULL
  • author_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • post_id — CHAR(36) — Foreign key → community_post.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • content — TEXT — NOT NULL

community_comment_like

  • id — CHAR(36) — Primary key — NOT NULL
  • comment_id — CHAR(36) — Foreign key → community_comment.id — NOT NULL
  • user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

community_post

  • id — CHAR(36) — Primary key — NOT NULL
  • author_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • view_count — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • category — ENUM('COMPANY_LIFE','FREE','HOBBY','RESTAURANT') — NOT NULL

community_post_like

  • id — CHAR(36) — Primary key — NOT NULL
  • post_id — CHAR(36) — Foreign key → community_post.id — NOT NULL
  • user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

departments

  • id — CHAR(36) — Primary key — NOT NULL
  • affiliate_id — CHAR(36) — Foreign key → affiliates.id
  • parent_department_id — CHAR(36) — Foreign key → departments.id
  • sort_order — INTEGER
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • code — VARCHAR(50)
  • name — VARCHAR(100) — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL

mail

  • id — CHAR(36) — Primary key — NOT NULL
  • organization_id — CHAR(36) — Foreign key → affiliates.id — NOT NULL
  • sender_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • related_resource_id — CHAR(36)
  • idempotency_key — CHAR(36) — NOT NULL
  • retry_count — INTEGER — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • failed_at — DATETIME(6)
  • requested_at — DATETIME(6)
  • sent_at — DATETIME(6)
  • updated_at — DATETIME(6) — NOT NULL
  • failure_code — VARCHAR(100)
  • subject — VARCHAR(200) — NOT NULL
  • body — MEDIUMTEXT — NOT NULL
  • body_type — ENUM('MINUTES_SHARE','TEXT') — NOT NULL
  • delivery_status — ENUM('DRAFT','FAILED','REQUESTED','RETRYING','SENT') — NOT NULL
  • mail_type — ENUM('ANNOUNCEMENT','NORMAL','SYSTEM') — NOT NULL
  • related_resource_type — ENUM('MEETING','MEETING_MINUTES','WORKSPACE')

mail_attachment

  • id — CHAR(36) — Primary key — NOT NULL
  • mail_id — CHAR(36) — Foreign key → mail.id — NOT NULL
  • uploader_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • size_bytes — BIGINT — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • mime_type — VARCHAR(150) — NOT NULL
  • object_key — VARCHAR(500) — NOT NULL
  • original_file_name — VARCHAR(255) — NOT NULL
  • stored_file_name — VARCHAR(255) — NOT NULL

mail_recipient

  • recipient_order — INTEGER — Primary key — NOT NULL
  • mail_id — CHAR(36) — Foreign key → mail.id — NOT NULL
  • recipient_user_id — CHAR(36) — Foreign key → users.id — NOT NULL

mail_retention_policies

  • id — CHAR(36) — Primary key — NOT NULL
  • updated_by — CHAR(36) — Foreign key → users.id — NOT NULL
  • auto_delete_enabled — BIT — NOT NULL
  • inbox_retention_days — INTEGER — NOT NULL
  • sent_retention_days — INTEGER — NOT NULL
  • trash_retention_days — INTEGER — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • policy_updated_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

mailbox_entry

  • id — CHAR(36) — Primary key — NOT NULL
  • mail_id — CHAR(36) — Foreign key → mail.id — NOT NULL
  • owner_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • permanently_deleted_at — DATETIME(6)
  • read_at — DATETIME(6)
  • trashed_at — DATETIME(6)
  • updated_at — DATETIME(6) — NOT NULL
  • mailbox_type — ENUM('INBOX','SENT') — NOT NULL

meeting

  • id — CHAR(36) — Primary key — NOT NULL
  • host_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • meeting_room_id — CHAR(36) — Foreign key → meeting_room.id
  • created_at — DATETIME(6) — NOT NULL
  • ended_at — DATETIME(6)
  • scheduled_at — DATETIME(6) — NOT NULL
  • scheduled_end_at — DATETIME(6) — NOT NULL
  • started_at — DATETIME(6)
  • updated_at — DATETIME(6) — NOT NULL
  • provider — VARCHAR(50)
  • provider_room_id — VARCHAR(200)
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • status — ENUM('CANCELLED','ENDED','IN_PROGRESS','SCHEDULED') — NOT NULL

meeting_attendee

  • id — CHAR(36) — Primary key — NOT NULL
  • meeting_id — CHAR(36) — Foreign key → meeting.id — NOT NULL
  • user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • reviewer — BOOLEAN — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • attendance_status — ENUM('ACCEPTED','DECLINED','INVITED') — NOT NULL
  • role — ENUM('HOST','PARTICIPANT','REVIEWER') — NOT NULL

meeting_ended_outbox

  • id — CHAR(36) — Primary key — NOT NULL
  • meeting_id — CHAR(36) — Foreign key → meeting.id — NOT NULL
  • organization_id — CHAR(36) — Foreign key → affiliates.id — NOT NULL
  • host_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • reviewer_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • correlation_id — CHAR(36) — NOT NULL
  • publish_attempts — INTEGER — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • ended_at — DATETIME(6) — NOT NULL
  • next_attempt_at — DATETIME(6) — NOT NULL
  • occurred_at — DATETIME(6) — NOT NULL
  • started_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • last_failure_reason — VARCHAR(500)

meeting_room

  • id — CHAR(36) — Primary key — NOT NULL
  • building_id — CHAR(36) — Foreign key → building.id — NOT NULL
  • available — BIT — NOT NULL
  • capacity — INTEGER — NOT NULL
  • floor — INTEGER
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • location — VARCHAR(200)

meeting_transcript_segments

  • id — CHAR(36) — Primary key — NOT NULL
  • meeting_id — CHAR(36) — Foreign key → meeting.id — NOT NULL
  • source_event_id — CHAR(36) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • ended_at_ms — BIGINT
  • sequence_no — BIGINT — NOT NULL
  • started_at_ms — BIGINT
  • updated_at — DATETIME(6) — NOT NULL
  • segment_id — VARCHAR(100) — NOT NULL
  • en_text — TEXT — NOT NULL
  • ko_text — TEXT — NOT NULL
  • source_text — TEXT — NOT NULL
  • source_language — ENUM('EN','KO','UNKNOWN') — NOT NULL

minutes

  • id — CHAR(36) — Primary key — NOT NULL
  • meeting_id — CHAR(36) — Foreign key → meeting.id — NOT NULL
  • organization_id — CHAR(36) — Foreign key → affiliates.id — NOT NULL
  • reviewer_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • approved_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • deletion_scheduled_at — DATETIME(6)
  • shared_at — DATETIME(6)
  • updated_at — DATETIME(6) — NOT NULL
  • model — VARCHAR(100) — NOT NULL
  • prompt_version — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • summary — TEXT — NOT NULL
  • status — ENUM('APPROVED','DELETION_SCHEDULED','DRAFT','IN_REVIEW','SHARED') — NOT NULL

minutes_favorites

  • id — CHAR(36) — Primary key — NOT NULL
  • minutes_id — CHAR(36) — Foreign key → minutes.id — NOT NULL
  • user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

minutes_generated_event_inbox

  • id — CHAR(36) — Primary key — NOT NULL
  • meeting_id — CHAR(36) — Foreign key → meeting.id — NOT NULL
  • event_id — CHAR(36) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

notification

  • id — CHAR(36) — Primary key — NOT NULL
  • recipient_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • resource_id — CHAR(36)
  • created_at — DATETIME(6) — NOT NULL
  • read_at — DATETIME(6)
  • updated_at — DATETIME(6) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • resource_type — ENUM('MEETING','MEETING_MINUTES')
  • type — ENUM('MEETING_CANCELLED','MEETING_REMINDER','MEETING_UPDATED','MINUTES_REVIEW_REMINDER','MINUTES_REVIEW_REQUEST') — NOT NULL

password_reset_requests

  • id — CHAR(36) — Primary key — NOT NULL
  • user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • processed_by_admin_id — CHAR(36) — Foreign key → users.id
  • created_at — DATETIME(6) — NOT NULL
  • processed_at — DATETIME(6)
  • requested_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • login_id — VARCHAR(100) — NOT NULL
  • requester_name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • status — ENUM('APPROVED','PENDING','REJECTED') — NOT NULL

personal_workspace_backup_attachments

  • id — CHAR(36) — Primary key — NOT NULL
  • backup_id — CHAR(36) — Foreign key → personal_workspace_backups.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • size_bytes — BIGINT — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • mime_type — VARCHAR(150) — NOT NULL
  • object_key — VARCHAR(500) — NOT NULL
  • original_file_name — VARCHAR(255) — NOT NULL
  • stored_file_name — VARCHAR(255) — NOT NULL

personal_workspace_backup_bookmarks

  • id — CHAR(36) — Primary key — NOT NULL
  • backup_id — CHAR(36) — Foreign key → personal_workspace_backups.id — NOT NULL
  • owner_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • bookmarked_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

personal_workspace_backups

  • id — CHAR(36) — Primary key — NOT NULL
  • owner_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • source_id — CHAR(36) — NOT NULL
  • backed_up_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • summary — VARCHAR(1000)
  • body — MEDIUMTEXT
  • source_type — ENUM('MAIL') — NOT NULL

personal_workspace_calendar_events

  • id — CHAR(36) — Primary key — NOT NULL
  • owner_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • source_id — CHAR(36)
  • all_day — BIT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • ended_at — DATETIME(6) — NOT NULL
  • started_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — VARCHAR(1000)
  • source — ENUM('MEETING','PERSONAL') — NOT NULL

personal_workspace_calendar_subscriptions

  • id — CHAR(36) — Primary key — NOT NULL
  • subscriber_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • target_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • subscribed_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

personal_workspace_drive_files

  • id — CHAR(36) — Primary key — NOT NULL
  • owner_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • size_bytes — BIGINT — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • uploaded_at — DATETIME(6) — NOT NULL
  • content_type — VARCHAR(100)
  • storage_key — VARCHAR(500) — NOT NULL
  • original_file_name — VARCHAR(255) — NOT NULL

personal_workspace_memos

  • id — CHAR(36) — Primary key — NOT NULL
  • owner_user_id — CHAR(36) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • memo_created_at — DATETIME(6) — NOT NULL
  • memo_updated_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(10000) — NOT NULL

positions

  • id — CHAR(36) — Primary key — NOT NULL
  • sort_order — INTEGER
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • code — VARCHAR(50)
  • name — VARCHAR(100) — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL

shared_workspace_file_versions

  • id — CHAR(36) — Primary key — NOT NULL
  • file_id — CHAR(36) — Foreign key → shared_workspace_files.id — NOT NULL
  • uploader_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • version_major — INTEGER — NOT NULL
  • version_minor — INTEGER — NOT NULL
  • version_patch — INTEGER — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • size_bytes — BIGINT — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • uploaded_at — DATETIME(6) — NOT NULL
  • content_type — VARCHAR(100)
  • storage_key — VARCHAR(500) — NOT NULL
  • change_memo — VARCHAR(1000)
  • original_file_name — VARCHAR(255) — NOT NULL

shared_workspace_files

  • id — CHAR(36) — Primary key — NOT NULL
  • uploader_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • workspace_id — CHAR(36) — Foreign key → shared_workspaces.id — NOT NULL
  • current_version_major — INTEGER — NOT NULL
  • current_version_minor — INTEGER — NOT NULL
  • current_version_patch — INTEGER — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • size_bytes — BIGINT — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • uploaded_at — DATETIME(6) — NOT NULL
  • content_type — VARCHAR(100)
  • storage_key — VARCHAR(500) — NOT NULL
  • original_file_name — VARCHAR(255) — NOT NULL

shared_workspace_members

  • id — CHAR(36) — Primary key — NOT NULL
  • invited_by_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • workspace_id — CHAR(36) — Foreign key → shared_workspaces.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • joined_at — DATETIME(6) — NOT NULL
  • removed_at — DATETIME(6)
  • updated_at — DATETIME(6) — NOT NULL
  • role — ENUM('MEMBER','OWNER') — NOT NULL
  • status — ENUM('ACTIVE','REMOVED') — NOT NULL

shared_workspaces

  • id — CHAR(36) — Primary key — NOT NULL
  • organization_id — CHAR(36) — Foreign key → affiliates.id — NOT NULL
  • owner_user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • updated_at — DATETIME(6) — NOT NULL
  • workspace_created_at — DATETIME(6) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(1000)
  • visibility — ENUM('MEMBERS_ONLY','ORGANIZATION') — NOT NULL

site

  • id — CHAR(36) — Primary key — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(300)

teams

  • id — CHAR(36) — Primary key — NOT NULL
  • department_id — CHAR(36) — Foreign key → departments.id
  • sort_order — INTEGER
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • code — VARCHAR(50)
  • name — VARCHAR(100) — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL

user_settings

  • id — CHAR(36) — Primary key — NOT NULL
  • user_id — CHAR(36) — Foreign key → users.id — NOT NULL
  • meeting_reminder_minutes_before — INTEGER — NOT NULL
  • minutes_review_reminder_minutes — INTEGER — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

users

  • id — CHAR(36) — Primary key — NOT NULL
  • affiliate_id — CHAR(36) — Foreign key → affiliates.id
  • department_id — CHAR(36) — Foreign key → departments.id
  • team_id — CHAR(36) — Foreign key → teams.id
  • position_id — CHAR(36) — Foreign key → positions.id
  • initial_password_change_required — BIT — NOT NULL
  • active_from — DATETIME(6)
  • active_until — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)
  • updated_at — DATETIME(6) — NOT NULL
  • login_id — VARCHAR(100) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • role — ENUM('ADMIN','SYSTEM','USER') — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE','LOCKED') — NOT NULL