Timo
Tables (7)
repeat_rules
- repeat_rule_id — BIGINT — Primary key — NOT NULL
- todo_id — BIGINT — Foreign key → todos.todo_id — NOT NULL
- frequency — VARCHAR(10) — NOT NULL
- day_of_week — TINYINT
- day_of_month — TINYINT
- end_date — DATE — NOT NULL
- Key — Foreign key — NOT NULL
subtasks
- subtask_id — BIGINT — Primary key — NOT NULL
- todo_id — BIGINT — Foreign key → todos.todo_id — NOT NULL
- title — VARCHAR(50) — NOT NULL
- estimated_minutes — INT
- completed_at — DATETIME
- Key — Foreign key — NOT NULL
tags
- tag_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id
- name — VARCHAR(20) — NOT NULL
- color_code — VARCHAR(7) — NOT NULL
- is_default — BOOLEAN — NOT NULL
- Key — Foreign key → users.google_id — NOT NULL
timer_records
- id — BIGINT — Primary key — NOT NULL
- todo_id — BIGINT — Foreign key → todos.todo_id — NOT NULL
- started_at — DATETIME — NOT NULL
- ended_at — DATETIME
- status — VARCHAR(20) — NOT NULL
- Key — Foreign key — NOT NULL
timer_sessions
- id — BIGINT — Primary key — NOT NULL
- timer_record_id — BIGINT — Foreign key → timer_records.id — NOT NULL
- started_at — DATETIME — NOT NULL
- paused_at — DATETIME
- Key — Foreign key → timer_records.Key — NOT NULL
todos
- todo_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- tag_id — BIGINT — Foreign key → tags.tag_id
- title — VARCHAR(25) — NOT NULL
- memo — VARCHAR(300)
- scheduled_date — DATE
- priority — VARCHAR(10)
- estimated_minutes — INT
- icon_type — VARCHAR(30)
- is_completed (Field) — Boolean — NOT NULL
- Key — Foreign key → users.google_id — NOT NULL
users
- google_id (Key) — VARCHAR(255) — Primary key — NOT NULL
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- profile_image_url — VARCHAR(2048)
- Field