Diffstat (limited to 'development/pim/dbpaper/tables.tex') (more/less context) (show whitespace changes)
-rw-r--r-- | development/pim/dbpaper/tables.tex | 9 |
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 ( \noindent Personal data: \\ \begin{tabular}[ht]{|l|l|l|l|} \hline \underline{UID} & \underline{ID} & Ident & Value \\ \hline & & & \\ \hline \end{tabular} \begin{verbatim} -CREATE TABLE PERSONAL_DATA_CONTACT ( +CREATE TABLE PERSONAL_DATA ( UID int NOT NULL UNIQUE, ID int AUTOINCREMENT, Ident text, + Priority int, Value text, PRIMARY KEY(UID,ID) ); \end{verbatim} \noindent TableID: \\ \begin{tabular}[ht]{|l|l|l|l|} \hline \underline{UID} & Name & DefaultRep & Version\\ \hline & & &\\ @@ -162,28 +163,28 @@ CREATE TABLE TABLEID ( CrossRef: \\ \begin{tabular}[ht]{|l|l|l|l|l|l|} \hline \underline{TID1} & \underline{UID1} & \underline{Item1} & \underline{TID2} & \underline{UID2} & \underline{Item2} \\ \hline & & & & &\\ \hline \end{tabular} \begin{verbatim} CREATE TABLE CROSSREF ( TID1 int NOT NULL, UID1 int NOT NULL, - Item1 int NOT NULL, - TID2 int MOT NULL, + ID1 int NOT NULL, + TID2 int NOT NULL, UID2 int NOT NULL, - Item2 int NOT NULL, + ID2 int NOT NULL, PRIMARY KEY() ); \end{verbatim} \noindent Category: \\ \begin{tabular}[ht]{|l|l|l|l|l|l|} \hline \underline{UID} & Parent & Name & ApplicationName & ForeGroundColor & BackGroundColor\\ \hline & & & & &\\ |