logo
ExamplesEditorPricingDocs
37.1kSign in

Habit tracker app database schema

A small local-first SQLite schema for habit tracking: habits with date-versioned schedules, one row per completion, pauses that skip a streak instead of breaking it, reminders, and streaks derived from check-ins rather than stored as a counter.

Habit Tracker ER diagram

Habit tracker app database schema n1 n1 n1 n1 n1 n1 n1 n1 11 users idINTEGER nameTEXT timezoneTEXT day_start_offset_…INTEGER week_starts_onINTEGER created_atTIMESTAMP categories idINTEGER user_idINTEGER nameTEXT colorTEXT positionINTEGER habits idINTEGER user_idINTEGER category_idINTEGER nameTEXT descriptionTEXT kindTEXT target_amountREAL unitTEXT is_archivedBOOLEAN started_onDATE positionINTEGER created_atTIMESTAMP habit_schedules idINTEGER habit_idINTEGER rule_kindTEXT days_maskINTEGER target_countINTEGER interval_daysINTEGER effective_fromDATE effective_toDATE created_atTIMESTAMP check_ins idINTEGER habit_idINTEGER local_dateDATE occurrenceINTEGER amountREAL noteTEXT moodINTEGER completed_atTIMESTAMP pauses idINTEGER habit_idINTEGER starts_onDATE ends_onDATE reasonTEXT created_atTIMESTAMP reminders idINTEGER habit_idINTEGER remind_atTIME days_maskINTEGER is_enabledBOOLEAN skip_if_doneBOOLEAN created_atTIMESTAMP reminder_deliveries idINTEGER reminder_idINTEGER local_dateDATE fired_atTIMESTAMP outcomeTEXT streak_cache habit_idINTEGER current_streakINTEGER longest_streakINTEGER last_check_in_dateDATE total_check_insINTEGER computed_throughDATE computed_atTIMESTAMP

Related database schemas

SQLite
Productivity

Note-taking app database schema with backlinks

A local-first SQLite notes database: notebooks and notes, wiki-style backlinks parsed from note bodies into a link graph, tags, attachments, a full-text search index, revision history and last-writer-wins sync with a conflict record.

SQLite
Productivity

Password manager & encrypted vault database schema

A local-first SQLite vault where the secrets are ciphertext the database cannot read: vaults as key boundaries, encrypted item fields, blind indexes for the few searches that must still work, TOTP seeds, password history, sharing and an audit log.

PostgreSQL
Productivity

Calendar and scheduling database schema

How a calendar app models its data: calendars and sharing, events with their own time zones, RRULE recurrence with exception dates and per-occurrence overrides, attendees and RSVP, reminders, working hours and a free-busy index.

PostgreSQL
Productivity

Dropbox-style file storage & sync database schema

How a cloud drive models its data: a folder tree, versioned files, content-addressed blocks that deduplicate identical uploads to a single copy, shares and expiring public links, per-device sync cursors, trash retention and quota accounting.