Winter To Do
Tables (3)
subtask (Untitled2)
- subtask_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(n)
todo (Untitled)
- todo_id (Key) — int — Primary key — NOT NULL
- subtask_id (Key3) — int — Foreign key → subtask.subtask_id — NOT NULL
- type_id (Key2) — int — Foreign key → type.type_id — NOT NULL
- name (Field) — varchar(n)
- date (Field2) — date
- start_time (Field3) — timestamp
- end_time (Field4) — timestamp
- description (Field5) — varchar(n)
- type_id (Field6) — int
- subtask_id (Field7) — int
type (Untitled3)
- type_id (Key) — int — Primary key — NOT NULL
- todo_id (Key2) — int — Foreign key → todo.todo_id — NOT NULL
- name (Field) — varchar(n)