team

Tables (3)

Invitation (Untitled3)

  • id (초대ID) — PK — Primary key — NOT NULL
  • team_id (초대가 이루어진 팀ID) — FK
  • inviter (초대를 보낸 사용자ID) — FK
  • invitee (초대받은 사용자ID) — FK

Userset (Untitled2)

  • id (사용자ID) — PK — Primary key — NOT NULL
  • team_id (팀ID) — FK — Foreign key → team.team_id — NOT NULL
  • username (팀원이름) — Not Null
  • email (팀원이메일) — Not Null
  • password (팀원비밀번호) — Not Null
  • authority (사용자의 권한)

team (Untitled)

  • team_id (팀ID) — PK — Primary key — NOT NULL
  • name (팀명) — Not Null
  • projectName (프로젝트명) — Not Null
  • description (팀설명) — Not Null