TeamFlow
Tables (11)
Calendars (Untitled2)
- calendarId (Key) — int — Primary key — NOT NULL
- userId (Field) — int
- teamId (Field2) — int
- calendarType (team or personal) — string
- userid (Key2) — int — Foreign key → User.userid — NOT NULL
- teamId (Key3) — int — Foreign key → Team.teamId — NOT NULL
ChannelParticipants (Untitled6)
- id (Key) — int — Primary key — NOT NULL
- channelId (Field) — int
- userId (Field2) — int
- channelId (Key2) — int — Foreign key → Channels.channelId — NOT NULL
Channels (Untitled5)
- channelId (Key) — int — Primary key — NOT NULL
- chaeenlName (Field) — string
- teamId (Field2) — int
- channelType (team or direct) — string
- teamId (Key2) — int — Foreign key → Team.teamId — NOT NULL
Events (Untitled11)
- eventId (Key) — int — Primary key — NOT NULL
- calendarId (Field) — int
- eventTitle (Field2) — string
- startTime (Field3) — int
- endTime (Field4) — int
- eventColor (Field5) — string
- year (Field6) — date
- month (Field7) — date
- day (Field8)
- calendarId (Key2) — int — Foreign key → Calendars.calendarId — NOT NULL
Files (Untitled8)
- fileId (Key) — int — Primary key — NOT NULL
- channelId (Field) — int
- messageId (Field2) — int
- fileName (Field3) — string
- filePath (Field4) — string
- fileType (Field5) — string
- fileSize (Field6) — int
- channelId (Key2) — int — Foreign key → Channels.channelId — NOT NULL
- messageId (Key3) — int — Foreign key → Messages.messageId — NOT NULL
MeetingLogs (Untitled9)
- logId (Key) — int — Primary key — NOT NULL
- teamId (Field) — int
- logText (Field2) — string
- audioPath (Field3) — string
- timestamp (Field4) — int
- teamId (Key2) — int — Foreign key → Team.teamId — NOT NULL
Messages (Untitled7)
- messageId (Key) — int — Primary key — NOT NULL
- channelId (Field) — int
- userId (Field2) — int
- content (Field3) — string
- messageType (Field4) — string
- timestamp (Field5) — int
- channelId (Key2) — int — Foreign key → Channels.channelId — NOT NULL
- userid (Key3) — int — Foreign key → User.userid — NOT NULL
Summaries (Untitled10)
- summaryId (Key) — int — Primary key — NOT NULL
- logId (Field) — int
- summaryText (Field2) — sting
- timestamp (Field3) — int
- logId (Key2) — int — Foreign key → MeetingLogs.logId — NOT NULL
Team (Untitled3)
- teamId (Key) — int — Primary key — NOT NULL
- teamName (Field) — string
- teamColor (Field2) — string
- userid (Key2) — int — Foreign key → User.userid — NOT NULL
TeamMembers (Untitled4)
- id (Key) — int — Primary key — NOT NULL
- teamId (Field) — int
- userId (Field2) — int
- role (Field3) — string
- memberColor (Field4) — string
- teamId (Key2) — int — Foreign key → Team.teamId — NOT NULL
User (Untitled)
- userid (Key) — int — Primary key — NOT NULL
- username (Field2) — string
- password (Field3) — string
- email (Field) — string
- position (Field4) — string
- contactTime (Field5) — string
- myTeam (Field6) — list
- profile (Field7) — string