grouptodo

Tables (7)

BaseEntity (Untitled7)

  • createdAt (Field)
  • updatedAt (Field2)

RefreshToken (Untitled5)

  • refreshToken_id (Key) — Primary key — NOT NULL
  • username (Field)
  • token (Field2)
  • expiration (Field3)

group (Untitled2)

  • group_id (Key) — Primary key — NOT NULL
  • groupName (Field)
  • description (Field2)
  • scope (Field4) — personal/public/private
  • category (Field5) — enum
  • image_url (Field6)

groupUser (Untitled3)

  • groupUserId (Key) — Primary key — NOT NULL
  • role (Field) — 그룹별 role
  • nickname (Field2)
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • group_id (Key3) — Foreign key → group.group_id — NOT NULL

todo (Untitled4)

  • todo_id (Key) — Primary key — NOT NULL
  • content (Field)
  • group_id (Key2) — Foreign key → group.group_id — NOT NULL
  • type (Field3)
  • assigned (Key3) — 공유일때 주인 — Foreign key → user.user_id — NOT NULL
  • startDate (Field2)
  • dueDate (Field4)

user (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • nickname (Field2)
  • role (Field4)
  • image_url (Field5)
  • emal (Field3)
  • provider (Field6)
  • providerId (Field)

userTodo (Untitled6)

  • id — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • todo_id (Key3) — Foreign key → todo.todo_id — NOT NULL
  • date (Field)
  • completed (Field2)
  • completed_at (Field3)