AIchat

Tables (5)

chat (Chat)

  • PK (chat_id) — BIGINT — Primary key — NOT NULL
  • 보낸사람(FK) (sender_id) — BIGINT — Foreign key → member.PK — NOT NULL
  • 채팅방(FK) (room_id) — BIGINT — Foreign key → room.PK — NOT NULL
  • 내용 (content) — VARCHAR
  • created_at — DATETIME

member (Member)

  • PK (member_id) — BIGINT — Primary key — NOT NULL
  • 팀(FK) (team_id) — BIGINT — Foreign key → team.PK — NOT NULL
  • 이메일 (email) — VARCHAR
  • 닉네임 (nickname) — VARCHAR
  • 비밀번호 (password) — VARCHAR

room (Room)

  • PK (room_id) — BIGINT — Primary key — NOT NULL
  • 이름 (room_name) — VARCHAR

roomMember (RoomMember)

  • PK (room_member_id) — BIGINT — Primary key — NOT NULL
  • 채팅방(FK) (room_id) — BIGINT — Foreign key → room.PK — NOT NULL
  • 멤버(FK) (member_id) — BIGINT — Foreign key → member.PK — NOT NULL

team (Team)

  • PK (team_id) — BIGINT — Primary key — NOT NULL
  • 이름 (team_name) — VARCHAR