CAPとSAP Fiori toolsでコーディングなしのプロトタイプを作る（2）CAPプロジェクトの作成

namespace insidetrack.sample;

entity Projects {
    key projectCode : String                   @title : 'Project Code';
        projectName : String                   @title : 'Project Name';
        toCustomer  : Association to Customers @title : 'Customer';
        toManager   : Association to Users     @title : 'Manager';
        startsAt    : DateTime                 @title : 'Starts At';
        endsAt      : DateTime                 @title : 'Ends At';
        toStatus    : Association to Status    @title : 'Status';
        toTasks     : Composition of many Tasks
                          on toTasks.projectCode = $self.projectCode;
}

entity Tasks {
    key projectCode : String                @title : 'Project Code';
    key taskId      : Integer               @title : 'Task Id';
        description : String                @title : 'Description';
        startsAt    : DateTime              @title : 'Starts At';
        endsAt      : DateTime              @title : 'Ends At';
        toStatus    : Association to Status @title : 'Status';
        toMembers   : Composition of many Members
                          on  toMembers.projectCode = $self.projectCode
                          and toMembers.taskId      = $self.taskId;
        toProject   : Association to Projects
                          on toProject.projectCode = $self.projectCode;
}

entity Members {
    key projectCode : String               @title : 'Project Code';
    key taskId      : Integer              @title : 'Task Id';
    key toMember    : Association to Users @title : 'Member';
        toTask      : Association to Tasks
                          on  toTask.projectCode = $self.projectCode
                          and toTask.taskId      = $self.taskId;
        toProject   : Association to Projects
                          on toProject.projectCode = $self.projectCode;
}

entity Customers {
    key customer : String @title : 'Customer';
        name     : String @title : 'Name';
}

entity Users {
    key user      : String @title : 'User ID';
        firstName : String @title : 'First Name';
        lastName  : String @title : 'Last Name';
        fullName  : String @title : 'Full Name';
}

entity Status {
    key status : Integer @title : 'Status';
        text   : String  @title : 'Text';
}

using insidetrack.sample as sample from '../db/data-model';

service CatalogService {
    entity Projects  as projection on sample.Projects;
    entity Tasks     as projection on sample.Tasks;
    entity Members   as projection on sample.Members;
    entity Customers as projection on sample.Customers;
    entity Users     as projection on sample.Users;
    entity Status    as projection on sample.Status;
}

projectCode;projectName;toCustomer_customer;toManager_user;startsAt;endsAt;toStatus_status
PJA00101;排水管交換;CST001;MANAGER01;2020-01-25;2020-02-4;3
PJA00102;エアコン導入;CST002;MANAGER02;2020-01-30;2020-02-14;3
PJA00103;エアコン清掃;CST003;MANAGER02;2020-11-01;2020-11-01;3
PJA00104;掃除ロボット導入;CST004;MANAGER03;2020-12-01;2021-01-31;2
PJA00105;ドローンテスト;CST004;MANAGER03;2021-04-02;2021-05-02;1