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 | |||
@@ -64,3 +64,3 @@ 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, |
@@ -130,7 +130,8 @@ Personal data: \\ | |||
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) |
@@ -173,6 +174,6 @@ CREATE TABLE CROSSREF ( | |||
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() |
@@ -196,3 +197,3 @@ CREATE TABLE CATEGORY ( | |||
196 | ApplicationName text, | 197 | ApplicationName text, |
197 | ForeGroundColor text,<-- maybe hex? | 198 | ForeGroundColor text, <-- maybe hex? |
198 | BackGroundColor text, | 199 | BackGroundColor text, |
@@ -239,3 +240,3 @@ CREATE TABLE APPLICATION ( | |||
239 | \noindent | 240 | \noindent |
240 | Location: \\ | 241 | Location: \\ |
241 | \begin{tabular}[ht]{|l|l|} | 242 | \begin{tabular}[ht]{|l|l|} |