Chatting

Tables (4)

ChattingList (채팅리스트)

  • ChattingList_ID (Key) — Int — Primary key — NOT NULL
  • ID (Key2) — Int — Foreign key → User.ID — NOT NULL
  • ChattingRoom_ID (Key3) — Int — Foreign key → ChattingRoom.ChattingRoom_ID — NOT NULL

ChattingMessage (채팅메시지)

  • ChattingMessage_ID (Key) — Int — Primary key — NOT NULL
  • ID (Key2) — Int — Foreign key → User.ID — NOT NULL
  • ChattingRoom_ID (Key3) — Int — Foreign key → ChattingRoom.ChattingRoom_ID — NOT NULL
  • Content (메시지 내용) — VARCHAR
  • Date (보낸 시간)

ChattingRoom (Chatting)

  • ChattingRoom_ID (Key) — Int — Primary key — NOT NULL
  • ChattingName (채팅방 이름) — VCARCHAR

User (유저)

  • ID (Key) — Int — Primary key — NOT NULL
  • Name (이름) — VARCHAR
  • NickName (닉네임) — VARCHAR
  • PassWord (비밀번호) — VARCHAR