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)