Home

Welcome to the Little-Things wiki!

Database Schema:

Table: Habits

Habit_Id INT PRIMARY KEY

Habit_Name VARCHAR(20) NOT NULL

Habit_TimeLimit INT NOT NULL // amount of time to spend on task

Habit_Freq INT NOT NULL // number of repetitions per day

User_Id INT FOREIGN KEY

Table: Users

User_Id INT PRIMARY KEY

User_Name VARCHAR(20) NOT NULL

User_Phrase VARCHAR(20) NOT NULL // catchphrase to get user motivated

Table: HabitCompletion

User_Id INT FOREIGN KEY

Habit_Id INT FOREIGN KEY

When_Last_Done TIMESTAMP var client = new MongoClient("mongodb+srv://admin:<password>@conversationstarter-dcvon.gcp.mongodb.net/test?retryWrites=true&w=majority"); var database = client.GetDatabase("test");