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