Team Schema

The team schema manages team organization and membership.

Teams

teams {
  id: serial PRIMARY KEY
  name: varchar UNIQUE
  createdAt: timestamp DEFAULT now()
  updatedAt: timestamp DEFAULT now()
}

Team Membership

userTeams {
  userId: integer NOT NULL
  teamId: integer NOT NULL
  role: varchar
  createdAt: timestamp DEFAULT now()
  updatedAt: timestamp DEFAULT now()
  PRIMARY KEY (userId, teamId)
}

The team system enables collaborative work and access control across the platform.