chat

Tables (8)

chat_room

  • chat_room_id — UUID
  • name — VARCHAR(255) — NOT NULL
  • project_id — UUID — NOT NULL
  • leader_id — UUID — NOT NULL
  • last_message_id — UUID
  • last_message_time — TIMESTAMP
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

chat_room_member

  • chat_room_member_id — UUID
  • chat_room_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • last_read_message_id — UUID
  • last_read_time — TIMESTAMP
  • unread_count — INTEGER
  • is_active — BOOLEAN
  • joined_at — TIMESTAMP
  • left_at — TIMESTAMP
  • notification_enabled — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(chat_room_id, — user_id)

message

  • message_id — UUID
  • chat_room_id — UUID — NOT NULL
  • sender_id — UUID — NOT NULL
  • message_type — VARCHAR(20) — NOT NULL
  • content — TEXT
  • file_url — TEXT
  • file_name — VARCHAR(255)
  • file_size — BIGINT
  • image_url — TEXT
  • system_type — VARCHAR(20)
  • system_target_user_id — UUID
  • translated_text — TEXT
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP

message_read_status

  • message_read_status_id — UUID
  • message_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • read_at — TIMESTAMP
  • UNIQUE(message_id, — user_id)

project

  • project_id — UUID
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • leader_id — UUID — NOT NULL
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

project_member

  • project_member_id — UUID
  • project_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • joined_at — TIMESTAMP
  • UNIQUE(project_id, — user_id)

typing_status

  • typing_status_id — UUID
  • chat_room_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • is_typing — BOOLEAN
  • last_updated — TIMESTAMP
  • UNIQUE(chat_room_id, — user_id)

user

  • user_id — UUID
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • profile_image_url — TEXT
  • current_language — VARCHAR(10)
  • is_online — BOOLEAN
  • last_seen — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP