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