panSL main page
All panSL samples
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.
Description/ Descriptions Many
Organisation, Physical_person, Friend, Partner, _
Customer, Prospective_customer, Father, Mother, _
Activities| Activity_person RelationManyReverseAdd
Related_person/ Related_persons RelationMany
Hyperlink("http://www.google.com/search?q=" + _
URLEncode(FirstName + " " + LastName), _
Date_of_activityDate Essential Default=Now.DatePart
Correspondence, Demonstration, Feedback, Sales_meeting
Planned, In_progress, Finished
Note / NotesMany
Persons| Activity_person RelationMany
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