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