웹 챗

테이블 (6)

chat_rooms

  • room_id — bigint — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • is_active — bit(1) — NOT NULL
  • max_participants — int — NOT NULL
  • name — varchar(255)
  • password — varchar(255)
  • room_type — enum('PRIVATE_CHAT','PROTECTED_GROUP','PUBLIC_GROUP') — NOT NULL

friendships

  • friendship_id — bigint — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • status — enum('ACCEPTED','BLOCKED','PENDING')
  • from_user_idx — bigint — 외래 키 → users.user_idx
  • to_user_idx — bigint — 외래 키 → users.user_idx

message_attachments

  • id — bigint — 기본 키 — NOT NULL
  • name — varchar(255)
  • type — varchar(255)
  • url — varchar(255)
  • message_id — bigint — 외래 키 → messages.message_id

messages

  • message_id — bigint — 기본 키 — NOT NULL
  • content — varchar(255) — NOT NULL
  • created_at — datetime(6)
  • expires_at — datetime(6)
  • room_id — bigint — 외래 키 → chat_rooms.room_id
  • sender_id — bigint — 외래 키 → users.user_idx

room_participants

  • participant_id — bigint — 기본 키 — NOT NULL
  • joined_at — datetime(6)
  • last_read_time — datetime(6)
  • room_id — bigint — 외래 키 → chat_rooms.room_id
  • user_idx — bigint — 외래 키 → users.user_idx

users

  • user_idx — bigint — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • email — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • password — varchar(255)
  • user_id — varchar(255) — NOT NULL