GitChat

GitChatERD

Tables (3)

Messages (messages)

  • messageId (message_id) — bigserial — Primary key — NOT NULL — Auto Increment
  • content — text — NOT NULL
  • timpstamp (Field) — NOT NULL
  • isDeleted (is_deleted) — boolean — NOT NULL
  • userId (user_id) — serial — Foreign key → Users.userId — NOT NULL — Auto Increment
  • roomId (room_id) — serial — Foreign key → chatRooms.roomId — NOT NULL — Auto Increment

Users (users)

  • userId (user_id) — serial — Primary key — NOT NULL — Auto Increment
  • githubId (github_id) — varchar(255) — NOT NULL — unique
  • githubUsername (github_username) — varchar(255) — NOT NULL — unique
  • profilePictureURL (profile_picture_url) — varchar(255) — NOT NULL

chatRooms (chat_rooms)

  • roomId (room_id) — serial — Primary key — NOT NULL — Auto Increment
  • roomName (room_name) — varchar(255) — NOT NULL