Changes regarding the tips of Robert Wittams

1 files changed, 8 insertions, 14 deletions

diff --git a/development/pim/dbpaper/rel.tex b/development/pim/dbpaper/rel.tex
index b7d0990..967155d 100644
--- a/development/pim/dbpaper/rel.tex
+++ b/development/pim/dbpaper/rel.tex
@@ -29,30 +29,24 @@ POSTAL \{ UID, TID, Type, Street, City, State, Zip, Country \} \\
 where Type can be Home, Business as predefined or any other as custom fields (not syncable) \\
 \\
 \noindent
-PERSONAL\_DATA \{ UID, ID, Item, Value \}\\
+PERSONAL\_DATA \{ UID, ID, Type, Priority, Value \}\\
 ID autoincrement \\
-Item element \{ Company, JobTitle, Department, Office, Profession, Assistant
- \footnote{What is Assistent and Manager ??  (se), and what about multiple assistents? Maybe by same UID but different ID and same Item - ugly(max)}, Manager, Spouse, Children, Gender, Birthday, Aniversary, Nickname, Note, \\
- DefaultEmail, Email, HomeWebpage, Homephone, HomeFax, HomeMobil \}\\  
+Type element \{ Personal, Company, University,  Birthday, Aniversary,  Gender, Child, Jobtitle, Department, 
+Office, Profession, Assistant, Nickname, Spouse, Manager, Note, Email, WebPage, Phone, Fax \}\\
+Priority: Highest = 1, Undefined = 0\\
 \\ 
 \noindent
 TABLEID \{ TID, Name, DefaultRep, Version \}  \\
 TID Autoincrement \\
 The first 3 TIDs are set: 0 == datebook, 1 == addressbook, 2 == todolist.\\
 The rest can are assigned in order of registration of the service/app.
-DefaultRep is the default representation. That are fields from the table of the app itself which should be shown when crosslinked. \\
+DefaultRep is the default representation. That are fields from the table of the app itself which should be shown when crosslinked\footnote{This should be described much more detailed to be clear! (se)}. \\
 \\
 \noindent
-CROSSREF \{ TID1, UID1, Item1, TID2, UID2, Item2 \}\\
-Item \emph{x} defines the field-type in the table which should be addressed. It may be empty if no special field should be addressed. \\
+CROSSREF \{ TID1, UID1, ID1, TID2, UID2, ID2 \}\\
+ID\emph{x} defines the ``line'' in the table (grouped by UID) which should be linked. It may be empty if no special field should be addressed. \\
 Maybe add a field ``discription'' like ``verwaltet'', ``schaut an''
-
-\noindent
-Thus, it is possible to crossreference i.e. a Child (Item1 = ``Child'') in the Table PERSONAL\_DATA (TID1 = 0) with an entry in the Table ADDRESSBOOK (TID= 1, Item2 = ````) which stores the data of that child.\\
-
-\noindent
-Using ``Item'' to select which element should be referenced (instead using the ID which may only exist in our table) should guarantee that this reference may survive conversions between different formats. I.e.: For converting our Database into a XML-File, the Item should be converted directly into a attribute-name which is placed into a tag. Therefore the cross reference will stay correct!
-
+\\
 \noindent
 Still unclear is, how to synchronize our database (as XML-File, directly or via C++ Interface access) with outlook or other systems, without loosing this cross reference. We could not expect that this fine granularity or referencing may be supported by other systems...\\
 \\