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)