CheckTeamMate ERD
테이블 (4)
과제 (Assignment)
- Assignment Key (assignment_key) — NOT NULL — 기본 키 — NOT NULL
- Assignment Title (assignment_title) — NOT NULL
- Team Key (team_key) — NOT NULL — 외래 키 → 팀.Team Key — NOT NULL
사용자 (User)
- User Email (user_email) — NOT NULL — 기본 키 — NOT NULL
- Password (password) — NOT NULL
- Name (name) — NULL
- Phone Number (phone_number) — NULL
체크 리스트 (Check)
- Assignment Key (assignment_key) — NOT NULL — 외래 키 → 과제.Assignment Key — NOT NULL
- User Email (user_email) — NOT NULL — 외래 키 → 사용자.User Email — NOT NULL
팀 (Team)
- Team Key (team_key) — NOT NULL — 기본 키 — NOT NULL
- Title (title)
- FileImage (fileImage)
- Reg (timestamp)
- Leader ID (leader_id)
- Member ID (member_id)
- Field