This document outlines the models used in the SILC application, detailing their purpose, relationships, and key fields.
- Represents a SILC group.
- Fields include
name
,location
,date_started
,email
, andcontact_number
. - Links to
Member
via ForeignKey in theMember
model.
- Represents a member of a SILC group.
- Fields include
name
,id_number
,phone_number
,email
,role
,date_of_joining
,status
, andgender
. - Linked to
SILCGroup
through a ForeignKey relationship. - Serves as a foreign key target for
Saving
,Loan
,SocialFund
, andFine
models.
- Defines roles within the SILC group, such as Chairperson or Treasurer.
- Contains a
name
andpermissions
field.
- Associates
User
with aRole
in aSILCGroup
. - Uses ForeignKey relationships to link
User
,Role
, andSILCGroup
.
- Tracks savings contributions by members.
- Linked to
Member
through a ForeignKey. - Includes
amount
,date_contributed
, andnotes
.
- Records loans issued to members.
- Fields include
amount
,interest_rate
,date_issued
,repayment_due_date
, andstatus
. Member
is linked via ForeignKey.
- Manages contributions to a social fund.
- Linked to
Member
and includescontribution_amount
,date_contributed
, andpurpose
.
- Tracks fines imposed on members.
- Includes
amount
,reason
,date_issued
, andstatus
. - Linked to
Member
.
- Represents operational cycles of the SILC group, typically lasting a year.
- Contains
start_date
,end_date
, andactive
status.
- Details guarantors for loans.
- Fields include
id_number
,name
,email
,loan
, andrelationship_with_loanee
. - Linked to
Loan
via ForeignKey.
- SILCGroup to Member: One-to-Many. A group has many members.
- Member to Savings/Loans/SocialFund/Fines: One-to-Many. A member can have multiple records in each of these models.
- Loan to Guarantor: One-to-Many. A loan can have multiple guarantors.
- The application tracks all financial activities of a SILC group, including savings, loans, social fund contributions, fines, and operational cycles.
- Guarantors are associated with loans to manage risk.
- Group roles allow for role-based access and functionalities within the application.