Daily
Tables (6)
Chat_List (친구목록)
- List_index (리스트인덱스) — INT — Primary key — NOT NULL
- friend_id (친구아이디) — char(15)
- friend_name (친구이름) — varchar(10)
- user_id (아이디) — char(15) — Foreign key → User.user_id — NOT NULL
Chatting (채팅내용)
- chatting_index (Key) — Primary key — NOT NULL
- UserID (유저아이디) — char(15)
- UserChatting (유저채팅) — TEXT
- chat_Num (채팅방번호) — INT — Foreign key → Rooms.chat_Num — NOT NULL
Chatting_User (채팅인원)
- Room_User (인덱스) — INT — Primary key — NOT NULL
- User_ID (유저아이디) — char(15)
- User_Name (유저이름) — varchar(10)
- chat_Num (채팅방번호) — INT — Foreign key → Rooms.chat_Num — NOT NULL
Rooms (채팅목록)
- chat_Num (채팅방번호) — INT — Primary key — NOT NULL
- Room_Name (채팅방이름) — vchar(20)
- Room_member (채팅인원) — INT
User (유저)
- user_id (아이디) — char(15) — Primary key — NOT NULL
- Name (이름) — vchar(10)
- Passwrod (패스워드) — char(20)
userCheck (유저체크)
- Login_id (로그인아이디) — char(15) — Primary key — NOT NULL