my-todo-list
Tables (4)
Category (Untitled3)
- c_idx (Key) — int — Primary key — NOT NULL
- u_idx (Key2) — int — Foreign key → User.u_idx — NOT NULL
- c_name (Field) — varchar
- c_color (Field2) — varchar
Task (Untitled2)
- t_idx (Key) — int — Primary key — NOT NULL
- u_idx (Key2) — int — Foreign key → User.u_idx — NOT NULL
- title (Field2) — varchar
- description (Field3) — varchar
- due_date (Field4) — datetime
- status (Field5) — varchar
- created_at (Field6) — datetime
- updated_at (Field7) — datetime
TaskCategory (Untitled4)
- tc_idx (Key) — int — Primary key — NOT NULL
User (Untitled)
- u_idx (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
- email (Field2) — varchar
- password (Field3) — varchar
- created_at (Field4) — datetime
- Field5