GDG-10TEAM
Tables (5)
Untitled (Category)
- Key (seq) — Integer — Primary key — NOT NULL
- Field (name) — NOT NULL
Untitled (user_task)
- Key (user_seq) — Integer — Foreign key → user.Key — NOT NULL
- seq (task_seq) — NOT NULL — Foreign key → task.seq — NOT NULL
- Field (frequency)
- Field (start_date)
- Field (end_date)
task (Task)
- seq — Primary key — NOT NULL
- name — NOT NULL
- Key (category_seq) — Foreign key → Untitled.Key — NOT NULL
todolist (task_history)
- Key (seq) — Primary key — NOT NULL
- seq (task_seq) — NOT NULL — Foreign key → task.seq — NOT NULL
- Key (user_seq) — Foreign key → user.Key — NOT NULL
- Field (image_url)
- Field (start_date) — NOT NULL
- Field (end_date)
- Field (is_finish) — default = false
- Field (deleted_at) — default = null
user (User)
- Key (seq) — Primary key — NOT NULL
- Field (user_id)