summaryrefslogtreecommitdiff
path: root/development/pim/dbpaper/tables.tex
Unidiff
Diffstat (limited to 'development/pim/dbpaper/tables.tex') (more/less context) (ignore whitespace changes)
-rw-r--r--development/pim/dbpaper/tables.tex23
1 files changed, 12 insertions, 11 deletions
diff --git a/development/pim/dbpaper/tables.tex b/development/pim/dbpaper/tables.tex
index ac28a47..64ae02d 100644
--- a/development/pim/dbpaper/tables.tex
+++ b/development/pim/dbpaper/tables.tex
@@ -64,3 +64,3 @@ CREATE TABLE RECURRENCE (
64 UID int NOT NULL UNIQUE, 64 UID int NOT NULL UNIQUE,
65 TID int NOT NULL 65 TID int NOT NULL
66 RType int, 66 RType int,
@@ -130,7 +130,8 @@ Personal data: \\
130\begin{verbatim} 130\begin{verbatim}
131CREATE TABLE PERSONAL_DATA_CONTACT ( 131CREATE TABLE PERSONAL_DATA (
132 UID int NOT NULL UNIQUE, 132 UID int NOT NULL UNIQUE,
133 ID int AUTOINCREMENT, 133 ID int AUTOINCREMENT,
134 Ident text, 134 Ident text,
135 Value text, 135 Priority int,
136 Value text,
136 PRIMARY KEY(UID,ID) 137 PRIMARY KEY(UID,ID)
@@ -173,6 +174,6 @@ CREATE TABLE CROSSREF (
173 UID1 int NOT NULL, 174 UID1 int NOT NULL,
174 Item1 int NOT NULL, 175 ID1 int NOT NULL,
175 TID2 int MOT NULL, 176 TID2 int NOT NULL,
176 UID2 int NOT NULL, 177 UID2 int NOT NULL,
177 Item2 int NOT NULL, 178 ID2 int NOT NULL,
178 PRIMARY KEY() 179 PRIMARY KEY()
@@ -196,3 +197,3 @@ CREATE TABLE CATEGORY (
196 ApplicationName text, 197 ApplicationName text,
197 ForeGroundColor text,<-- maybe hex? 198 ForeGroundColor text, <-- maybe hex?
198 BackGroundColor text, 199 BackGroundColor text,
@@ -239,3 +240,3 @@ CREATE TABLE APPLICATION (
239\noindent 240\noindent
240 Location: \\ 241Location: \\
241\begin{tabular}[ht]{|l|l|} 242\begin{tabular}[ht]{|l|l|}