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.)

Name Essential
Physical_person Type
Date_of_birth Date
Gender Essential
Male, Female, Unknown
Employment_relationship RelationMany
Juridical_person Type
Type_of_incorporation Essential
Limited, Partnership
Employment_relationship RelationMany
Contact_information Many
Phone, Mobil_phone, EMail_address, Facsimile
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