studyAuth

Tables (4)

Group (group)

  • Group Id (group_id) — INT — Primary key
  • Name (name) — VARCHAR
  • Code (code) — VARCHAR
  • Image (image) — VARCHAR

ToDo (todo)

  • Task Id (task_id) — INT — Primary key
  • User Id (user_id) — INT — Foreign key → User.User Id — NOT NULL
  • Group Id (group_id) — INT — Foreign key → Group.Group Id
  • CreatedAt (created_at) — DATE
  • FinishedAt (finished_at) — DATE
  • Date (date) — DATE
  • Plan (plan) — VARCHAR
  • Image (image) — VARCHAR

User (user)

  • User Id (user_id) — INT — Primary key — NOT NULL
  • Last Name (last_name) — VARCHAR
  • First Name (first_name) — VARCHAR
  • Email (email) — VARCHAR
  • Password (password) — VARCHAR
  • SignUpMethod (sighup_method) — varchar
  • DeletedAt (deleted_at) — DATE

UserGroup (user_group)

  • Id (id) — INT — Primary key
  • User Id (user_id) — INT — Foreign key → User.User Id — NOT NULL
  • Group Id (group_id) — INT — Foreign key → Group.Group Id
  • Role (role) — ENUM