Created
January 4, 2021 17:12
-
-
Save mkschulze/fa03036a1aaa28ebf59e1b528e33b52a to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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