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