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