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