GitalkERD
Tables (7)
chat_room_members (채팅방멤버)
- id (채팅방멤버 id) — Primary key — NOT NULL
- userId (유저 아이디) — BIGINT — Foreign key → users.userid — NOT NULL
- roomId (채팅방 아이디) — Foreign key → chat_rooms.roomid — NOT NULL
chat_rooms (채팅방)
- roomid (채팅방 아이디) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- type — ENUM('TEAM', 'OPEN') — NOT NULL
- created_at — TIMESTAMP
- teamgiturl (팀 레포 URL)
chatroom_topics
- id (Key) — Primary key — NOT NULL
- topicid (토픽 아이디) — Foreign key → topics.topicid — NOT NULL
- roomid (채팅방 아이디) — Foreign key → chat_rooms.roomid — NOT NULL
messages
- messageid (메세지 아이디) — Primary key — NOT NULL
- userid (유저 아이디) — BIGINT — Foreign key → users.userid — NOT NULL
- roomid (채팅방 아이디) — Foreign key → chat_rooms.roomid — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
notices (공지)
- noticeid (공지 아이디) — Primary key — NOT NULL
- userid (유저 아이디) — BIGINT — Foreign key → users.userid — NOT NULL
- roomid (채팅방 아이디) — Foreign key → chat_rooms.roomid — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
topics
- topicid (토픽 아이디) — Primary key — NOT NULL
- topicname (토픽명) — VARCHAR(100) — NOT NULL
users (유저)
- userid (유저 아이디) — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255)
- password — VARCHAR(255)
- nickname — VARCHAR(100) — NOT NULL
- githuburl (깃허브 주소) — VARCHAR(100)
- type (로그인 타입) — {로컬, 깃허브}
- created_at — TIMESTAMP