Files
cloud-cap-samples/packages/officesupplies/db/schema.cds
2020-02-27 14:57:46 +01:00

30 lines
876 B
Plaintext

namespace sap.capire.officesupplies;
using { Currency } from '@sap/cds/common';
entity Products {
@Common.Label : 'UUID'
key ID : UUID;
identifier : String @Common.Label : 'ID';
title : localized String @( Common.Label : 'Name' );
description : localized String;
availability : Integer;
storage_capacity: Integer;
criticality : Integer;
price : Decimal(9,2);
currency : Currency;
supplier : Association to Suppliers;
image_url : String;
}
entity Suppliers {
key ID : UUID;
identifier: String;
name : String;
phone : String;
building : String;
street : String @multiline;
postCode : String;
city : String;
country : String;
products : Composition of many Products on products.supplier = $self;
}