Chat

Tables (4)

Message

  • message_datetime — DATETIME
  • message_text — TEXT
  • Key (message_chat_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (message_user_id) — INT — Foreign key → Untitled.Key — NOT NULL

Untitled (chat_room)

  • Key (chat_room_id) — INT — Primary key — NOT NULL
  • Field (chat_room_title) — VARCHAR
  • Field (chat_room_address) — VARCHAR

Untitled (user)

  • Key (user_id) — INT — Primary key — NOT NULL
  • Field (user_password) — VARCHAR
  • Field (user_login_id) — VARCHAR

Untitled (chat_room_user)

  • Key (chat_room_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — INT — Foreign key → Untitled.Key — NOT NULL