sws_poc_chat_db

Tables (3)

Conversations (Untitled2)

  • 대화ID (ConversationID) — AUTO_INCREMENT — Primary key
  • 대화생성시간 (CreatedTimestamp) — DEFAULT CURRENT_TIMESTAMP

Messages (Untitled3)

  • 메세지ID (MessageID) — AUTO_INCREMENT — Primary key
  • 메세지내용 (MessageContent)
  • 메세지생성시간 (MessageTimestamp) — DEFAULT CURRENT_TIMESTAMP
  • 유저ID (UserID) — AUTO_INCREMENT — Foreign key → Users.유저ID
  • 대화ID (ConversationID) — AUTO_INCREMENT — Foreign key → Conversations.대화ID

Users (Untitled)

  • 유저ID (UserID) — AUTO_INCREMENT — Primary key
  • 유저이름 (Username) — NOT NULL