author | eilers <eilers> | 2002-10-09 14:36:57 (UTC) |
---|---|---|
committer | eilers <eilers> | 2002-10-09 14:36:57 (UTC) |
commit | 273d5329e29c43b287876202de2f0c500a312b7b (patch) (unidiff) | |
tree | 04dfc8d29dd57dd2bea76beb98f154825ba178b3 /development/pim/dbpaper/tables.tex | |
parent | f9f2d227b3cfbc2187b4f7f535fc59f9735798d0 (diff) | |
download | opie-273d5329e29c43b287876202de2f0c500a312b7b.zip opie-273d5329e29c43b287876202de2f0c500a312b7b.tar.gz opie-273d5329e29c43b287876202de2f0c500a312b7b.tar.bz2 |
Changes regarding the tips of Robert Wittams
Diffstat (limited to 'development/pim/dbpaper/tables.tex') (more/less context) (ignore whitespace changes)
-rw-r--r-- | development/pim/dbpaper/tables.tex | 23 |
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} |
63 | CREATE TABLE RECURRENCE ( | 63 | 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, |
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} |
131 | CREATE TABLE PERSONAL_DATA_CONTACT ( | 131 | CREATE 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 |
141 | TableID: \\ | 142 | TableID: \\ |
@@ -168,16 +169,16 @@ CrossRef: \\ | |||
168 | \hline | 169 | \hline |
169 | \end{tabular} | 170 | \end{tabular} |
170 | \begin{verbatim} | 171 | \begin{verbatim} |
171 | CREATE TABLE CROSSREF ( | 172 | CREATE 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} |
193 | CREATE TABLE CATEGORY ( | 194 | CREATE 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: \\ | 241 | Location: \\ |
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 |