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