![]() |
|
|
|
|
Change By:
|
johnwoodlock
(27/Mar/13 8:05 AM)
|
|
Description:
|
group_id not populated on client loan (in group context) even when JLG type selected (thought it would always be JLG in group context but thats not a biggie)
Because a client can be in more than one group (and no group) I believe that when a client gets a loan via a group the group_id needs to be populated as well as the client_id on m_loan so we can do things like show the loans the client has in group x.
The group_id/client_id should be supported by a relationship from m_loan to m_group_client (ddl at end). Note: the m_group_client table doesn't have an id as primary key but does have group_id/client_id (which is fine, used to be the default many to many implementation before id primary keys everywhere became the fashion - for good reason of course - the key thing is when removing a client from a group the api can
't
just have an id it has to reference the group and the client ids)
So the group_id / client_id on m_loan is currently used to support both individual and group lending contexts.
To support m_group_client relationship (seems to not complain when either client_id or group_id is null - also doesn't complain when both client_id and group_id is null so should probably be
a
an
application rule that checks this case)
ALTER TABLE m_loan
ADD CONSTRAINT `fk_m_group_client_001`
FOREIGN KEY (`group_id` , `client_id` )
REFERENCES m_group_client (`group_id` , `client_id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION
, ADD INDEX `fk_m_group_client_001_idx` (`group_id` ASC, `client_id` ASC) ;
|
|
|
|
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
------------------------------------------------------------------------------
Own the Future-Intel® Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game
on Steam. $5K grand prize plus 10 genre and skill prizes.
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
