Database Model - Revision history

Atlioddsson at 21:06, 14 April 2011

2011-04-14T21:06:40Z

Atlioddsson at 20:24, 15 September 2009

2009-09-15T20:24:53Z

Atlioddsson: /* Flag */

2009-03-29T13:03:12Z

Flag

Atlioddsson: /* Flag */

2009-03-29T13:02:41Z

Flag

Atlioddsson: /* Flag */

2009-03-29T13:02:21Z

Flag

Atlioddsson at 13:01, 29 March 2009

2009-03-29T13:01:39Z

Atlioddsson at 12:58, 29 March 2009

2009-03-29T12:58:47Z

Atlioddsson at 12:58, 29 March 2009

2009-03-29T12:58:30Z

Atlioddsson at 12:06, 29 March 2009

2009-03-29T12:06:11Z

Atlioddsson: /* Activity */

2009-03-29T10:55:53Z

Activity

@@ Line 21: / Line 21: @@
      PWDID           INTEGER,
      URL             VARCHAR(1000),
-     WEBPROGID       INTEGER
+     WEBPROGID       INTEGER,
    );
 </source>

← Older revision		Revision as of 20:24, 15 September 2009
Line 1:		Line 1:
	TimeSnapper has an open database model but we reserve the rights to make changes at any time without any notice!		TimeSnapper has an open database model but we reserve the rights to make changes at any time without any notice!
		+
		+	We use Firebird as our database engine. It's very fast and mature and can be run embedded without any user interventions.

	= TimeSnapper Tables =		= TimeSnapper Tables =

@@ Line 54: / Line 54: @@
 == Flag ==
-* The [[flags]] are on the timeline/[[TimeBar]].
+The [[flags]] are on the timeline/[[TimeBar]].
 <source lang="sql">
 CREATE TABLE FLAG (

@@ Line 54: / Line 54: @@
 == Flag ==
-* The [[flags| Flags]] are on the timeline/[[TimeBar]].
+* The [[flags]] are on the timeline/[[TimeBar]].
 <source lang="sql">
 CREATE TABLE FLAG (

@@ Line 54: / Line 54: @@
 == Flag ==
-* The flags are on the timeline/[[TimeBar]].
+* The [[flags| Flags]] are on the timeline/[[TimeBar]].
 <source lang="sql">
 CREATE TABLE FLAG (

@@ Line 4: / Line 4: @@
 == Activity ==
-* Each screenshot that is taken has a lot of associated information.  This helps TimeSnapper to create interesting reports.
+Each screenshot that is taken has a lot of associated information.  This helps TimeSnapper to create interesting reports.
 <source lang="sql">
@@ Line 24: / Line 24: @@
 == Classification ==
-* List of programs and keywords that marks a screenshot as productive one.
+List of programs and keywords that marks a screenshot as productive one.
 <source lang="sql">
 CREATE TABLE CLASSIFICATION (
@@ Line 43: / Line 44: @@
 == Filters ==
-* Exclusion and inclusion filters.
+Exclusion and inclusion [[filters|Filters]].
 <source lang="sql">
 CREATE TABLE FILTERS (
@@ Line 71: / Line 72: @@
 == Options ==
-* This is where TimeSnapper stores all its options, e.g. interval, screens to capture, window location and sizes and more.  Plugins can use this as well.
+This is where TimeSnapper stores all its options, e.g. interval, screens to capture, window location and sizes and more.  Plugins can use this as well.
 <source lang="sql">
 CREATE TABLE OPTIONS (
@@ Line 80: / Line 82: @@
 == Program ==
-* Some basic information about each program that has been captured.  Web pages are also considered an application so they get their own entry here (and ProgType = 1).
+Some basic information about each program that has been captured.  Web pages are also considered an application so they get their own entry here (and ProgType = 1).
 <source lang="sql">
 CREATE TABLE PROGRAM (
@@ Line 93: / Line 96: @@
 == Pwd ==
-* No worries, we don't store any passwords here.  Just the hash of the password.  This table is used to know if the user has entered the correct password for decrypting an image.
+No worries, we don't store any passwords here.  Just the hash of the password.  This table is used to know if the user has entered the correct password for decrypting an image.
-* This table can contain multiple entries because images encrypted with an old password don't get decrypted and encrypted back when a new password is entered.
 <source lang="sql">
@@ Line 104: / Line 108: @@
 == Scorecardvalues ==
-* Table for storing the scores in the scorecard for a particular day.
+Table for storing the scores in the scorecard for a particular day.
-* This table gets truncated every time a new program or new caption is marked as productive (because a recalculation is needed).
+This table gets truncated every time a new program or new caption is marked as productive (because a recalculation is needed).
 <source lang="sql">
@@ Line 116: / Line 120: @@
 == Time_spent ==
-* Number of minutes spent in front of the computer per day
+Number of minutes spent in front of the computer per day.  This is an optimization table was added to help with reporting.
 <source lang="sql">
 CREATE TABLE TIME_SPENT (

@@ Line 1: / Line 1: @@
 TimeSnapper has an open database model but we reserve the rights to make changes at any time without any notice!
 == Activity ==
 == Classification ==
 == Cloudwords ==