16```
17โโโ backend/
18โ โโโ database/
19โ โ โโโ migrations.ts # Database schema setup
20โ โ โโโ queries.ts # Database query functions
21โ โโโ routes/
22โ โ โโโ habits.ts # Habit CRUD operations
54## Tech Stack
55
56- **Backend**: Hono.js with SQLite database
57- **Frontend**: React with TypeScript
58- **Styling**: TailwindCSS
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getLatestKPIs, getKPIHistory, createKPI } from "../database/queries.ts";
3import type { KPI } from "../../shared/types.ts";
4
7 updateFollowup,
8 getClientById
9} from "../database/queries.ts";
10import type { FollowUp } from "../../shared/types.ts";
11
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getAllClients, getClientById, createClient, updateClient } from "../database/queries.ts";
3import type { Client } from "../../shared/types.ts";
4
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getAllStaff, getStaffById, createStaff, updateStaff } from "../database/queries.ts";
3import type { Staff } from "../../shared/types.ts";
4
7 updateUserActivity,
8 getUserById
9} from "../database/queries.ts";
10import type { CreateMessageRequest } from "../../shared/types.ts";
11
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getAllTasks, getTasksByStaff, createTask, updateTask } from "../database/queries.ts";
3import type { Task } from "../../shared/types.ts";
4
6 getDiscussionById,
7 updateUserActivity
8} from "../database/queries.ts";
9import type { CreateDiscussionRequest } from "../../shared/types.ts";
10
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getCookie } from "https://esm.sh/hono@3.11.7/cookie";
3import { getOnlineUsers, getAllUsers, updateUserActivity } from "../database/queries.ts";
4
5const users = new Hono();
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getCookie, setCookie } from "https://esm.sh/hono@3.11.7/cookie";
3import { createUser, getUserByUsername, getUserById, updateUserActivity } from "../database/queries.ts";
4import type { LoginRequest } from "../../shared/types.ts";
5