From 273d5329e29c43b287876202de2f0c500a312b7b Mon Sep 17 00:00:00 2001 From: eilers Date: Wed, 09 Oct 2002 14:36:57 +0000 Subject: Changes regarding the tips of Robert Wittams --- (limited to 'development/pim/dbpaper/rel.tex') 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...\\ \\ -- cgit v0.9.0.2