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
@@ -26,36 +26,30 @@ Type element \{ CompanyName, Department, Note \}\\
 \\
 \noindent
 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...\\
 \\
 \noindent
 ALARM \{ TID, UID, Sound, Day, Month, Year, Time \}\\
 TID is needed since more then one app can have alarms and UID is not necessarly unique over different apps. \\