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) — 순서