SNS DB

Tables (3)

chat room (채팅방)

  • Chat Room (chat_id) — int — Primary key — NOT NULL
  • User id (user_id) — int
  • Message (message_id) — int
  • People Number (number) — int
  • Room name (room_name) — VARCHAR(20)

message (메시지 내용)

  • Message Id (message_id) — int — Primary key — NOT NULL
  • User Id (user_id) — int
  • Message Content (messasge_content) — VARCAHR(255)

user (사용자 정보)

  • User_id (user_id) — int — Primary key — NOT NULL
  • User name (user_name) — VARCHAR(20)
  • User email (user_email) — VARCHAR(255)