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
@@ -53,25 +53,25 @@ CREATE TABLE DATEBOOK (
53\noindent 53\noindent
54Recurrence:\\ 54Recurrence:\\
55\begin{tabular}[ht]{|l|l|l|l|l|l|l|l|} 55\begin{tabular}[ht]{|l|l|l|l|l|l|l|l|}
56\hline 56\hline
57\underline{UID} & \underline{TID} & RType & RWeekDays & RPosition & RFreq & RHasEndDate &REndDate \\ 57\underline{UID} & \underline{TID} & RType & RWeekDays & RPosition & RFreq & RHasEndDate &REndDate \\
58\hline 58\hline
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,
72 PRIMARY KEY (UID) 72 PRIMARY KEY (UID)
73); 73);
74\end{verbatim} 74\end{verbatim}
75 75
76\noindent 76\noindent
77Addressbook: \\ 77Addressbook: \\
@@ -119,29 +119,30 @@ CREATE TABLE POSTAL (
119 119
120 120
121\noindent 121\noindent
122Personal data: \\ 122Personal data: \\
123\begin{tabular}[ht]{|l|l|l|l|} 123\begin{tabular}[ht]{|l|l|l|l|}
124\hline 124\hline
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: \\
142\begin{tabular}[ht]{|l|l|l|l|} 143\begin{tabular}[ht]{|l|l|l|l|}
143\hline 144\hline
144\underline{UID} & Name & DefaultRep & Version\\ 145\underline{UID} & Name & DefaultRep & Version\\
145\hline 146\hline
146 & & &\\ 147 & & &\\
147\hline 148\hline
@@ -162,48 +163,48 @@ CREATE TABLE TABLEID (
162CrossRef: \\ 163CrossRef: \\
163\begin{tabular}[ht]{|l|l|l|l|l|l|} 164\begin{tabular}[ht]{|l|l|l|l|l|l|}
164\hline 165\hline
165\underline{TID1} & \underline{UID1} & \underline{Item1} & \underline{TID2} & \underline{UID2} & \underline{Item2} \\ 166\underline{TID1} & \underline{UID1} & \underline{Item1} & \underline{TID2} & \underline{UID2} & \underline{Item2} \\
166\hline 167\hline
167 & & & & &\\ 168 & & & & &\\
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
184Category: \\ 185Category: \\
185\begin{tabular}[ht]{|l|l|l|l|l|l|} 186\begin{tabular}[ht]{|l|l|l|l|l|l|}
186\hline 187\hline
187\underline{UID} & Parent & Name & ApplicationName & ForeGroundColor & BackGroundColor\\ 188\underline{UID} & Parent & Name & ApplicationName & ForeGroundColor & BackGroundColor\\
188\hline 189\hline
189 & & & & &\\ 190 & & & & &\\
190\hline 191\hline
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
204Files: \\ 205Files: \\
205\begin{tabular}[ht]{|l|l|l|l|} 206\begin{tabular}[ht]{|l|l|l|l|}
206\hline 207\hline
207\underline{UID} & MimeType & URL \\ 208\underline{UID} & MimeType & URL \\
208\hline 209\hline
209 & &\\ 210 & &\\
@@ -228,25 +229,25 @@ Applications: \\
228\hline 229\hline
229\end{tabular} 230\end{tabular}
230\begin{verbatim} 231\begin{verbatim}
231CREATE TABLE APPLICATION ( 232CREATE TABLE APPLICATION (
232 UID int NOT NULL UNIQUE, 233 UID int NOT NULL UNIQUE,
233 MimeType text, -- mimetype 234 MimeType text, -- mimetype
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
247\end{tabular} 248\end{tabular}
248\begin{verbatim} 249\begin{verbatim}
249CREATE TABLE LOCATION ( 250CREATE TABLE LOCATION (
250 UID int NOT NULL UNIQUE, 251 UID int NOT NULL UNIQUE,
251 Name text, 252 Name text,
252 PRIMARY KEY (UID) 253 PRIMARY KEY (UID)