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