Skip to content

Instantly share code, notes, and snippets.

@mkschulze
Created January 4, 2021 17:12
Show Gist options
  • Save mkschulze/fa03036a1aaa28ebf59e1b528e33b52a to your computer and use it in GitHub Desktop.
Save mkschulze/fa03036a1aaa28ebf59e1b528e33b52a to your computer and use it in GitHub Desktop.
define
finance sub relation,
relates allocates,
relates includes;
element sub relation,
relates holdselement,
relates iselementof;
economic_entity sub entity,
plays allocates,
key Name,
key ClientNr,
has ConsultantNr,
has IndustryKey,
has AvrgEmployees,
has LegalForm,
has PlaceOfBusiness;
financial_report sub entity,
plays includes;
#plays holdselement;
balance_sheet sub financial_report,
#plays iselementof,
has FinancialYear,
has ReportingStyle;
account sub balance_sheet,
has AccountNr,
has AccountDesignation,
has Value,
has ClosingValue,
has Symbol;
timestamp sub account,
has Date,
has Year,
has Quarter,
has Month,
has Day;
########################
# economic_entity datatypes
########################
Name sub attribute,
value string;
IndustryKey sub attribute,
value string;
AvrgEmployees sub attribute,
value long;
LegalForm sub attribute,
value string;
PlaceOfBusiness sub attribute,
value string;
########################
# balance_sheet datatypes
########################
ReportingStyle sub attribute,
value string;
ClientNr sub attribute,
value long;
ConsultantNr sub attribute,
value long;
FinancialYear sub attribute,
value long;
########################
# account datatypes
########################
AccountNr sub attribute,
value long;
AccountDesignation sub attribute,
value string;
Value sub attribute,
value double;
ClosingValue sub attribute,
value double;
Symbol sub attribute,
value string;
########################
# timestamp datatypes
########################
Date sub attribute,
value datetime;
StartDate sub attribute,
value datetime;
EndDate sub attribute,
value datetime;
Year sub attribute,
value long;
Quarter sub attribute,
value long;
Month sub attribute,
value long;
Day sub attribute,
value long;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment