Todo App
Tables (4)
Categories (categories)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(50)
- color (Field2) — varchar(7)
Reminders (reminders)
- id (Key) — int — Primary key — NOT NULL
- todo_id (Key2) — int — Foreign key → Todo.id — NOT NULL
- reminder_time (Field) — datetime
- message (Field2) — varchar(50)
- created_at (Field3) — timestamp
Todo (todo)
- id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — int — Foreign key → User.id — NOT NULL
- category_id (Key3) — int — Foreign key → Categories.id — NOT NULL
- title (Field) — varchar(50)
- start_date (Field2) — datetime
- Field3 — datetime
- memo (Field4) — varchar(100)
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- is_completed (Field8) — boolean
User (user)
- id (Key) — int — Primary key — NOT NULL
- email (Field) — varchar(50)
- password (Field2) — varchar(50)
- name (Field3) — varchar(10)
- created_at (Field4) — timestamp
- completed_todos (Field5) — int