메신저 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