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]