A pragmatic approach to storing contacts with roles and activities. The schema could be used as a simple sales tool. It is possible to show that persons and organisations are related to each other, but not how they are related.
The focus has been on quick and easy operation.
Note the use of Administrator-privileges restricting access. Log in is possible for all contacts since Mobile_phone is LoginIdentificator, access is therefore restricted to defined Administrators
This schema is in real world use.
Person Administrator
Description / Descriptions Many
Organisation, Physical_person, Friend, Partner, _
Customer, Prospective_customer, Father, Mother, _
Child
First_name Essential
Last_name Essential
Text LongText
Activities | Activity_person RelationManyReverseAdd
Related_person / Related_persons RelationMany
EMail_address EMail ZeroToMany
Mobile_phone SMS ZeroToMany
Landline_phone Many
Physical_address
Address1
Address2
PostalCode
City
State
Country
Google_name = _
Hyperlink("http://www.google.com/search?q=" + _
URLEncode(FirstName + " " + LastName), _
"Google name")
Administrator_person RelationMany
History Log
Activity Administrator
Date_of_activity Date Essential Default=Now.DatePart
Title Essential
TypeOfActivity Essential
Correspondence, Demonstration, Feedback, Sales_meeting
ActivityStatus Many
Planned, In_progress, Finished
Text LongText
Note / Notes Many
Note_taken Date Default=Now
Text LongText
Persons | Activity_person RelationMany
History Log
Administrator_group
Name
Administrator_person RelationMany GivingAdministrator
History Log
Note that in addition to generation of ER-Diagram the panSL Implementation AgoRapide may also be used to also generate database-schema (SQL) and source code for a variety of programming languages, tools and development architectures.
Last updated 2012-05-02
