karokaro

Tables (5)

message_deletions

  • id (id2) — BIGINT — Foreign key → messages.메세지아이디 — NOT NULL
  • 메세지아이디 (message_id) — BIGINT — NOT NULL
  • 유저아이디 (user_id) — BIGINT — NOT NULL
  • 삭제시점 (deleted_at) — DATETIME

messages

  • 메세지아이디 (id) — BIGINT — Primary key — NOT NULL
  • 채팅방아이디 (room_id) — BIGINT — Foreign key — NOT NULL
  • 보내는사람 (sender_id) — BIGINT — Foreign key — NOT NULL
  • 내용 (content) — TEXT — NOT NULL
  • is_deleted_for_all — TINYINT(1) — NOT NULL
  • created_at — DATETIME

room_members

  • 방생성아이디 (id) — BIGINT — Primary key — NOT NULL
  • 채팅방아이디 (room_id) — BIGINT — Foreign key — NOT NULL
  • 유저아이디 (user_id) — BIGINT — Foreign key — NOT NULL
  • 생성 날짜 (joined_at) — DATETIME
  • 메세지 아이디 (last_read_message_id) — BIGINT — Foreign key → messages.메세지아이디

rooms

  • 채팅방아이디 (id) — BIGINT — Primary key — NOT NULL
  • 방이름 (name) — VARCHAR(100) — NOT NULL
  • 타입 (type) — ENUM('PRIVATE', 'GROUP') — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE') — NOT NULL
  • created_at — DATETIME

users

  • 유저아이디 (id) — BIGINT — Primary key — NOT NULL
  • 이메일 (email) — VARCHAR(100) — NOT NULL
  • 비밀번호 (password) — VARCHAR(255) — NOT NULL
  • 이름 (name) — VARCHAR(50) — NOT NULL
  • 생일 (birth_date) — DATE
  • 전화번호 (phone) — VARCHAR(20)
  • 프로필사진 (profile_image_url) — VARCHAR(500)
  • 생성일자 (created_at) — DATETIME
  • 수정일자 (updated_at) — DATETIME