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