Database

Behind the scences all the data is being stored inside the sqlite database file thermal.sqlite.

Structure

SQLite database have multiple sub-tables in which based on the table name the information is stored.

• Repository
• Git
• Settings
• Git commands

repository

Name	Data type	Primary key	Not null
repositoryId	INTEGER	true
directoryPath	VARCHAR(150)	false	NOT NULL

gitRepository

Name	Data type	Primary key	Not null
gitId	INTEGER	true
isGit	INTEGER	false	NOT NULL
remoteUrl	VARCHAR(200)	false
activeBranch	VARCHAR(50)	false
repositoryId	INTEGER	false	NOT NULL

NOTE: repositoryId column from gitRepository is linked with repositoryId column from repository table.

FOREIGN KEY(repositoryId) REFERENCES repository(repositoryId)

repositorySettings

Name	Data type	Primary key	Not null
settingsId	INTEGER	true
repositoryName	VARCHAR(30)	false	NOT NULL
description	VARCHAR(200)	false
source	VARCHAR(15)	false	NOT NULL
directoryName	VARCHAR(30)	false	NOT NULL
commitFeature	INTEGER	false	NOT NULL
remoteFeature	INTEGER	false	NOT NULL
repositoryId	INTEGER	false	NOT NULL

NOTE: repositoryId column from repositorySettings is linked with repositoryId column from repository table.

FOREIGN KEY(repositoryId) REFERENCES repository(repositoryId)

gitCommands

NOTE: We are still experimenting with this feature.

Name	Data type	Primary key	Not null
commandId	INTEGER	true
icon	VARCHAR(2)	false	NOT NULL
command	VARCHAR(200)	false	NOT NULL
path	VARCHAR(150)	false	NOT NULL
created	TIMESTAMP	false