메신저 SW 테이블 구조도
테이블 (12)
audit_logs
- log_id — VARCHAR — 기본 키 — NOT NULL
- user_id — VARCHAR
- action — VARCHAR — NOT NULL
- resource_type — VARCHAR
- resource_id — VARCHAR
- details — TEXT
- ip_address — VARCHAR
- user_agent — VARCHAR
- result — VARCHAR — NOT NULL
- created_at — TIMESTAMP
conversation_members
- conversation_id — VARCHAR — 기본 키 — NOT NULL
- user_id — VARCHAR — 기본 키 — NOT NULL
- role — VARCHAR — NOT NULL
- joined_at — TIMESTAMP
- last_read_message_id — VARCHAR
- is_pinned — BOOLEAN
conversations
- conversation_id — VARCHAR — 기본 키 — NOT NULL
- type — VARCHAR — NOT NULL
- title — VARCHAR
- created_by — VARCHAR — NOT NULL
- notice — TEXT
- secret_key_hint — VARCHAR
- ttl_minutes — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
favorites
- favorite_id — VARCHAR — 기본 키 — NOT NULL
- user_id — VARCHAR — NOT NULL
- target_type — VARCHAR — NOT NULL
- target_id — VARCHAR — NOT NULL
- created_at — TIMESTAMP
files
- file_id — VARCHAR — 기본 키 — NOT NULL
- owner_user_id — VARCHAR — NOT NULL
- original_name — VARCHAR — NOT NULL
- mime_type — VARCHAR — NOT NULL
- size_bytes — INT — NOT NULL
- sha256 — VARCHAR — NOT NULL
- scan_status — VARCHAR — NOT NULL
- object_key — VARCHAR — NOT NULL
- created_at — TIMESTAMP
message_deletes
- message_id — VARCHAR — 기본 키 — NOT NULL
- user_id — VARCHAR — 기본 키 — NOT NULL
- deleted_at — TIMESTAMP
message_reactions
- message_id — VARCHAR — 기본 키 — NOT NULL
- user_id — VARCHAR — 기본 키 — NOT NULL
- emoji — VARCHAR — NOT NULL
- created_at — TIMESTAMP
message_receipts
- message_id — VARCHAR — 기본 키 — NOT NULL
- user_id — VARCHAR — 기본 키 — NOT NULL
- read_at — TIMESTAMP
messages
- message_id — VARCHAR — 기본 키 — NOT NULL
- conversation_id — VARCHAR — NOT NULL
- sender_user_id — VARCHAR — NOT NULL
- type — VARCHAR — NOT NULL
- body_text — TEXT
- attachment_file_id — VARCHAR
- reply_to_message_id — VARCHAR
- recalled_at — TIMESTAMP
- expired_at — TIMESTAMP
- is_notice — BOOLEAN
- created_at — TIMESTAMP
org_units
- org_unit_id — VARCHAR — 기본 키 — NOT NULL
- name — VARCHAR — NOT NULL
- parent_id — VARCHAR
- sort_order — INT
- created_at — TIMESTAMP
sessions
- session_id — VARCHAR — 기본 키 — NOT NULL
- user_id — VARCHAR — NOT NULL
- access_token — VARCHAR — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP
users
- user_id — VARCHAR — 기본 키 — NOT NULL
- display_name — VARCHAR — NOT NULL
- org_unit_id — VARCHAR
- rank_title — VARCHAR
- status — VARCHAR
- created_at — TIMESTAMP
- updated_at — TIMESTAMP