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