summaryrefslogtreecommitdiff
path: root/development/pim/dbpaper/tables.tex
Unidiff
Diffstat (limited to 'development/pim/dbpaper/tables.tex') (more/less context) (show whitespace changes)
-rw-r--r--development/pim/dbpaper/tables.tex9
1 files changed, 5 insertions, 4 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
@@ -119,28 +119,29 @@ 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 Priority int,
135 Value text, 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 & & &\\
@@ -162,28 +163,28 @@ 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 & & & & &\\