The Demo Data Model

The demo data model has been developed for the book SQLScript for SAP HANA. We use here in this course the version for the English edition of the book.

This is a simple task management with the central table TASKS.

Table TASKS

ColumnDescription
IDTable key
PROJECTProject ==> PROJECTS.ID
TITLETitle
DESCRIPTIONDescription
STATUSStatus ==>STATUS.ID
ASSIGNEEProcessor ==> USERS.ID
PLANNED_EFFORTPlan expenditure
EFFORTExpenditure to date
CREATE_DATECreation date
DUE_DATEDue date
COMPLETEDPercentage of completion

Table PROJECTS

ColumnDescription
IDTable key
TITLEName of the project
PROJECT_MANAGERProject manager ==> USERS.ID
ESTIMATED_EFFORTEstimated effort
START_DATEStart date
STATUSStatus ==> STATUS.ID

Table USERS

ColumnDescription
IDTable key
FIRSTNAMEFirst name
LASTNAMELast name
EMAILE-mail address
SEXGender [‘M’|’F’]
TEAMTeam ==> TEAM_TEXT.ID

STATUS table

ColumnDescription
IDTable key
IS_FINALCompleted status [true|false]
IS_OPENOpen status [true|false]

Table STATUS_TEXT

ColumnDescription
IDStatus key ==> STATUS.ID
LANGULanguage [‘DE’, ‘EN’]
STATUS_TEXTStatus text

Table TEAM_TEXT

ColumnDescription
IDTeam Key
LANGULanguage [DE, EN]
TEAM_TEXTTeam name

Table TASK_LOG is not relevant for basic training.