[
https://issues.apache.org/jira/browse/FINERACT-1911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17776704#comment-17776704
]
Peter Santa commented on FINERACT-1911:
---------------------------------------
To standardise the different database dialects, PostgreSql and mySql type
mapping has changed a bit as far as the API response columnType parameter
concerned. Please note that columnType parameter values are all upper-case now.
Database types and API response columnDisplayType remained as they were.
Please see the details below.
||API type||db type
mysql||db type
postgresql||displayType||columnType
mysql||*columnType NEW*
*mysql*||columnType
postgresql||*columnType NEW*
*postgresql*||
|string|varchar(<length>)|varchar(<length>)|STRING|varchar|*VARCHAR*|character
varying|*VARCHAR*|
|number|int(11)|int4|INTEGER|int|*INTEGER*|integer|*INTEGER*|
|boolean|bit(1)|bool|BOOLEAN|bit|*BIT*|boolean|*BOOLEAN*|
|decimal|decimal(19,6)|numeric(19,6)|DECIMAL|decimal|*DECIMAL*|numeric|*NUMERIC*|
|date|date|date|DATE|date|*DATE*|date|*DATE*|
|datetime|datetime|timestamp|DATETIME|datetime|*DATETIME*|timestamp
without time zone|*TIMESTAMP*|
|text|text|text|TEXT|text|*TEXT*|text|*TEXT*|
|dropdown
codelookup|int(11)|int4|CODELOOKUP|int|*INTEGER*|integer|*INTEGER*|
|dropdown
codevalue|varchar|varchar|CODEVALUE|varchar|*VARCHAR*|character
varying|*VARCHAR*|
|entity table reference;
primary key|bigint(20)|int8|INTEGER|bigint|*BIGINT*|bigint|*BIGINT*|
> Assign Data Table to Transaction (Savings)
> ------------------------------------------
>
> Key: FINERACT-1911
> URL: https://issues.apache.org/jira/browse/FINERACT-1911
> Project: Apache Fineract
> Issue Type: New Feature
> Components: Data Tables
> Reporter: Peter Santa
> Assignee: Muthu
> Priority: Major
> Labels: BeanSalad
> Fix For: 1.9.0
>
>
> h1. Background
> Currently data tables can be assigned to several entity types, but
> transaction is not an option.
> h1. Goal
> The context is mainly Transactions of {*}Saving Accounts{*}, but it would be
> great to implement the feature generally.
> The goal would be to make it possible to
> * {*}assign data table to transactions{*}, and
> * support multi-row and single-row tables - as it is already supported for
> data tables that could be assigned to other entities.
> h1. Acceptance Criteria
> * it is supported to assign *data tables to Transaction entities* of - at
> least - savings accounts, and the solution fits into the current data table
> conception
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
