panSL main page

All panSL samples

Inheritance, different DataTypes IdentificationUsefulness

Demonstration of inheritance, how a person may be either a Physical person or a Juridical Person.
In both cases it is natural to store Contact information and Notes, while date of birth for instance is only natural to register for a Physical person.
Date of birth is specified as DataType Date.
Note also the use of Essential to specify the most important characteristics of an entity.


Try out this schema now! (please allow a few seconds for your new database to be initialized.)

Person                                   
Name Essential
Physical_person Type
Date_of_birth Date
Gender Essential
Male, Female, Unknown
Employers
Employment_relationship RelationMany
Juridical_person Type
RegistrationNumber
Type_of_incorporation Essential
Limited, Partnership
Employees
Employment_relationship RelationMany
Contact_information Many
Type_of_contact_information
Phone, Mobil_phone, EMail_address, Facsimile
Value
Note Many
Changes Log

ER-diagram (beta)

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