Project hours worked and expenses

A quick and easy to use system for keeping track of work on different projects. The sample shows some use of Functions and use of the Sum-function across relations. See also the ForEach-function if you need more advanced access of related properties. No Access or History-logging have been specified in this sample.

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

Person                                                       

   Name                                                      

   Mobil_phone                                               SMS 

   Email                                                     EMail 

   Has_done | Activity_person                                RelationManyReverseAdd 



Project                                                      

   Name                                                      

   Project_activity                                          RelationManyReverseAdd 

   Sum_hours = Project_activity.NumberOfHours.Sum            

   Sum_expenses = Project_activity.Expenses.Sum              



Activity                                                     

   Text                                                      LongText 

   Time_of_activity                                          Date  Default=Now

   Date = TimeOfActivity.DatePart                            Essential 

   Year_and_month = TimeOfActivity.ToString("yyyy-MM")       

   Year_and_quarter = TimeOfActivity.Year + " " + _

       TimeOfActivity.Quarter                                

   Type_of_activity                                          Essential 

      Meeting, Specifying, Implementing

   Done_by | Activity_person                                 RelationOne Essential 

   Project | Project_activity                                RelationOne Essential 

   Number_of_hours                                           Decimal 

   Expenses                                                  Decimal

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