chat

Tables (4)

Chat (채팅)

  • 아이디 (chat_id) — not null — Primary key — NOT NULL
  • 아이디 (chatroom_id) — not null — Foreign key → ChatRoom.아이디 — NOT NULL
  • 아이디 (memrber_id) — not null — Foreign key → Member.아이디 — NOT NULL
  • 채팅 (chat_body) — not null
  • 생성일자 (created_date) — not null
  • 수정일자 (updated_date) — not null

ChatRoom (채팅방)

  • 아이디 (chatroom_id) — not null — Primary key — NOT NULL
  • 방이름 (chatroom_name) — not null
  • 생성일자 (created_date) — not null
  • 수정일자 (updated_date) — not null

Member (멤버)

  • 아이디 (memrber_id) — not null — Primary key — NOT NULL
  • 이메일 (email) — not null
  • 비밀번호 (password) — not null
  • 닉네임 (nickname) — not null
  • 프로필 사진 (profile_url) — not null
  • 매너온도 (manner) — not null
  • 생성일자 (created_date) — not null
  • 수정일자 (updated_date) — not null

MemberChatRoom (Untitled)

  • Key — Primary key — NOT NULL
  • 아이디 (memrber_id) — not null — Foreign key → Member.아이디 — NOT NULL
  • 아이디 (chatroom_id) — not null — Foreign key → ChatRoom.아이디 — NOT NULL
  • 멤버 수 (member_count) — not null