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 05: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>
