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
@@ -59,13 +59,13 @@ Recurrence:\\
59 & & & & & & &\\ 59 & & & & & & &\\
60\hline 60\hline
61\end{tabular} 61\end{tabular}
62\begin{verbatim} 62\begin{verbatim}
63CREATE TABLE RECURRENCE ( 63CREATE 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,
67 RWeekDays int, 67 RWeekDays int,
68 RPosition int, 68 RPosition int,
69 RFreq int, 69 RFreq int,
70 RHasEndDate bool, 70 RHasEndDate bool,
71 REndDate DATETIME, 71 REndDate DATETIME,
@@ -125,17 +125,18 @@ Personal data: \\
125\underline{UID} & \underline{ID} & Ident & Value \\ 125\underline{UID} & \underline{ID} & Ident & Value \\
126\hline 126\hline
127 & & & \\ 127 & & & \\
128\hline 128\hline
129\end{tabular} 129\end{tabular}
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)
137); 138);
138\end{verbatim} 139\end{verbatim}
139 140
140\noindent 141\noindent
141TableID: \\ 142TableID: \\
@@ -168,16 +169,16 @@ CrossRef: \\
168\hline 169\hline
169\end{tabular} 170\end{tabular}
170\begin{verbatim} 171\begin{verbatim}
171CREATE TABLE CROSSREF ( 172CREATE TABLE CROSSREF (
172 TID1 int NOT NULL, 173 TID1 int NOT NULL,
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()
179); 180);
180\end{verbatim} 181\end{verbatim}
181 182
182 183
183\noindent 184\noindent
@@ -191,13 +192,13 @@ Category: \\
191\end{tabular} 192\end{tabular}
192\begin{verbatim} 193\begin{verbatim}
193CREATE TABLE CATEGORY ( 194CREATE TABLE CATEGORY (
194 UID int NOT NULL UNIQUE, 195 UID int NOT NULL UNIQUE,
195 Name text, 196 Name text,
196 ApplicationName text, 197 ApplicationName text,
197 ForeGroundColor text,<-- maybe hex? 198 ForeGroundColor text, <-- maybe hex?
198 BackGroundColor text, 199 BackGroundColor text,
199 PRIMARY KEY(UID) 200 PRIMARY KEY(UID)
200); 201);
201\end{verbatim} 202\end{verbatim}
202 203
203\noindent 204\noindent
@@ -234,13 +235,13 @@ CREATE TABLE APPLICATION (
234 URL text, 235 URL text,
235 PRIMARY KEY (UID) 236 PRIMARY KEY (UID)
236); 237);
237\end{verbatim} 238\end{verbatim}
238 239
239\noindent 240\noindent
240 Location: \\ 241Location: \\
241\begin{tabular}[ht]{|l|l|} 242\begin{tabular}[ht]{|l|l|}
242\hline 243\hline
243\underline{UID} & Name \\ 244\underline{UID} & Name \\
244\hline 245\hline
245 & \\ 246 & \\
246\hline 247\hline