Difference between revisions of "Database Model"
From TimeSnapper
Atlioddsson (talk | contribs) |
Atlioddsson (talk | contribs) m |
||
Line 4: | Line 4: | ||
== Activity == | == Activity == | ||
+ | <source lang="sql"> | ||
+ | CREATE TABLE ACTIVITY ( | ||
+ | ID INTEGER NOT NULL, | ||
+ | SNAPDATE TIMESTAMP NOT NULL, | ||
+ | FILENAME VARCHAR(500), | ||
+ | FILESIZE INTEGER, | ||
+ | PROGRAM VARCHAR(100), | ||
+ | PROGRAMCAPTION VARCHAR(1000), | ||
+ | DURATION INTEGER, | ||
+ | CRC32 INTEGER, | ||
+ | PROGID INTEGER, | ||
+ | PWDID INTEGER, | ||
+ | URL VARCHAR(1000), | ||
+ | WEBPROGID INTEGER | ||
+ | ); | ||
+ | </source> | ||
== Classification == | == Classification == | ||
+ | <source lang="sql"> | ||
+ | CREATE TABLE CLASSIFICATION ( | ||
+ | ID INTEGER NOT NULL, | ||
+ | PROGID INTEGER, | ||
+ | KEYWORDS VARCHAR(500) | ||
+ | ); | ||
+ | </source> | ||
+ | |||
== Cloudwords == | == Cloudwords == | ||
+ | <source lang="sql"> | ||
+ | CREATE TABLE CLOUDWORDS ( | ||
+ | WORD VARCHAR(8000) NOT NULL, | ||
+ | WORDTYPE INTEGER NOT NULL, | ||
+ | TS_DEFAULT INTEGER | ||
+ | ); | ||
+ | </source> | ||
+ | |||
== Filters == | == Filters == | ||
+ | <source lang="sql"> | ||
+ | CREATE TABLE FILTERS ( | ||
+ | NAME VARCHAR(50) NOT NULL, | ||
+ | INCLUSIVE INTEGER NOT NULL, | ||
+ | CONDITIONS VARCHAR(8000) | ||
+ | ); | ||
+ | </source> | ||
+ | |||
== Flag == | == Flag == | ||
+ | <source lang="sql"> | ||
+ | CREATE TABLE FLAG ( | ||
+ | ID INTEGER NOT NULL, | ||
+ | FLAGDATE TIMESTAMP NOT NULL, | ||
+ | FLAGTYPE VARCHAR(20), | ||
+ | TEXT1 VARCHAR(250), | ||
+ | TEXT2 VARCHAR(250), | ||
+ | TEXT3 VARCHAR(250), | ||
+ | TEXT4 VARCHAR(250), | ||
+ | TEXT5 VARCHAR(250), | ||
+ | TEXT6 VARCHAR(250), | ||
+ | COMMENT VARCHAR(8000), | ||
+ | COLOR INTEGER | ||
+ | ); | ||
+ | </source> | ||
+ | |||
== Options == | == Options == | ||
+ | <source lang="sql"> | ||
+ | CREATE TABLE OPTIONS ( | ||
+ | NAME VARCHAR(100) NOT NULL, | ||
+ | VAL VARCHAR(1000) | ||
+ | ); | ||
+ | </source> | ||
+ | |||
== Program == | == Program == | ||
+ | <source lang="sql"> | ||
+ | CREATE TABLE PROGRAM ( | ||
+ | ID INTEGER, | ||
+ | NAME VARCHAR(100), | ||
+ | PATH VARCHAR(255), | ||
+ | TOTALDURATION INTEGER, | ||
+ | LASTUSED TIMESTAMP, | ||
+ | PROGTYPE INTEGER | ||
+ | ); | ||
+ | </source> | ||
+ | |||
== Pwd == | == Pwd == | ||
+ | <source lang="sql"> | ||
+ | CREATE TABLE PWD ( | ||
+ | PWDID INTEGER NOT NULL, | ||
+ | HASH VARCHAR(50) NOT NULL | ||
+ | ); | ||
+ | </source> | ||
+ | |||
== Scorecardvalues == | == Scorecardvalues == | ||
+ | <source lang="sql"> | ||
+ | CREATE TABLE SCORECARDVALUES ( | ||
+ | ID INTEGER NOT NULL, | ||
+ | GRADE NUMERIC(5,2), | ||
+ | GRADEDATE DATE | ||
+ | ); | ||
+ | </source> | ||
+ | |||
== Time_spent == | == Time_spent == | ||
+ | <source lang="sql"> | ||
+ | CREATE TABLE TIME_SPENT ( | ||
+ | SNAPDATE DATE NOT NULL, | ||
+ | MINUTESSPENT NUMERIC(14,10) NOT NULL | ||
+ | ); | ||
+ | </source> |
Revision as of 04:06, 29 March 2009
TimeSnapper has an open database model but we reserve the rights to make changes at any time without any notice!
TimeSnapper Tables
Activity
<source lang="sql"> CREATE TABLE ACTIVITY (
ID INTEGER NOT NULL, SNAPDATE TIMESTAMP NOT NULL, FILENAME VARCHAR(500), FILESIZE INTEGER, PROGRAM VARCHAR(100), PROGRAMCAPTION VARCHAR(1000), DURATION INTEGER, CRC32 INTEGER, PROGID INTEGER, PWDID INTEGER, URL VARCHAR(1000), WEBPROGID INTEGER );
</source>
Classification
<source lang="sql"> CREATE TABLE CLASSIFICATION (
ID INTEGER NOT NULL, PROGID INTEGER, KEYWORDS VARCHAR(500)
); </source>
Cloudwords
<source lang="sql"> CREATE TABLE CLOUDWORDS (
WORD VARCHAR(8000) NOT NULL, WORDTYPE INTEGER NOT NULL, TS_DEFAULT INTEGER
); </source>
Filters
<source lang="sql"> CREATE TABLE FILTERS (
NAME VARCHAR(50) NOT NULL, INCLUSIVE INTEGER NOT NULL, CONDITIONS VARCHAR(8000)
); </source>
Flag
<source lang="sql"> CREATE TABLE FLAG (
ID INTEGER NOT NULL, FLAGDATE TIMESTAMP NOT NULL, FLAGTYPE VARCHAR(20), TEXT1 VARCHAR(250), TEXT2 VARCHAR(250), TEXT3 VARCHAR(250), TEXT4 VARCHAR(250), TEXT5 VARCHAR(250), TEXT6 VARCHAR(250), COMMENT VARCHAR(8000), COLOR INTEGER
); </source>
Options
<source lang="sql"> CREATE TABLE OPTIONS (
NAME VARCHAR(100) NOT NULL, VAL VARCHAR(1000)
); </source>
Program
<source lang="sql"> CREATE TABLE PROGRAM (
ID INTEGER, NAME VARCHAR(100), PATH VARCHAR(255), TOTALDURATION INTEGER, LASTUSED TIMESTAMP, PROGTYPE INTEGER
); </source>
Pwd
<source lang="sql"> CREATE TABLE PWD (
PWDID INTEGER NOT NULL, HASH VARCHAR(50) NOT NULL
); </source>
Scorecardvalues
<source lang="sql"> CREATE TABLE SCORECARDVALUES (
ID INTEGER NOT NULL, GRADE NUMERIC(5,2), GRADEDATE DATE
); </source>
Time_spent
<source lang="sql"> CREATE TABLE TIME_SPENT (
SNAPDATE DATE NOT NULL, MINUTESSPENT NUMERIC(14,10) NOT NULL
); </source>