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