myTask
Tables (7)
GitHubOAuth (Untitled)
- GitHub OAuth ID (id) — int — Primary key — NOT NULL
- User ID (user_id) — int — Foreign key → User.User ID — 각 사용자를 구분할 id값
GoogleOAuth (Untitled7)
- Google OAuth ID (id) — int — Primary key — NOT NULL
- User ID (user_id) — int — Foreign key → User.User ID — 각 사용자를 구분할 id값
Group (Untitled2)
- Group ID (id) — int — Primary key — NOT NULL
- Group Name (name) — char[20]
- is private (is_private) — boolean
Member (Untitled3)
- ID (id) — int — Primary key — NOT NULL
- User ID (user_id) — int — Foreign key → User.User ID — 각 사용자를 구분할 id값
- Group ID (group_id) — int — Foreign key → Group.Group ID — NOT NULL
- Is Manager (is_manager) — boolean
Project (Untitled5)
- Project ID (id) — int — Primary key — NOT NULL
- Group ID (group_id) — int — Foreign key → Group.Group ID — NOT NULL
- Project Name (name) — char[20]
Task (Untitled4)
- Task ID (id) — int — Primary key — NOT NULL
- Project ID (project_id) — int — Foreign key → Project.Project ID — NOT NULL
- Parent Task ID (parent_id) — int — Foreign key → Task.Task ID — NOT NULL
- Task Name (name) — char[20]
- Task State (state) — char[10]
- Task Description File (description) — char[20]
- Assignee ID (assignee_id) — int — Foreign key → Member.Group ID — NOT NULL
User
- User ID (id) — int — Primary key — 각 사용자를 구분할 id값
- Username (username) — char[20]
- E-mail (email) — char[320]