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 @@ -61,9 +61,9 @@ Recurrence:\\ \end{tabular} \begin{verbatim} CREATE TABLE RECURRENCE ( UID int NOT NULL UNIQUE, - TID int NOT NULL + TID int NOT NULL RType int, RWeekDays int, RPosition int, RFreq int, @@ -127,13 +127,14 @@ Personal data: \\ & & & \\ \hline \end{tabular} \begin{verbatim} -CREATE TABLE PERSONAL_DATA_CONTACT ( - UID int NOT NULL UNIQUE, - ID int AUTOINCREMENT, - Ident text, - Value text, +CREATE TABLE PERSONAL_DATA ( + UID int NOT NULL UNIQUE, + ID int AUTOINCREMENT, + Ident text, + Priority int, + Value text, PRIMARY KEY(UID,ID) ); \end{verbatim} @@ -170,12 +171,12 @@ CrossRef: \\ \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} @@ -193,9 +194,9 @@ Category: \\ CREATE TABLE CATEGORY ( UID int NOT NULL UNIQUE, Name text, ApplicationName text, - ForeGroundColor text, <-- maybe hex? + ForeGroundColor text, <-- maybe hex? BackGroundColor text, PRIMARY KEY(UID) ); \end{verbatim} @@ -236,9 +237,9 @@ CREATE TABLE APPLICATION ( ); \end{verbatim} \noindent -Location: \\ +Location: \\ \begin{tabular}[ht]{|l|l|} \hline \underline{UID} & Name \\ \hline |