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