meetbowl

Tables (49)

admin_action_logs

  • admin_action_log_id — BIGINT — Primary key — NOT NULL
  • actor_user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 관리자 ID
  • action_domain — VARCHAR(50) — NOT NULL — 작업 영역
  • action_name — VARCHAR(100) — NOT NULL — 작업명
  • target_type — VARCHAR(50) — 작업 대상 타입
  • target_id — BIGINT — 작업 대상 ID
  • result — ENUM('SUCCESS', 'FAIL') — NOT NULL
  • request_ip — VARCHAR(45)
  • detail_json — JSON
  • created_at — DATETIME — NOT NULL

affiliates

  • affiliate_id — BIGINT — Primary key — NOT NULL — 계열사 PK
  • affiliate_code — VARCHAR(50) — NOT NULL — 계열사 코드
  • affiliate_name — VARCHAR(100) — NOT NULL — 계열사명
  • description — VARCHAR(255)
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

calendar_events

  • calendar_event_id — BIGINT — Primary key — NOT NULL
  • owner_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • location — VARCHAR(255)
  • map_url — VARCHAR(500) — 지도 API 장소 링크
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • event_type — ENUM('PERSONAL', 'MEETING', 'GOOGLE') — NOT NULL
  • related_meeting_id — BIGINT — Foreign key → meetings.meeting_id
  • related_room_reservation_id — BIGINT — Foreign key → room_reservations.room_reservation_id
  • external_event_id — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

chatbot_conversations

  • chatbot_conversation_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(200)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

chatbot_messages

  • chatbot_message_id — BIGINT — Primary key — NOT NULL
  • chatbot_conversation_id — BIGINT — Foreign key → chatbot_conversations.chatbot_conversation_id — NOT NULL
  • sender_type — ENUM('USER', 'ASSISTANT', 'SYSTEM') — NOT NULL
  • message — LONGTEXT — NOT NULL
  • source_refs_json — JSON — 참조 메일/회의록/파일 정보
  • created_at — DATETIME — NOT NULL

colleague_subscriptions

  • colleague_subscription_id — BIGINT — Primary key — NOT NULL
  • subscriber_user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 구독자
  • target_user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 구독 대상 동료
  • can_view_schedule — TINYINT(1) — NOT NULL
  • can_view_contact — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

community_boards

  • community_board_id — BIGINT — Primary key — NOT NULL
  • board_code — VARCHAR(50) — NOT NULL
  • board_name — VARCHAR(100) — NOT NULL
  • is_anonymous — TINYINT(1) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

community_posts

  • community_post_id — BIGINT — Primary key — NOT NULL
  • community_board_id — BIGINT — Foreign key → community_boards.community_board_id — NOT NULL
  • author_user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 실제 작성자. 화면에서는 익명 처리
  • title — VARCHAR(200) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • view_count — INT — NOT NULL
  • reaction_count — INT — NOT NULL
  • is_hot — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • FULLTEXT — KEY

community_reactions

  • community_reaction_id — BIGINT — Primary key — NOT NULL
  • community_post_id — BIGINT — Foreign key → community_posts.community_post_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • reaction_type — ENUM('LIKE') — NOT NULL
  • created_at — DATETIME — NOT NULL

department_document_versions

  • department_document_version_id — BIGINT — Primary key — NOT NULL
  • department_document_id — BIGINT — Foreign key → department_documents.department_document_id — NOT NULL
  • version_no — INT — NOT NULL
  • content — LONGTEXT — 웹 편집기 문서 내용
  • file_id — BIGINT — Foreign key → file_assets.file_id — 첨부형 문서 파일
  • editor_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • change_summary — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • FULLTEXT — KEY

department_documents

  • department_document_id — BIGINT — Primary key — NOT NULL
  • department_id — BIGINT — Foreign key → departments.department_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • current_version_no — INT — NOT NULL
  • created_by — BIGINT — Foreign key → users.user_id — NOT NULL
  • updated_by — BIGINT — Foreign key → users.user_id
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

departments

  • department_id — BIGINT — Primary key — NOT NULL — 부서 PK
  • affiliate_id — BIGINT — Foreign key → affiliates.affiliate_id — NOT NULL — 소속 계열사 ID
  • department_code — VARCHAR(50) — NOT NULL — 부서 코드
  • department_name — VARCHAR(100) — NOT NULL — 부서명
  • description — VARCHAR(255)
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

drive_files

  • drive_file_id — BIGINT — Primary key — NOT NULL
  • owner_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • file_id — BIGINT — Foreign key → file_assets.file_id — NOT NULL
  • folder_path — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

external_calendar_accounts

  • external_calendar_account_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • provider — ENUM('GOOGLE') — NOT NULL
  • external_account_email — VARCHAR(150) — NOT NULL
  • access_token_encrypted — TEXT
  • refresh_token_encrypted — TEXT
  • token_expires_at — DATETIME
  • linked_at — DATETIME — NOT NULL
  • disconnected_at — DATETIME

file_assets

  • file_id — BIGINT — Primary key — NOT NULL
  • uploader_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • original_name — VARCHAR(255) — NOT NULL
  • stored_name — VARCHAR(255) — NOT NULL
  • storage_path — VARCHAR(500) — NOT NULL — 로컬/오브젝트 스토리지 경로
  • mime_type — VARCHAR(100) — NOT NULL
  • extension — VARCHAR(20)
  • file_size — BIGINT — NOT NULL
  • checksum — VARCHAR(128)
  • file_status — ENUM('ACTIVE', 'DELETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

file_policies

  • file_policy_id — BIGINT — Primary key — NOT NULL
  • policy_domain — ENUM('MAIL', 'MEETING', 'MINUTES', 'WORKSPACE', 'DEPARTMENT_DOCUMENT') — NOT NULL
  • allowed_extensions — VARCHAR(500) — NOT NULL — 허용 확장자 목록. 예: pdf,png,jpg,docx,xlsx
  • max_file_size_mb — INT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

jobs

  • job_id — BIGINT — Primary key — NOT NULL — 직무 PK
  • job_code — VARCHAR(50) — NOT NULL — 직무 코드
  • job_name — VARCHAR(100) — NOT NULL — 직무명
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

login_refresh_tokens

  • refresh_token_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • revoked_at — DATETIME
  • created_at — DATETIME — NOT NULL

mail_attachments

  • mail_attachment_id — BIGINT — Primary key — NOT NULL
  • mail_message_id — BIGINT — Foreign key → mail_messages.mail_message_id — NOT NULL
  • file_id — BIGINT — Foreign key → file_assets.file_id — NOT NULL
  • created_at — DATETIME — NOT NULL

mail_messages

  • mail_message_id — BIGINT — Primary key — NOT NULL
  • sender_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • subject — VARCHAR(255) — NOT NULL
  • body — LONGTEXT — NOT NULL
  • mail_type — ENUM('NORMAL','NOTICE','MEETING_MINUTES') — NOT NULL
  • send_status — ENUM('DRAFT','SENT','FAILED') — NOT NULL
  • failure_reason — TEXT
  • related_meeting_id — BIGINT — Foreign key → meetings.meeting_id
  • related_minutes_id — BIGINT — Foreign key → meeting_minutes.meeting_minutes_id
  • sent_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • FULLTEXT — KEY

mail_recipients

  • mail_recipient_id — BIGINT — Primary key — NOT NULL
  • mail_message_id — BIGINT — Foreign key → mail_messages.mail_message_id — NOT NULL
  • recipient_type — ENUM('USER','DEPARTMENT','TEAM','ALL') — NOT NULL
  • recipient_user_id — BIGINT — Foreign key → users.user_id
  • recipient_department_id — BIGINT — Foreign key → departments.department_id
  • recipient_team_id — BIGINT — Foreign key → teams.team_id
  • mailbox_type — ENUM('INBOX','SENT','TRASH') — NOT NULL
  • read_at — DATETIME
  • trashed_at — DATETIME
  • deleted_at — DATETIME
  • backup_status — ENUM('NONE','BACKED_UP') — NOT NULL
  • created_at — DATETIME — NOT NULL

meeting_chat_messages

  • meeting_chat_message_id — BIGINT — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
  • sender_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • message — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

meeting_files

  • meeting_file_id — BIGINT — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
  • file_id — BIGINT — Foreign key → file_assets.file_id — NOT NULL
  • uploaded_by — BIGINT — Foreign key → users.user_id — NOT NULL
  • file_purpose — ENUM('REFERENCE','SCREEN_SHARE_CAPTURE','ETC') — NOT NULL
  • created_at — DATETIME — NOT NULL

meeting_minutes

  • meeting_minutes_id — BIGINT — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
  • meeting_transcript_id — BIGINT — Foreign key → meeting_transcripts.meeting_transcript_id
  • summary — LONGTEXT — 회의 주요 내용
  • decisions — LONGTEXT — 결정 사항
  • action_items — LONGTEXT — 후속 작업
  • watermark_applied — TINYINT(1) — NOT NULL — 문서 추출 워터마크 적용 여부
  • auto_send_enabled — TINYINT(1) — NOT NULL — 회의록 자동 발송 여부
  • auto_sent_at — DATETIME
  • retention_status — ENUM('ACTIVE', 'SCHEDULED_DELETE', 'DELETED', 'HOLD') — NOT NULL
  • scheduled_delete_at — DATETIME
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • FULLTEXT — KEY

meeting_minutes_shares

  • meeting_minutes_share_id — BIGINT — Primary key — NOT NULL
  • meeting_minutes_id — BIGINT — Foreign key → meeting_minutes.meeting_minutes_id — NOT NULL
  • sender_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • recipient_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • share_type — ENUM('AUTO_TO_ATTENDEE', 'MANUAL_TO_ABSENT', 'MANUAL') — NOT NULL
  • sent_at — DATETIME — NOT NULL
  • mail_message_id — BIGINT — 메일 생성 후 연결 가능. FK는 순환 방지를 위해 미적용

meeting_participants

  • meeting_participant_id — BIGINT — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • participant_role — ENUM('HOST','ATTENDEE') — NOT NULL
  • attendance_status — ENUM('INVITED','JOINED','LEFT','ABSENT') — NOT NULL
  • mic_enabled — TINYINT(1) — NOT NULL
  • camera_enabled — TINYINT(1) — NOT NULL
  • joined_at — DATETIME
  • left_at — DATETIME
  • created_at — DATETIME — NOT NULL

meeting_recordings

  • meeting_recording_id — BIGINT — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
  • file_id — BIGINT — Foreign key → file_assets.file_id — NOT NULL
  • duration_seconds — INT
  • recording_status — ENUM('UPLOADED','PROCESSING','COMPLETED','FAILED','DELETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

meeting_rooms

  • meeting_room_id — BIGINT — Primary key — NOT NULL
  • affiliate_id — BIGINT — Foreign key → affiliates.affiliate_id — NOT NULL — 소속 계열사
  • room_name — VARCHAR(100) — NOT NULL
  • location — VARCHAR(255) — NOT NULL — 층수/위치
  • capacity — INT — NOT NULL
  • is_available — TINYINT(1) — NOT NULL — 예약 가능 여부
  • description — VARCHAR(255)
  • created_by — BIGINT — Foreign key → users.user_id
  • updated_by — BIGINT — Foreign key → users.user_id
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

meeting_transcripts

  • meeting_transcript_id — BIGINT — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — NOT NULL
  • meeting_recording_id — BIGINT — Foreign key → meeting_recordings.meeting_recording_id
  • stt_provider — VARCHAR(50) — 예: CLOVA
  • transcript_text — LONGTEXT — STT 원문
  • process_status — ENUM('PENDING', 'PROCESSING', 'COMPLETED', 'FAILED') — NOT NULL
  • error_message — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • FULLTEXT — KEY

meetings

  • meeting_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT — 회의 내용
  • host_user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 주최자
  • affiliate_id — BIGINT — Foreign key → affiliates.affiliate_id — NOT NULL — 회의 소속 계열사
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • meeting_type — ENUM('ROOM', 'VIDEO', 'HYBRID') — NOT NULL
  • recording_enabled — TINYINT(1) — NOT NULL
  • status — ENUM('SCHEDULED', 'IN_PROGRESS', 'ENDED', 'CANCELLED') — NOT NULL
  • video_room_key — VARCHAR(150) — 화상회의 방 식별자
  • ended_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notifications

  • notification_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • notification_type — ENUM('MEETING_REMINDER','MAIL','MINUTES_SHARED','SYSTEM','ROOM_RESTRICTION') — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • link_url — VARCHAR(500)
  • read_at — DATETIME
  • created_at — DATETIME — NOT NULL

password_reset_tokens

  • password_reset_token_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • used_at — DATETIME
  • created_at — DATETIME — NOT NULL

permissions

  • permission_id — BIGINT — Primary key — NOT NULL — 세부 권한 PK
  • permission_code — VARCHAR(80) — NOT NULL — 권한 코드
  • permission_name — VARCHAR(100) — NOT NULL — 권한명
  • permission_group — VARCHAR(50) — NOT NULL — 권한 그룹
  • description — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

personal_contacts

  • personal_contact_id — BIGINT — Primary key — NOT NULL
  • owner_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • contact_user_id — BIGINT — Foreign key → users.user_id — 내부 사용자일 경우 연결
  • name — VARCHAR(80) — NOT NULL
  • email — VARCHAR(150)
  • phone — VARCHAR(30)
  • department_name — VARCHAR(100)
  • position_name — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

personal_memos

  • personal_memo_id — BIGINT — Primary key — NOT NULL
  • owner_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — LONGTEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • FULLTEXT — KEY

positions

  • position_id — BIGINT — Primary key — NOT NULL — 직급 PK
  • position_code — VARCHAR(50) — NOT NULL — 직급 코드
  • position_name — VARCHAR(100) — NOT NULL — 직급명
  • sort_order — INT — NOT NULL — 정렬 순서
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

retention_policies

  • retention_policy_id — BIGINT — Primary key — NOT NULL
  • policy_domain — ENUM('MAIL_INBOX', 'MAIL_SENT', 'MAIL_TRASH', 'MEETING_MINUTES', 'TRANSCRIPT', 'AI_SUMMARY', 'RECORDING', 'MEETING_FILE', 'WORKSPACE_BACKUP') — NOT NULL
  • retention_days — INT — NOT NULL — 보관 일수
  • auto_delete_enabled — TINYINT(1) — NOT NULL
  • created_by — BIGINT — Foreign key → users.user_id — NOT NULL
  • updated_by — BIGINT — Foreign key → users.user_id
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

role_change_logs

  • role_change_log_id — BIGINT — Primary key — NOT NULL
  • target_user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 권한 변경 대상자
  • actor_user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 작업자
  • before_role_id — BIGINT — Foreign key → roles.role_id
  • after_role_id — BIGINT — Foreign key → roles.role_id
  • before_permissions_json — JSON — 변경 전 세부 권한
  • after_permissions_json — JSON — 변경 후 세부 권한
  • change_reason — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

role_permissions

  • role_permission_id — BIGINT — Primary key — NOT NULL
  • role_id — BIGINT — Foreign key → roles.role_id — NOT NULL
  • permission_id — BIGINT — Foreign key → permissions.permission_id — NOT NULL
  • created_at — DATETIME — NOT NULL

roles

  • role_id — BIGINT — Primary key — NOT NULL — 역할 PK
  • role_code — VARCHAR(30) — NOT NULL — MASTER, ADMIN, USER
  • role_name — VARCHAR(50) — NOT NULL — 역할명
  • description — VARCHAR(255) — 설명
  • is_system_role — TINYINT(1) — NOT NULL — 시스템 기본 역할 여부
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

room_reservation_slots

  • room_reservation_slot_id — BIGINT — Primary key — NOT NULL
  • room_reservation_id — BIGINT — Foreign key → room_reservations.room_reservation_id — NOT NULL
  • meeting_room_id — BIGINT — Foreign key → meeting_rooms.meeting_room_id — NOT NULL
  • slot_start_at — DATETIME — NOT NULL — 30분 단위 예약 슬롯 시작 시각
  • created_at — DATETIME — NOT NULL

room_reservations

  • room_reservation_id — BIGINT — Primary key — NOT NULL
  • meeting_id — BIGINT — Foreign key → meetings.meeting_id — 연결 회의 ID
  • meeting_room_id — BIGINT — Foreign key → meeting_rooms.meeting_room_id — NOT NULL
  • reserver_id — BIGINT — Foreign key → users.user_id — NOT NULL — 예약자
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • status — ENUM('RESERVED', 'CANCELLED', 'COMPLETED') — NOT NULL
  • cancelled_by — BIGINT — Foreign key → users.user_id
  • cancelled_at — DATETIME
  • cancel_reason — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

teams

  • team_id — BIGINT — Primary key — NOT NULL — 팀 PK
  • department_id — BIGINT — Foreign key → departments.department_id — NOT NULL — 소속 부서 ID
  • team_code — VARCHAR(50) — NOT NULL — 팀 코드
  • team_name — VARCHAR(100) — NOT NULL — 팀명
  • description — VARCHAR(255)
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_permissions

  • user_permission_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — Admin 사용자 ID
  • permission_id — BIGINT — Foreign key → permissions.permission_id — NOT NULL — 부여 권한 ID
  • granted_by — BIGINT — Foreign key → users.user_id — NOT NULL — 권한 부여자 ID
  • granted_at — DATETIME — NOT NULL
  • revoked_at — DATETIME

user_settings

  • user_setting_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • meeting_reminder_minutes — INT — NOT NULL — 회의 시작 전 알림 시간
  • auto_backup_enabled — TINYINT(1) — NOT NULL — 자동 백업 사용 여부
  • tutorial_skipped — TINYINT(1) — NOT NULL — 튜토리얼 생략 여부
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_tutorial_states

  • user_tutorial_state_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • tutorial_code — VARCHAR(50) — NOT NULL
  • is_completed — TINYINT(1) — NOT NULL
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL — 사용자 PK
  • login_id — VARCHAR(80) — NOT NULL — 로그인 아이디
  • password_hash — VARCHAR(255) — NOT NULL — 암호화 비밀번호
  • name — VARCHAR(80) — NOT NULL — 이름
  • email — VARCHAR(150) — NOT NULL — 이메일
  • phone — VARCHAR(30) — 전화번호
  • affiliate_id — BIGINT — Foreign key → affiliates.affiliate_id — NOT NULL — 계열사 ID
  • department_id — BIGINT — Foreign key → departments.department_id — NOT NULL — 부서 ID
  • team_id — BIGINT — Foreign key → teams.team_id — 팀 ID
  • position_id — BIGINT — Foreign key → positions.position_id — 직급 ID
  • job_id — BIGINT — Foreign key → jobs.job_id — 직무 ID
  • role_id — BIGINT — Foreign key → roles.role_id — NOT NULL — 역할 ID
  • account_status — ENUM('ACTIVE', 'INACTIVE', 'LOCKED', 'PENDING_PASSWORD_CHANGE') — NOT NULL — 계정 상태
  • is_initial_password — TINYINT(1) — NOT NULL — 초기 비밀번호 여부
  • is_system_protected — TINYINT(1) — NOT NULL — 최소 Master 보호 계정 여부
  • active_from — DATE — 계정 활성 시작일
  • active_until — DATE — 계정 활성 종료일
  • last_login_at — DATETIME
  • created_by — BIGINT — Foreign key → users.user_id — 생성 관리자 ID
  • updated_by — BIGINT — Foreign key → users.user_id — 수정 관리자 ID
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

workspace_backups

  • workspace_backup_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • source_type — ENUM('MAIL', 'MEETING_MINUTES', 'MEETING_FILE', 'DRIVE_FILE', 'ETC') — NOT NULL
  • source_id — BIGINT — 원본 데이터 ID. 다형 참조라 FK 미적용
  • title — VARCHAR(255) — NOT NULL
  • content_snapshot — LONGTEXT
  • file_id — BIGINT — Foreign key → file_assets.file_id
  • backup_method — ENUM('MANUAL', 'AUTO') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • FULLTEXT — KEY

workspace_bookmarks

  • workspace_bookmark_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • workspace_backup_id — BIGINT — Foreign key → workspace_backups.workspace_backup_id — NOT NULL
  • created_at — DATETIME — NOT NULL