Jroutine

Tables (6)

User (Untitled)

  • email (Key) — Primary key — NOT NULL
  • nickname (Field2)

routine (Untitled4)

  • routineId (Key3) — Primary key — NOT NULL — 유저 이메일 + 루틴명
  • categoryId (Key4) — Foreign key → routine-category.categoryId — NOT NULL — 유저 이메일+카테고리명
  • email (Key22) — Foreign key → routine-category.email — NOT NULL
  • name (Field)
  • done (Field2) — 루틴 완료 상태
  • memo (Field4)

routine-category (Untitled2)

  • categoryId (Key) — Primary key — NOT NULL — 유저 이메일+카테고리명
  • email (Key2) — Foreign key → User.email — NOT NULL
  • name (Field) — NOT NULL
  • color (Field2) — NOT NULL
  • desc (Field3)

tag (Untitled7)

  • tagId (Key3) — Primary key — NOT NULL — 유저 이메일 + 태그명
  • name (Field)
  • color (Field2)

todo (Untitled5)

  • todoId (Key) — Primary key — NOT NULL
  • categoryId (Key3) — Foreign key → todo-category.categoryId — 유저이메일 + 투두명
  • email (Key23) — Foreign key → todo-category.email — NOT NULL
  • name (Field)
  • done (Field2)
  • index (Field3) — 순서

todo-category (Untitled3)

  • categoryId (Key) — Primary key — NOT NULL — 유저이메일 + 투두명
  • email (Key2) — Foreign key → User.email — NOT NULL
  • category (Field)
  • index (Field2) — 순서