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)